Detecting Long running/Blocking queries in SQL Server

There are times when SQL query blocks or delays operation in an environment and makes it very difficult to track them, there is a query mentioned on Brent’s Blog  that may help in Identifying long running blocking queries.

initially I mentioned query here along reference to Brent’s Blog, but on his suggestion I have modified the post.

Advertisements

, , ,

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: