Activity Monitor displays information about SQL Server processes and how these processes affect the current instance of SQL Server.
Activity Monitor is a tabbed document window with the following expandable and collapsible panes: Overview, Processes, Resource Waits, Data File I/O, Recent Expensive Queries, and Active Expensive Queries. When any pane is expanded, Activity Monitor queries the instance for information. When a pane is collapsed, all querying activity stops for that pane. You can expand one or more panes at the same time to view different kinds of activity on the instance.
For columns included in the Processes, Resource Waits, Data File I/O, Recent Expensive Queries, and Active Expensive Queries panes, customize the display as follows:
To rearrange column order, click the column heading and drag it to another location in the heading ribbon.
To sort a column, click the column name.
To filter on one or more columns, click the drop-down arrow in the column heading, and then select a value.
We are listening: If you find something outdated or incorrect in this article, such as a step or a code example, please tell us. You can click the This page button in the Feedback section at the bottom of this page. We read every item of feedback about SQL, typically the next day. Thanks.
|Describes how to open Activity Monitor and how to set the Activity Monitor refresh interval.||Open Activity Monitor (SQL Server Management Studio)|
|Links to topics for server performance and activity monitoring.||Server Performance and Activity Monitoring|