search

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
MIT License
348 stars 99 forks source link

Add REDO_THREAD_PENDING_WORK to ignorable wait types in reports #251

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

https://github.com/microsoft/SqlNexus/blob/7a86cbf3a1ea46de7c834a51d2fb74a63ac5d12e/sqlnexus/PerfStatsAnalysis.sql#L577

PiJoCoder commented 1 year ago

This wait type would be high if no log records coming on the primary. Confirmed in https://www.sqlskills.com/help/waits/redo_thread_pending_work/ can be ignored

PiJoCoder commented 1 year ago

Before the fix

image

After the fix (same data set)

image