Report - SQL AAG Status

Hi everybody,

I want to add some Report or Table on State of AAG SQL Servers (info as Cluster Name, Node Role, Sync Status ( if possible) on specific SQL Nodes monitored to main page of type Summary.

Is that possible?

Because when adding widget - SQL AppInsight is not visible in list of accessible components.

with regards!

Find more posts tagged with

sql

aag

solarwinds

SQL Server

solarwinds sam

Accepted answers

All comments

Seashore

First, SQL Availability Group status is not shown with AppInsight for SQL. You have to add that manually with for example a SQL query component

Second, to add the info gathered with above new monitoring, use a custom table or custom query to gather the info.

mapujece

To add a report or table for monitoring SQL Server states, you may need to create a custom widget or use an alternative monitoring tool. If SQL AppInsight is not available, ensure it is properly integrated. Alternatively, you could use a Showbarkeeper Workingflair setup to create a custom solution that tracks SQL Server cluster information. This may involve external scripts or querying SQL Server directly, then displaying it on your summary page in a format that works for your setup.