Forum Discussion

sawyer_lef's avatar
7 years ago

SQL 2016 Databse Sync HA Monitor

Datasource with powershell script to monitor the Sync status of a specific database in a SQL 2016 High Availability instance.  I noticed databases can fall into NotSynchronizing status on secondary nodes often without much alerting around it.

The datasource monitors per database.  If someone has a better way that will take in the status of all databases on the instance I am open to suggestions

LM Locator: 6YD2C9