The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes. 

Right Click Server -> Activity Monitor

The Activity Monitor is split up into a couple of different panes.

  • Overview
  • Processes
  • Resource Waits data file input output
  • Recent expensive queries
  • Active expensive queries

Last modified: January 20, 2020

Author

Comments

Write a Reply or Comment