Find Most Blocked Queries

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

Random MVP RSS Feeds

[Bill Graziano] Joe Celko's Puzzles and Answers - The Restaurant seat assignment Problem: This problem is designed... http://bit.ly/bDW6ll about 3 hours ago from twitterfeed

[Simon Sabin] Creating a unique constraint on a column that allows nulls: Primary keys, unique indexes and unique ... http://bit.ly/d4oRVC about 21 hours ago from twitterfeed

[Simon Sabin] Don’t forget today is the last day for voting – SQLBits 7: Today is the last day for voting for SQLB... http://bit.ly/cQjVnC about 23 hours ago from twitterfeed

[Simon Sabin] SQLBits7 Registration: Registration is now open for SQLBits 7. If you want to attend Thursday or Fri... http://bit.ly/aHmPpx 11:40:22 AM July 28, 2010 from twitterfeed

[Simon Sabin] Whats coming in SQL 11: I keep hearing little bits about whats coming in SQL 11 and I’m getting real... http://bit.ly/9nrbaI 06:41:19 PM July 27, 2010 from twitterfeed

[SQL Aloha] Windows OS Power Saving Feature Directly Affects CPU Performance: While I have always known that the W... http://bit.ly/czwboj 06:56:49 AM July 27, 2010 from twitterfeed

[Kalen Delaney] Geek City: My Big Fat Partitioning Query: When SQL Server first introduced table and index partiti... http://bit.ly/ds4IIN 04:34:04 PM July 26, 2010 from twitterfeed

[Kalen Delaney] Did You Know? MVP Deep Dives is Deal of the Day at Manning!: If, for who knows what reason, you ha... http://bit.ly/9KKFF8 03:31:32 PM July 26, 2010 from twitterfeed

[Simon Sabin] Make yourself heard – How to change SQL: We keep getting told that to get things changed with SQL Se... http://bit.ly/bLQ4xN 11:50:50 PM July 25, 2010 from twitterfeed

[Kalen Delaney] Did You Know: My Online Seminar Lasted Almost 5 Hours!: Yesterday was a rebroadcast of the index i... http://bit.ly/dnN7cY 12:57:24 AM July 25, 2010 from twitterfeed

SQL Server Planet

Find Most Blocked Queries

Ask a question or post a comment

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories