Open for Voting

AppInsight for SQL - Add Availability Group flag

Can we PLEASE get a flag/option [ ] in the AppInsight for SQL monitor to indicate that the App is actually mounted in an availability group.

What this would do is collect only the database names from the availability group and not all 99? from the server.

Activity would then relate only on the databases in the group and not every database on the server.

Scenario:  a server with 32 databases and 9 Availability Groups. (AGs)
When adding one database to a group I have to go into each other Server (AG) registration to "UnManage" that database.

This is very time consuming and wasteful.

Imagine what it is like when 6 databases are added to one group. Every other AppInsight for SQL on that server has to have those 6 databases individually "unmanged" ...

By flagging the Server (AppInsight for SQL ) as being an AG would enable correct monitoring of ONLY THOSE DATABASES IN THE AG without the  need to "tweek" all the others.

All DBA's /SW administrators need this.

Parents
  • Bump.

    As someone who has a dozen database servers, each with several instances, and each database has it's own availability group for highest availability. We need this. I have to make multiple tweaks on dashboards to not show the databases that are "unavailable"

Comment
  • Bump.

    As someone who has a dozen database servers, each with several instances, and each database has it's own availability group for highest availability. We need this. I have to make multiple tweaks on dashboards to not show the databases that are "unavailable"

Children
No Data