Skip to main content
Skip table of contents

How to monitor actitvity in a MS SQL Server

...and find out everything you ever wanted to know about slow queries or locks.


Open SQL Management Studio and then in the context menu of your database server the Activity Monitor:


Blocked Processes

USE Master
EXEC sp_who2

A list of processes will be displayed, and any processes which are currently in a blocked state will display the SPID of the processes blocking them in the ‘BlkBy’ column.

Expensive Queries

Use the context menu to get the query text or see the execution plan

Example Query Text

Example Execution Plan

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.