Description
This wait type accumulates while SQL Server is waiting for a page to be retrieved from disk and loaded into memory. The page will be retrieved in update mode (for modify and versioning operations). If this value is high it is likely that disk or memory 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
- Data page compression if CPU usage is not suffering
Additional research
Red Gate: PAGEIOLATCH_UP
SQL Authority: PAGEIOLATCH Waits
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device