Sometimes it is not useful at all, specially in very skewed distributions, with many values=0. We don´t get the normality, and the problem goes on.
Moreover, it seems "going downstairs" to use a non-parametric test (eg, Rho-Spearman) instead of the parametric tests (eg, r-Pearson), more widely used.
Transforming Variables for Normality and Linearity –
When, How, Why and Why Not's:
http://support.sas.com/resources/papers/proceedings12/430-2012.pdf
Do not log-transform count data:
http://onlinelibrary.wiley.com/doi/10.1111/j.2041-210X.2010.00021.x/pdf