Update AppInsight for SQL to recognize Always-On Availability Groups status

[stevenstadel]

The overall status of the secondary AppInsight for SQL is always showing an Unknown Status.

Update the AppInsight SQL template to support Always-On to identifying databases that are in a secondary condition as a valid status.

[sturdyerde]

Bump. The low number of votes on this may indicate a relatively low usage of AOAGs, but does not indicate their level of criticality.

[300]

I was also looking for a component monitor in "Appinsight for SQL" template specifically for AlwaysOn. Our DBA team is looking for that feature.

[dilbert1234]

We have hundreds of AlwaysOn. The lack of this feature will puts the entire AppInsight Monitor in an unknown state for any node that is not running the database.

[grantallenby]

Bump

[ales.vrbas]

yes, please. That would make the tool a bit more complete 😉