Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Latches are lightweight, fast methods of managing concurrency on a specific resource.
PAGELATCH_* group of latches are seen in management of data pages that have already been read into memory.
PAGELATCH_NL mode is for Microsoft internal use and there is little evidence of it being seen in the real world.
How to reduce this wait
Waits on the
PAGELATCH_* series of latches can be caused by hot pages in tables or indexes where the update or concurrency rate is very high, or due to pressure on TempDB.
Tempdb issues can be investigated using this article Breaking Down TempDB Contention
Using the the Microsoft white paper on Diagnosing and Resolving Latch Contention will help you find out what is going on and point your in the right direction to resolve your issue.
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - PAGELATCH_NL
- Ecosia Search for sqlserver - PAGELATCH_NL
- Bing Search for sqlserver - PAGELATCH_NL