You may have seen that SP1 for SQL 2008R2 got released last week; however (as usual) looking at the master KB article listing all the fixes and changes you’d think there were no significant changes for SSAS. That’s not the case though: SP1 adds several important new trace events that can make monitoring SSAS much easier. They are documented in some detail here:

http://support.microsoft.com/kb/2458438

Highlights include the ability to see how long each command in your MDX Script takes to execute (useful when you’re trying to work out why your MDX Script takes a long time to execute – usually expensive named sets are the problem); more detail on SSAS locks; and the new Resource Usage class.

Article source: http://feedproxy.google.com/~r/wordpress/Cpjz/~3/8dhvCRgMpxY/