Posts Tagged SQL locking

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

, , ,

Leave a comment