HADR_DBR_SUBSCRIBER_FILTER_LIST

Description

For databases utilizing Availability Groups. This accumulates while Availability Group an event publisher (e.g. an an Availability Replica) is waiting for exclusive access to the list of event subscribers. This wait type is uncommon and for internal use only

Resolved by

DBAs

Suggested solutions

  1. Small values are ignorable. However, if the values are large check the SQL Server error log for more information

Additional research

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide
Disaster Recovery Planning with Always-On Availability Groups

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index