Sql Server Activity Monitor

Created by
Friday, July 15, 2016

The SQL Server activity monitor is a utility for getting insight into the performance of your SQL Server. It gives analysis on what the resources are used, which expensive queries may be running and, what memory and resources are taken etc.

# 1:

Open the SQL Server Management Studio.

# 2:

Right-click the SQL Server Engine and select "Activity Monitor".

# 3:

A dialog will open as follows:

In this dialog there are multiple sections

  1. Overview
  2. Process
  3. Resource Waits
  4. Data File IO
  5. Recent Expressive Queries


# 4:

Now click the Process:

See here you will get the Session id, Database, Task State, Wait time etc information. You can change the resource by clicking the dropdown also.


# 5:

Resource Waits:

See here you will get all the information of time for the resources are waiting.

# 6:

Clicking on Data File I/O:

Here you will get all the database names of your SQL Server and the time for data interaction of each database.

# 7:

Now click on "Recent Expensive Queries".

You will get the entire query that takes the most time to execute or that takes the most resources. You will get the information of the query execution.

Conclusion: In this article I have described how to use an Activity Monitor in SQL Server Management Studio. This process is useful when a web site interacts with SQL Server and you will see what types of resources are taken.

1 2 3 4 5