首页 > 其他 > 详细

IO_COMPLETION Wait Type

时间:2015-10-26 18:23:48      阅读:268      评论:0      收藏:0      [点我收藏+]

IO_COMPLETION Used to indicate a wait for I/O for operation (typically synchronous)  like sorts and various situations where the engine needs to do a synchronous I/O 

If wait times are high then you have a disk I/O bottleneck. The problem will be determining what type of operation and where the bottleneck exists. For sorts, it is on the storage system associated with tempdb. Note that database page I/O does not use this wait type. Instead look at PAGEIOLATCH waits.

 

Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os.

Data page I/O completion waits appear as PAGEIOLATCH_* waits.

 

Waits on this wait type can result from inefficient SQL statements. Tuning the SQL statement will allow it to execute while reading less data, which will reduce wait times on this event.

 

 

参考文档:

http://blog.sqlauthority.com/2011/02/10/sql-server-io_completion-wait-type-day-10-of-28/

IO_COMPLETION Wait Type

原文:http://www.cnblogs.com/ljhdo/p/4911878.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!