Database Reference
In-Depth Information
How it works...
As discussed earlier in this chapter, all the commands are sent to the Analysis Ser-
vices instance using the XMLA language. You can review the statements SSDT cre-
ates during project deployment as well as during processing using the
SQL Server
Profiler
, which is by far the best tool for learning Analysis Services. The Profiler al-
lows choosing the type of events and columns you wish to capture and monitor. You
can invoke the Profiler by navigating to
Start
|
All Programs
|
SQL Server 2012
|
Performance Tools
|
SQL Server Profiler
. We will discuss Profiler in greater detail
later in this topic. For now, feel free to capture deployment and processing state-
ments to learn the basics of Profiler.
Search WWH ::
Custom Search