Monitor an Azure SQL Database geo-replicated secondary database
We have geo-replication set up for many of our production databases, and we have some processes and users that use that for executing read-only queries. We have alerts set up in Azure Monitor for simple things like when CPU % exceeds 95% for more than 2 minutes. We would like to use Redgate Monitor to identify the workload that is causing that (Top SQL). However, when we try to add the secondary server, Redgate Monitor cannot find any databases in it.
4
votes