dbatools icon indicating copy to clipboard operation
dbatools copied to clipboard

Expose the internal HA/DR ring buffers, for better health information about Always On availability groups

Open ReeceGoding opened this issue 3 months ago • 1 comments

Summarize Command's Functionality

This official documentation shows how to query the internal ring buffers for HA/DR. It describes them by saying

The ring buffers are created during SQL Server startup, and record alerts within the SQL Server system for internal diagnostics. They aren't supported, but you can still extract valuable information from them when troubleshooting issues. These ring buffers provide another source of diagnostics when SQL Server stops responding or has crashed.

We should add this to our suite of commands for getting information about AGs.

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

I imagine that our existing commands for hitting Extended Events may be of a value.

ReeceGoding avatar Aug 28 '25 20:08 ReeceGoding

Related to #9673

ReeceGoding avatar Aug 28 '25 20:08 ReeceGoding