查询sqlserver执行的sql脚本

最新推荐文章于 2025-03-16 11:44:07 发布

原创最新推荐文章于 2025-03-16 11:44:07 发布 · 498 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

SQLServer 专栏收录该内容

8 篇文章

订阅专栏

本文提供了一个具体的SQL查询案例，通过特定的SQL语句筛选并分析数据库中与CI和Attribute相关的执行记录，展示如何按总耗时降序排列来定位性能瓶颈。

SELECT total_elapsed_time/1000/execution_count AS [Avg CPU Time],
execution_count AS [Exec Count],
total_worker_time/1000 AS [Total time],
total_elapsed_time/1000 AS [Elapse time],
creation_time AS [Create time],
SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2) + 1) AS [statement_text]
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
WHERE creation_time > '2016-10-19 19:55:00' and (st.text like '% CI %' or st.text like '% Attribute %')
ORDER BY total_elapsed_time DESC;

--DBCC FREEPROCCACHE