查询sqlserver执行的sql脚本

iteye_12242

于 2016-10-20 20:17:20 发布

阅读量483

点赞数

分类专栏： SQLServer 文章标签： sql

本文链接：https://blog.csdn.net/iteye_12242/article/details/82674710

版权

SQLServer 专栏收录该内容

8 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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