Skip to main content
How can we help?
< All Topics
Print

Redo queue size above threshold

If the redo queue size keeps growing, it can create a bottleneck in the transaction log on the primary server. If the transaction log keeps growing, the log drive can potentially run full and the primary server will stop responding.

If the Availability Group redo queue is above 100 GB, an alert will be thrown.

To query the Performance Store database for servers where the redo queue size is above the threshold, use:

select s.*
from dbo.v_databases s
where s.redo_queue_size_kb > 1024 * 1024 * 100

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents