Monitor Azure SQL Read Scale-out Database
I would like to monitor the Read Scale-out Azure SQL DB that gets created when on Business Critical tier.
We are moving our Read queries to this database using "ApplicationIntent=ReadOnly" specified in the connection string. SQL Monitor allows to configure the primary for monitoring but provides no options to add a connection string when adding a server so am unable to add the secondary read-only DB for monitoring.
42
votes
Praveen
shared this idea
-
Max
commented
This is a must have feature if Redgate is serious about monitoring Azure SQL Databases. Currently there is no way to monitor the Read Replica.
-
Ria K commented
That would be really helpful since we would like to identify the kind of queries that are running on the secondary.
-
Aaron LaBeau commented
This would also be helpful for me.