PAGEIOLATCH_NL

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

  1. Examine and rectify other wait types on the instance (in particular other PAGEIOLATCH waits)
  2. Check the SQL Server error log, rectify any issues

Additional research

SQL Authority: PAGEIOLATCH Waits

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