Professional SQL Server™ Analysis Services 2005 with MDX

13.5. Using Profiler to Analyze Performance

SQL Server Profiler is a tool to trace operations on SQL Server and Analysis Services. This is the first release in which you have the ability to trace operations on Analysis Services through the well-known Profiler. Analysis Services exposes the commands sent to it as well as internal operations that occur within the server through what are called Events. For example, you have Events such as Command Begin, Command End, Query Begin, and Query End. Each Event has several properties associated with it such as start time, end time, and user sending the query. These properties as exposed as Event columns. SQL Profiler requests these events and event column values through a trace command to the Server. Analysis Services periodically sends the events to the clients who have subscribed to a trace. SQL Profiler shows the events and event column values in a matrix, only some columns of which might be applicable. Only administrators on Analysis Services can trace Analysis Services events. To learn more about how to use profiler follow the steps below.

1. Make sure you are an administrator on Analysis Services. You can connect to Analysis Services through SSMS and use the Analysis Services server properties dialog to add users as administrators of Analysis Services.

2. Launch SQL Server Profiler from StartAll ProgramsMicrosoft SQL Server 2005Performance ...