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

6 comments

Sort by
  • 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
    -1
  • Yuiopg
    informative
    Yuiopg
    -1
  • 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
    -1
  • 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
    -1
  • Jaims

    Really helpful thread — the insights about monitoring Azure SQL read-only replicas through DMVs and Azure Monitor make a lot of sense. It’s great to see how developers here share practical solutions for improving performance and monitoring setups.

    By the way, when I’m not diving into database performance, I usually work on motion design projects, and I’ve found super useful for learning quick video editing and animation tips using Alight Motion. Definitely worth checking out if you like creative side projects alongside tech work! Visit Here

    Jaims
    -1

Add comment

Please sign in to leave a comment.