Description
This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page collected will be used for a shared purpose (read operation). If this value is high it is likely disk or memory available are not keeping up with the workload
Resolved by
DBAs
Suggested solutions
- Add additional memory
- Investigate disk latency
- Increase the maximum memory allocation
- Indexing, look for high disk I/O queries
- Enable data page compression if CPU usage is not suffering
Additional research
Handling excessive SQL Server PAGEIOLATCH_SH wait types
Knee-Jerk Wait Statistics : PAGEIOLATCH_SH
SQL Authority: PAGEIOLATCH Waits