- The first thing to do is to compare the PAGEIOLATCH_SH wait count The focus now needs to switch to SQL Server to identify the cause of the . - So obviously, it is normal to encounter some PAGEIOLATCH_SH waits . When SQL Server compares these T-SQL statements it will identify .This page explains the PAGEIOLATCH_SH wait type and gives examples of PAGEIOLATCH_XX waits on sqlperformance.com - basi.y identifying the . - From MSDN: 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 .
PAGEIOLATCH_SH - SHare waiting for a data file page to be brought from disk into the buffer pool so its contents can be read; PAGEIOLATCH_EX or PAGEIOLATCH_UP - EXclusive or UPdate waiting for a data file page to be brought from disk into the buffer pool so its contents can be modified; Of these, by far the most common type is PAGEIOLATCH_SH..Handling excessive SQL Server PAGEIOLATCH_SH wait types by Nikola Dimitrijevic One of the most common wait type seen on SQL Server and definitely one that causes a lot of troubles to less experienced database administrators is the PAGEIOLATCH_SH wait type..I wrote a long article on troubleshooting PAGEIOLATCH_XX waits on sqlperformance.com - basi.y identifying the query that's doing the reads and then figuring out which table is being read from and why that data isn't already in memory.. pageiolatch_sh Shared mode page IO latch request. The PAGEIO latches are a subset of BUFlatches used when the buffer andociated data .