Find Most Blocked Queries

Posted by Derek Dieter
on May 31 2009

SELECT
	OBJECT_NAME(objectid)
	,BlockTime = total_elapsed_time - total_worker_time
	,execution_count
	,total_logical_reads
FROM sys.dm_exec_query_stats qs
cross apply sys.dm_exec_sql_text(qs.sql_handle)
ORDER BY total_elapsed_time - total_worker_time DESC

Related Posts:
»Find Long Running Queries
»Find Queries Using Most Memory (IO)
»Find Queries Taking Most CPU (Processor)
»Find Queries Using Most CPU
»Find Queries with Highest Reads (Highest IO)
»Find All Queries Run Against a Table
»Find Queries Performing Most Writes (Inserts)
»Find Most Executed Queries
»Find Memory Usage of Executing Procedures
»Find Most Executed Stored Procedures

Popular search terms:

Filed under DMV Queries Tagged DMV

Comment (RSS) | Permalink

post a comment OR Post Your Question on our ASK! Community!

Random MVP RSS Feeds
- [SQLTeam] How to import in BIDS more than one SSIS package in one shot!: Have you ever wanted to add more than o... http://t.co/ZfC9u8I1 about 9 hours ago from twitterfeed
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 01:33:19 AM January 31, 2012 from SQL Server Planet
- Avoiding IF.. ELSE by using WHERE EXISTS - When coming from a programming... http://t.co/QdT0Ebyq #fb 07:58:09 PM January 29, 2012 from SQL Server Planet
- DROP INDEX SYNTAX - Here is the syntax needed in o... http://t.co/ElqNyG3e #fb 07:05:16 PM January 29, 2012 from SQL Server Planet
- SET TRANSACTION ISOLATION LEVEL - This statement is used to set... http://t.co/0zGtNE1X #fb 06:10:38 PM January 29, 2012 from SQL Server Planet
- [Aaron Bertrand] Bad Habits to Kick : Thinking a WHILE loop isn't a CURSOR: I see a lot of people suggest while ... http://t.co/oDLn0pVs 10:12:20 PM January 26, 2012 from twitterfeed
- [Simon Sabin] Ten reasons to attend SQLBits X: If you are contemplating attending then I hope the following will... http://t.co/Zg6uqojD 12:54:21 PM January 26, 2012 from twitterfeed
- [Simon Sabin] SQLBits x an awesome line up –1100 people have already registered: I was really happy to have put ... http://t.co/zQu3m5ix 07:48:47 PM January 25, 2012 from twitterfeed
- [Aaron Bertrand] SQL Server 2012 : The "Launch Date" is not what you think it is: I see a lot of people getting ... http://t.co/i87shAFB 02:18:00 AM January 24, 2012 from twitterfeed
- [Aaron Bertrand] Bad Habits to Kick : Using AS instead of = for column aliases: This one is quite subjective, an... http://t.co/5uzyQWCv 05:49:21 PM January 23, 2012 from twitterfeed