Monitor Blocking Queries/Processes in SQL Server

Track blocking queries in Activity Monitor

SQL Server Management Studio provides tool called activity monitor where you can trace process utilization, memory utilization, blocker etc. below is the complete details.

Permission required to access activity monitor

To view actual activity, you must have VIEW SERVER STATE permission. To view the Data File I/O section of Activity Monitor, you must have CREATE DATABASE, ALTER ANY DATABASE, or VIEW ANY DEFINITION permission in addition to VIEW SERVER STATE.

Open Activity monitor

Press CTRL+ALT+A to open Activity Monitor at any time
Or click on the below icon to open the same.

What all you can monitor using Activity Monitor

  • %Processor Time
  • Waiting Tasks
  • Database IO
  • Batch Requests
  • Processes
  • Resource waits
  • Data File I/O
  • Recent expensive queries
  • Active expensive queries

No comments:

Post a Comment

Write a python program to find factorial of a number ?

Factorial  When we recursively multiply number incrementing from 1 to a given number then its called factorial of that number. We use the no...