search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
267 stars 62 forks source link

AG Setting Change Monitoring #1077

Open aachaemenes opened 1 month ago

aachaemenes commented 1 month ago

DBADash currently tracks changes at database level but when changes happens in AG (changing Sync mode from Sync to Async or another way around) DBADASH wont track them as a change.

These are very important changes that can help with analyzing performance issues. If someone changes AG to Sync from Async and DB size is 10 TB you will have an outage.

DavidWiseman commented 1 month ago

I might look to improve AG monitoring in future versions of DBA Dash & will consider capturing this. If someone changed this it's possible it was done to allow a failover.

aachaemenes commented 1 month ago

you can keep it manual failover with sync or async. if you change it to automatic then yes it will change that to sync by force. There are other settings in AG for backup and routing tables which should be captured when any changes are made.