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.