] AS '等待资源类型',
[wait_time] AS '等待时间',
[wait_resource] AS '等待的资源',
[reads] AS '物理读次数',
[writes] AS '写次数...[database_id])='gposdb'
ORDER BY [cpu_time] DESC
3.查看具体的SQL语句,需要在SSMS里选择以文本格式显示结果
--在SSMS里选择以文本格式显示结果...6.查看会话中有多少个worker在等待
SELECT TOP 10
[session_id],
[request_id],
[start_time] AS '开始时间',
[status]...[wait_type] AS '等待资源类型',
[wait_time] AS '等待时间',
[wait_resource] AS '等待的资源',
[dows]....[Total Cost] DESC;
----
本文作者:老徐
本文链接:https://bigger.ee/archives/16.html
转载时须注明出处及本声明