New trace events in 2008R2 SP1
Reposted from Chris Webb's blog with the author's permission.
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.
 |
Chris has been working with Microsoft BI tools since he started using beta 3 of OLAP Services back in the late 90s. Since then he has worked with Analysis Services in a number of roles (including three years spent with Microsoft Consulting Services) and he is now an independent consultant specialising in complex MDX, Analysis Services cube design and Analysis Services query performance problems. His company website can be found at http://www.crossjoin.co.uk and his blog can be found at http://cwebbbi.wordpress.com . |
Tags: management