SQLServer调优精讲

最新推荐文章于 2024-08-20 22:43:16 发布

塞外的弼马温

最新推荐文章于 2024-08-20 22:43:16 发布

阅读量82

点赞数

分类专栏：数据库文章标签：学习

本文链接：https://blog.csdn.net/u010026657/article/details/125438606

版权

数据库专栏收录该内容

8 篇文章 0 订阅

订阅专栏

1.SQL执行情况追踪
  SELECT TOP 1000 ST.text                 AS '执行的SQL语句',
                QS.execution_count      AS '执行次数',
                QS.total_elapsed_time   AS '耗时',
                QS.total_logical_reads  AS '逻辑读取次数',
                QS.total_logical_writes AS '逻辑写入次数',
                QS.total_physical_reads AS '物理读取次数',
                QS.creation_time        AS '执行时间',
                QS.*
  FROM   sys.dm_exec_query_stats QS
           CROSS APPLY sys.Dm_exec_sql_text(QS.sql_handle) ST
  WHERE  QS.creation_time BETWEEN '2022-06-23 17:00:00' AND '2022-06-23 17:30:00'
  ORDER  BY QS.creation_time DESC;