最近执行较慢的SQL
程序员文章站
2022-03-23 19:53:00
最近执行较慢的SQL
SELECT OBJECT_NAME(qt.objectid, qt.dbId) AS procName,
DB_NAME(qt.db...
最近执行较慢的SQL
SELECT OBJECT_NAME(qt.objectid, qt.dbId) AS procName, DB_NAME(qt.dbId) AS [db_name], qt.text AS SQL_Full, SUBSTRING( qt.text, (qs.statement_start_offset / 2) + 1, ( ( CASE statement_end_offset WHEN -1 THEN DATALENGTH(qt.text) ELSE qs.statement_end_offset END - qs.statement_start_offset ) / 2 ) + 1 ) AS SQL_Part --统计对应的部分语句 , qs.creation_time, qs.last_execution_time, qs.execution_count, qs.last_elapsed_time / 1000000 AS lastElapsedSeconds, qs.last_worker_time / 1000000 AS lastCpuSeconds, CAST( qs.total_elapsed_time / 1000000.0 / ( CASE WHEN qs.execution_count = 0 THEN -1 ELSE qs.execution_count END ) AS DECIMAL(28, 2) ) AS avgDurationSeconds, CAST(qs.last_logical_reads AS BIGINT) * 1.0 / (1024 * 1024) * 8060 AS lastLogicReadsMB, qs.last_logical_reads, qs.plan_handle FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS p WHERE qs.last_execution_time >= CONVERT(CHAR(10),GETDATE(),120)+' 08:00' --今天8点之后的慢SQL AND qs.last_elapsed_time >= 3 * 1000 * 1000 --只取执行时间大于 3 秒的记录 AND qt.[text] NOT LIKE '%Proc_DBA%' ORDER BY qs.last_worker_time DESC
上一篇: C语言结构体与共用体的用法
下一篇: C语言程序设计练习之2012 素数判定