The Non-I/O Page Latch wait type category includes all the waits that are associated with non-I/O page latch bottlenecks, including the following:

  • PAGELATCH_DT
  • PAGELATCH_EX
  • PAGELATCH_KP
  • PAGELATCH_NL
  • PAGELATCH_SH
  • PAGELATCH_UP

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