The Non-Page Latch wait type category includes all the waits that are caused when a task is waiting for a latch that is not related to paging, including the following:

• LATCH_DT
• LATCH_EX
• LATCH_KP
• LATCH_NL
• LATCH_SH
• LATCH_UP
• TRAN_MARKLATCH_DT
• TRAN_MARKLATCH_EX
• TRAN_MARKLATCH_KP
• TRAN_MARKLATCH_NL
• TRAN_MARKLATCH_SH
• TRAN_MARKLATCH_UP

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >