Description
This wait type accumulates while SQL Server is processing pages in memory. The page is processed 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 PAGELATCH waits)
- Monitor page latches over time (see link below), confirm which database the problem is coming from
- Check the SQL Server error log, rectify any issues