Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Activity Monitor in SQL Server Management Studio (SSMS) displays information about SQL Server processes and how these processes affect the current instance of SQL Server. 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.
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, select the column heading and drag it to another location in the heading ribbon.
To sort a column, select the column name.
To filter on one or more columns, select the dropdown arrow in the column heading, and then select a value.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Monitor a Microsoft Fabric data warehouse - Training
A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.