Using Activity Monitor in SQL Server Management Studio



By:
Overview

Activity Monitor displays information about current SQL Server processes and how these processes affect the current instance of SQL Server. Activity Monitor is mainly for monitoring of SQL Server with respect to databases and their queries and other measures to help understand what is impacting SQL Server at the current time.  This can help you troubleshoot issues as well as see how SQL Server is using server resources.

How to Access Activity Monitor in SSMS

To open Activity Monitor right click on the SQL Server instance name and click Activity Monitor. As you can see below, there are several types of information you can review such as processes, resource waits, expensive queries, etc.

Activity Monitor
Related Information

Last Update: 2/6/2020






Comments For This Article





download








get free sql tips
agree to terms


Learn more about SQL Server tools