Description
This wait type accumulates while SQL Server during page retrieval from disk. The page is retrieved in Null mode. This mode is used internally and is not documented by Microsoft. Values in this type are rare to non-existent
Resolved by
DBAs
Suggested solutions
- Examine and rectify other wait types on the instance (in particular other PAGEIOLATCH waits)
- Check the SQL Server error log, rectify any issues
Additional research
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