Troubleshooting REDO queue build-up (data latency issues) on AlwaysOn Readable Secondary Replicas using the WAIT_INFO Extended Event

PROBLEM You have confirmed excessive build up of REDO queue on an AlwaysOn Availability Group secondary replica by one of the following methods: Querying sys.dm_hadr_database_replica_states and observing a high value for redo_queue_size You have looked at the redo_queue_size in the dashboard view for an AlwaysOn secondary replica You have observed a high value for the … Continue reading Troubleshooting REDO queue build-up (data latency issues) on AlwaysOn Readable Secondary Replicas using the WAIT_INFO Extended Event