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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index