Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Enable Query Store for collection on a read-only replica in an Availability Group

Currently, Query Store can only be enabled for the read-write database in Availability Group. As many customers issue queries against the read-only replicas, capturing query and performance metrics for those queries would be beneficial for understanding the workload, troubleshooting performance issues, etc.

84 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Steve Strelzyk commented  ·   ·  Flag as inappropriate

        I agree with Alex Friedman. Our environment uses Read-Only replicas to direct reporting traffic. Couldn't the framework determine if the database is part of an availability group and direct the DML to QA using the ag listener name. That way data still rights to the same place and is replicated around everywhere?

      • Alex Friedman commented  ·   ·  Flag as inappropriate

        This will be invaluable for us, and assist us in growing and directing more traffic to secondary replicas. Please give it priority.

      Feedback and Knowledge Base