HADR_NOTIFICATION_WORKER_STARTUP_SYNC

Description

For databases utilizing Availability Groups. Used internally while Windows Failover Clustering is waiting for the notification task to startup. This wait is uncommon, investigation is required if the values are excessive

Resolved by

DBAs

Suggested solutions

  1. Examine Windows Failover Clustering logs for any issues
  2. Check the SQL Server error log for more information
  3. Examine wait statistics on the instance for other Availability Group issues. Investigate accordingly

Additional research

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide

⇐ Back to index