Database Reference
In-Depth Information
ies. You can also disconnect a dormant session by clicking on the
Cancel Session button.
CPU : This page allows you to review the CPU time used by the ses-
sion as well as the last command executed on the session.
I/O : This page displays the number of reads and writes as well as the
kilobytes read and written by each session.
Objects : This page shows the CPU time and number of reads affect-
ing each dimension and partition. This page also shows the full path
to the object's parent; this is useful if you have the same naming con-
vention for partitions in multiple measure groups. Not only do you see
the partition name, but also the full path to the partition's measure
group. This page also shows the number of aggregation hits for each
partition. If you find that a partition is frequently queried and requires
many reads, you should consider building aggregations for it.
Locks : This page displays the locks currently in place, whether
already granted or waiting. Be sure to check the Lock Status
column—the value of 0 indicates that the lock request is currently
blocked.
Rules : This page allows defining conditions that will result in an alert.
For example, if the session is idle for over 30 minutes or if an MDX
query takes over 30 minutes, you should get alerted.
How it works...
Activity Viewer monitors Analysis Services using Dynamic Management Views
( DMV ). In fact, capturing queries executed by Activity Viewer using SQL Server Pro-
filer is a good way of familiarizing yourself with SSAS DMV's.
For example, the Current Queries page checks the $sys-
tem.DISCOVER_COMMANDS DMV for any actively executing commands by running
the following query:
SELECT
SESSION_SPID,COMMAND_CPU_TIME_MS,COMMAND_ELAPSED_TIME_MS,
COMMAND_READ_KB,COMMAND_WRITE_KB, COMMAND_TEXT
FROM $system.DISCOVER_COMMANDS
Search WWH ::




Custom Search