WAIT TYPE:PAGEIOLATCH_SH
来源:互联网 发布:交大网络教育学院登录 编辑:程序博客网 时间:2024/05/21 22:50
PAGEIOLATCH_SH: Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode. PAGEIOLATCH_SH waits is very brief as they are only held on a page during IO operations.
You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits when a page is accessed for reading or writing and the page is not available in the buffer pool. When the page is not found in the buffer pool, an asynchronous I/O is posted and then the status of the I/O is checked. If I/O has already completed, the worker proceeds normally. Otherwise, it waits on PAGEIOLATCH_EX or PAGEIOLATCH_SH, depending upon the type of request. The following DMV query can be used to find I/O latch wait statistics.
Select wait_type,
waiting_tasks_count,
wait_time_ms
from sys.dm_os_wait_stats
where wait_type like 'PAGEIOLATCH%'
order by wait_type
More detail information on performance probblems in SQL Server 2005, please navigate to the following article.
Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
- WAIT TYPE:PAGEIOLATCH_SH
- sysprocesses wait type
- Reducing SQL Server CXPACKET Wait Type
- SQL 各种锁等待类型 wait type
- SQL 各种锁等待类型 wait type
- SqlServer中wait type类型及说明
- [SQL SERVER] CXPACKET-Parallelism Wait Type的惯用解决方案
- SQL 各种锁等待类型 wait type--sys.dm_os_wait_stats 表
- SQL Server is blocked by CXPACKET(Wait Type)
- SQL SERVER CXPACKET-Parallelism Wait Type 的解决方案
- SQL 各种锁等待类型 wait type--sys.dm_os_wait_stats 表
- Wait
- wait
- wait
- wait()
- wait
- wait
- wait()
- C语言实现函数模板
- hdu1128 Self Numbers
- linux注册设备驱动的理解
- Linux文件系统十问
- QXL驱动分析(二)——FindAdapter
- WAIT TYPE:PAGEIOLATCH_SH
- Thinking in Java [Java编程机制] 学习笔记 -- Priority Queue
- js 验证 商品货号并批量生成
- Android中AppWidget详解
- 有关Eclipse的自动完成&代码整理
- HDU2650(高斯整数环)
- 近期小结( ——2013.8.16)
- [leetcode] Remove Duplicates from Sorted List
- Deep Learning(深度学习)学习笔记整理系列之(一)