Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

New trace events in 2008R2 SP1

leave a comment »

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.

Written by Chris Webb

July 18, 2011 at 11:48 am

Posted in Analysis Services

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,301 other followers

%d bloggers like this: