Find Queries with Highest Reads (Highest IO)

Posted by Derek Dieter
on June 19 2009

   SELECT TOP 10
		'Procedure'			= qt.text
		,DiskReads			= qs.total_physical_reads	-- The worst reads, disk reads
		,MemoryReads		= qs.total_logical_reads	--Logical Reads are memory reads
		,Executions			= qs.execution_count
		,CPUTime			= qs.total_worker_time
		,DiskWaitAndCPUTime = qs.total_elapsed_time
		,MemoryWrites		= qs.max_logical_writes
		,DateCached			= qs.creation_time
		,DatabaseName		= DB_Name(qt.dbid)
		,LastExecutionTime	= qs.last_execution_time
    FROM sys.dm_exec_query_stats AS qs
    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
    ORDER BY qs.total_physical_reads +  qs.total_logical_reads 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 Queries with Highest Reads (Highest IO)

Ask a question or post a comment

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories