O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Monitoring Analysis Services Using SQL Server Profiler

SQL Server Profiler can capture events from Analysis Services to help you monitor and troubleshoot performance. Not only can you spot operations that are running slowly, but you can also view the actual Analysis Services Scripting Language (ASSL), Multidimensional Expressions (MDX), and Structured Query Language (SQL) statements that are executed. You can view the events as they occur and you can also create a record of the events, called a trace, in a SQL Server table or a file for later review or playback.

When you create a SQL Server Profiler trace, you give the trace a name, select an Analysis Services server that you want to monitor, and designate the file or SQL Server table where you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required