How does one monitor an Azure SQL read only replica ?

postledm

When we connect using SSMS etc. we would add this parameter to the conenction string

ApplicationIntent=ReadOnly

chrisqtran

Hi @postledm

Thank you for reaching out.
 
I'm afraid that from SQL Monitor 9 and onwards we specifically only connect to the Primary.
 
This has been raised as a feature request though on our uservoice forum so you can add your vote to this if you'd like to see this feature in the future: 
 
https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/41525422-monitor-azure-sql-read-scale-out-database

martin01

Adding the ApplicationIntent=ReadOnly parameter to your connection string in SSMS ensures that the connection is directed to a read-only replica of the database. This can help offload read-heavy queries to secondary replicas, improving performance and reducing the load on the primary database instance.