你的位置:首页 > 数据库

[数据库]WaitType:整理常见的Wait Type

1,DISPATCHER_QUEUE_SEMAPHORE

当一个Thread 等待处理更多的Work时发生,如果Wait Time增加,说明调度器(Dispatcher)非常空闲;该WaitType不会成为竞争资源,而将其他事务阻塞,在做Wait统计分析,可以过滤掉。

Occurs when a thread from the dispatcher pool is waiting for more work to process. The wait time for this wait type is expected to increase when the dispatcher is idle. This wait type is when a thread from a special dispatcher pool is waiting for work to do. The only part of SQL Server that I know uses its own thread pool is the backup subsystem in the Storage Engine.

 

 

 

 

 

参考文档:

sys.dm_os_wait_stats (Transact-SQL)

DISPATCHER_QUEUE_SEMAPHORE