Using Activity Monitor in SQL Server Management Studio


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

Comments For This Article

Friday, July 29, 2022 - 3:15:28 PM - Steve Sherman Back To Top (90322)
What SQL version first had activity monitor

get free sql tips
agree to terms