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 > >
  • No labels