SQL Server中查询CPU占用高的SQL语句

最新推荐文章于 2024-07-05 14:36:55 发布

isoleo

最新推荐文章于 2024-07-05 14:36:55 发布

阅读量1.4w

点赞数 3

分类专栏： sql server 文章标签： sql cpu

本文链接：https://blog.csdn.net/isoleo/article/details/44021287

版权

SQL Server中查询CPU占用高的情况，会用到sys.sysprocesses ,dm_exec_sessions ,dm_exec_requests

一、查看当前的数据库用户连接有多少

USE master

SELECT * FROM sys.[sysprocesses] WHERE [spid]>50 --AND DB_NAME([dbid])='gposdb'

SELECT COUNT(*) FROM [sys].[dm_exec_sessions] WHERE [session_id]>50

二、选取前10个最耗CPU时间的会话

SQL 代码复制


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 '