摘要： 找出是否存在一个或多个等待获取 tempdb 中页面锁存器的线程SELECT session_id,wait_type, wait_duration_ms, resource_descriptionFROM sys.dm_os_waiting_tasksWHERE wait_type LIKE 'PAGE%LATCH_%' AND resource_description LIKE '2:%'下面... 阅读全文