sql 查询耗时的CPU资源

最新推荐文章于 2022-09-20 14:55:49 发布

xiaonibaba

最新推荐文章于 2022-09-20 14:55:49 发布

阅读量907

点赞数

分类专栏： c# 文章标签： sql query

本文链接：https://blog.csdn.net/a22698488/article/details/6099529

版权

c# 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

SELECT
      total_cpu_time,
      total_execution_count,
      number_of_statements,
      s2.text,
      (SELECT SUBSTRING(s2.text, statement_start_offset / 2, ((CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(NVARCHAR(MAX), s2.text)) * 2) ELSE statement_end_offset END) - statement_start_offset) / 2) ) AS query_text
FROM
      (SELECT TOP 50
            SUM(qs.total_worker_time) AS total_cpu_time,
            SUM(qs.execution_count) AS total_execution_count,
            COUNT(*) AS number_of_statements,
            qs.sql_handle,
            MIN(statement_start_offset) AS statement_start_offset,
            MAX(statement_end_offset) AS statement_end_offset
      FROM
            sys.dm_exec_query_stats AS qs
      GROUP BY qs.sql_handle
      ORDER BY SUM(qs.total_worker_time) DESC) AS stats
      CROSS APPLY sys.dm_exec_sql_text(stats.sql_handle) AS s2