SQL Server: Script to find waiting Queries which are block by other running Queries

In this post, I am sharing one script to find a list of queries which are blocked by other running queries of SQL Server.

DBAs are always seeking for long running queries, most resources consumed query. Using this script DBA can find list of waiting queries which are not under any type of execution.

DBAs can use this query to prevent the deadlock also because long running block transactions can occur a deadlock situation.

Here, You can also access few related articles:

SQL Server: Script to find TOP 20 most used or executed SQL Queries

SQL Server: Script to find top 20 running query, which are utilizing more CPU

SQL Server: 8 different ways to Detect a DeadLock in a Database

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com