Using Activity Monitor in SQL Server Management Studio
By: Haroon Ashraf
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.
- Performance Analysis Using SQL Server 2008 Activity Monitor Tool
- Activity Monitor
- Open Activity Monitor in SQL Server Management Studio (SSMS)