Analysis Services Sessions


Analysis Services Sessions


The SSAS sessions screen displays 3 tabs: All, Blocking & Blocked. These in turn display all sessions, sessions that are blocking other sessions and finally sessions being blocked by other sessions.

SSAS sessions

The grids of sessions details update themselves in real time. Pressing the "Pause Grid" button at the bottom of the screen will freeze the data in the grid until you press the button again.
The following are the properties shown for each session:
  • - Spid
  • - User Name
  • - Database Name
  • - Status
  • - Cpu time Ms
  • - Last command
  • - Last Command Start Time
  • - Last Command End Time
  • - Memory Kb
  • - Read Kb

Clicking on a sessions row will show you the last query it ran on the server in the lower pane of the window.

This view makes it very easy to get a "At A Glance" picture of sessions in the instance.
Being able to instantly which sessions are active & potentially blocking and where memory & CPU is being consumed can help troubleshoot performance problems highly effectively.