How does one monitor an Azure SQL read only replica ?
postledm
Posts: 9 New member
When we connect using SSMS etc. we would add this parameter to the conenction string
ApplicationIntent=ReadOnly
ApplicationIntent=ReadOnly
Tagged:
Answers
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
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.