Database Reference
In-Depth Information
Monitoring processing with trace data
Analysis Services generates trace data about its internal operations. This data allows
us to analyze the start and end times of many operations, including processing
operations. There are several tools that we can use to retrieve this data.
SQL Server Profiler,
The first tool we'll look at is the SQL Server Profiler, which (despite its name) is a tool
that can collect both SQL Server and Analysis Services trace data. After connecting
to Analysis Services to initiate a new trace session, we have to choose the events
we want to capture and where to save them (for example, either to a file or to SQL
Server table). The events that we need to monitor for processing operations are as
shown in the following screenshot:
Search WWH ::
Custom Search