How do you use cloud databases? Take the survey.
Redgate loses Wait / Query data when RDS deadlock occurs
I recently enabled deadlock traces for my monitored RDS instances, and I noticed at the exact minute a deadlock would be recorded in the error logs was the exact minute when Redgate would lose the ability to gather Waits / Top Queries / Top Waits metrics. After restarting the Base Monitor, the Web Server, and retrying the connection to the RDS instance, this information would begin to be collected again. Is there a reason this is occurring? Deadlocks aren't being reported inside Redgate, only inside AWS. There are two traces that you can enable in AWS parameter groups for deadlocks, and both are enabled.
0 · Share on Twitter