Dev::SQL Server

I/O 비용이 가장 높은 Query 조회

bluemong 2010. 11. 30. 18:24
반응형
SELECT TOP 10
 [Average IO] = (total_logical_reads + total_logical_writes) / qs.execution_count
,[Total IO] = (total_logical_reads + total_logical_writes)
,[Execution count] = qs.execution_count
,[Individual Query] = SUBSTRING (qt.text,qs.statement_start_offset/2,
         (CASE WHEN qs.statement_end_offset = -1
            THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
          ELSE qs.statement_end_offset END - qs.statement_start_offset)/2)
        ,[Parent Query] = qt.text
,DatabaseName = DB_NAME(qt.dbid)
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
ORDER BY [Average IO] DESC;

'Dev::SQL Server' 카테고리의 다른 글

Index 조각화된 상태 조회  (0) 2010.11.30
Index Rebuild, Reorgnize  (0) 2010.11.30
CPU 비용이 가장 높은 Query 확인  (0) 2010.11.30
SQL Server 2005  (0) 2010.05.03
NULL 데이터가 있는 table 조회  (0) 2010.04.30