27,579
社区成员
发帖
与我相关
我的任务
分享
--查看TempDB是否有分配争用
SELECT session_id, wait_duration_ms, resource_description
FROM sys.dm_os_waiting_tasks
WHERE wait_type like 'PAGE%LATCH_%' AND resource_description like '2:%'
SELECT *
FROM sys.sysprocesses
WHERE lastwaittype like 'PAGE%LATCH_%' AND waitresource like '2:%'