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 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.
Explanation
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.
Additional Information
- Performance Analysis Using SQL Server 2008 Activity Monitor Tool
- Activity Monitor
- Open Activity Monitor in SQL Server Management Studio (SSMS)
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
What SQL version first had activity monitor