Drilldown on resource usage and activity information for open connections and sessions, and for commands currently running or last ran on the Analysis Services server.
How to open the Activity drilldown
From the Spotlight Client
- Select the connection from the left Connections pane.
- Click Monitor | Activity from the ribbon.
Tip: Click for more information on using Spotlight Charts and Spotlight Grids.
About the Activity drilldown
Note: All times shown in the grids of the Activity drilldown are displayed as Greenwich mean time (GMT).
Connections page
Investigate open connections on the server. The Connections grid provides resource usage and activity information.
Sessions page
Investigate open sessions on the server. The Sessions grid provides resource usage and activity information.
Commands page
Investigate the commands that are currently running or last ran. The Commands grid provides resource usage and activity information for currently running or last ran commands on the server.
Note: The Commands page requires SQL Server Analysis Services 2008 or later.