查看耗时长，CPU 100% 的SQL

最新推荐文章于 2025-05-24 00:15:14 发布

weixin_30628077

最新推荐文章于 2025-05-24 00:15:14 发布

阅读量118

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/runliuv/p/10231647.html

本文介绍了一个SQL Server性能监控的查询语句，通过该语句可以获取数据库'PayLog'中会话的详细信息，包括会话ID、请求ID、开始时间、状态、命令、SQL语句、数据库名、阻塞会话的ID、等待资源类型、等待时间、等待的资源、物理读次数、写次数、逻辑读次数和返回结果行数。这些信息对于理解数据库的运行状况和解决性能瓶颈至关重要。

SELECT TOP 10
[session_id],
[request_id],
[start_time] AS '开始时间',
[status] AS '状态',
[command] AS '命令',
dest.[text] AS 'sql语句', 
DB_NAME([database_id]) AS '数据库名',
[blocking_session_id] AS '正在阻塞其他会话的会话ID',
[wait_type] AS '等待资源类型',
[wait_time] AS '等待时间',
[wait_resource] AS '等待的资源',
[reads] AS '物理读次数',
[writes] AS '写次数',
[logical_reads] AS '逻辑读次数',
[row_count] AS '返回结果行数'
FROM sys.[dm_exec_requests] AS der 
CROSS APPLY 
sys.[dm_exec_sql_text](der.[sql_handle]) AS dest 
WHERE [session_id]>50 AND DB_NAME(der.[database_id])='PayLog'  
ORDER BY [cpu_time] DESC