SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server
Microsoft has released a valuable white paper with a self-explaining title: SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services.
The document has a part of explanation of terms and counters, and a large part of sample queries with a detailed tutorial teaching how to use SQL Profiler, with many comments about obtained results.
It's a must read.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Marco Russo (SQLBI)
Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies.
He runs the SQLBI.EU website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on.
Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.