Skip to content
«
»
 

Find Long Running Queries

Posted by 
on  June 17 2009 
SELECT TOP 10
ObjectName			= OBJECT_NAME(qt.objectid)
,DiskReads			= qs.total_physical_reads -- The worst reads, disk reads
,MemoryReads		= qs.total_logical_reads  --Logical Reads are memory reads
,Executions			= qs.execution_count
,AvgDuration		= qs.total_elapsed_time / 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)
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
WHERE qt.dbid = db_id() -- Filter by current database
ORDER BY qs.total_elapsed_time DESC


Popular search terms:
Filed under DMV Queries
Comment (RSS)  |  Permalink

One Comment

  1. Anonymous says:
    September 26, 2011 at 10:57 am

    Msg 102, Level 15, State 1, Line 13
    Incorrect syntax near ‘.’.

    Reply to this comment

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

«
»