Skip to content

Latest commit

 

History

History
32 lines (24 loc) · 2.08 KB

activity-monitor.md

File metadata and controls

32 lines (24 loc) · 2.08 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Activity Monitor
Learn how to use Activity Monitor in SQL Server Management Studio to display information about SQL Server processes and how these processes affect the current instance of SQL Server.
MikeRayMSFT
mikeray
12/04/2023
sql
performance
conceptual
Activity Monitor [SQL Server]

Activity Monitor

[!INCLUDE SQL Server]

Activity Monitor in SQL Server Management Studio (SSMS) displays information about [!INCLUDE ssNoVersion] processes and how these processes affect the current instance of [!INCLUDE ssNoVersion]. We recommend that you download and install the latest version of SSMS.

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.

Customize columns

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:

  1. To rearrange column order, select the column heading and drag it to another location in the heading ribbon.

  2. To sort a column, select the column name.

  3. To filter on one or more columns, select the dropdown arrow in the column heading, and then select a value.

Related content