Using SQL Profiler to Tune MDX Queries

posted by  johnb (89)  14 months ago (feeds.penton.com)

I've been evangelizing the use of SQL Profiler to define and identify SQL Server performance problems since the tool was first released with SQL Server 7.0. I've always felt that SQL Profiler--and the underlying SQL Trace technology--is the single most valuable tool in a DBA's arsenal for identifying most performance problems. SQL Profiler is still a somewhat underutilized tool, but over the years, a growing amount of literature and best practices have been published so that DBA's now have a fighting chance of using SQL Profiler effectively for relational engine analysis. However, SQL Profiler