How can we help you today? How can we help you today?

How does one monitor an Azure SQL read only replica ?

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

ApplicationIntent=ReadOnly
postledm
0

Comments

5 comments

  • 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
    chrisqtran
    0
  • 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.

    martin01
    0
  • Yuiopg
    Yuiopg
    0
  • DavidBlaine

    You can achieve this by using an OUTER JOIN with a table or dataset that contains all possible layers and titles. This ensures that even if a filtered business unit has missing layers or titles, they still appear as blank rows in the view. You can also use COALESCE() to fill missing values with placeholders. Additionally, GROUP BY with <a href="https://jr-vape.com/">conditional aggregation</a> can help maintain structure while filtering. If you're using SQL Server, consider using a CROSS JOIN with a predefined list of layers and titles to ensure consistency across different filters.

    DavidBlaine
    0
  • Buendia123

    To monitor an Azure SQL read-only replica, you can use Dynamic Management Views (DMVs) like sys.dm_exec_requests and sys.dm_os_performance_counters. 🧠 Also, tools like Azure Monitor and Log Analytics help track performance and query activity in real time. 📊

    By the way, if you're into video editing or motion graphics during your free time, check out Alight Motion APK 🎬, an all-in-one app for creating animations, visual effects, and professional-grade videos right on your phone! 📱✨

     

    Buendia123
    0

Add comment

Please sign in to leave a comment.