Performance Optimization - Professional SQL Server Analysis Services 2005 with MDX - page 707

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 opera-
tions on Analysis Services through the well-known Profiler. Analysis Services
exposes the commands sent to it as well as internal operations that occur with-
in 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 applic-
able. 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 Start All Programs Microsoft SQL
Server 2005 Performance Tools SQL Server Profiler.
3. You will now see the SQL Server Profiler application. Create a new
trace by selecting File New Trace.
4. You will see the Connect to Server dialog shown in Figure 13-40 .
Select the Server type as Analysis Services and type the machine
name of your Analysis Services instance.