你的位置:首页 > 软件开发 > 数据库 > WaitType:整理常见的Wait Type

WaitType:整理常见的Wait Type

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

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


原标题:WaitType:整理常见的Wait Type

关键词:

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

可能感兴趣文章

我的浏览记录