PAGELATCH_NL

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

  1. Examine and rectify other wait types on the instance (in particular other PAGELATCH waits)
  2. Monitor page latches over time (see link below), confirm which database the problem is coming from
  3. Check the SQL Server error log, rectify any issues

Additional research

Diagnosing and Resolving Latch Contention

⇐ Back to index