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.
Mirza Baig commented
This will be a huge benefit in performance tuning the readable secondary. It will make the readable secondary in the AG more usable. The workload is different anyway between the primary and secondary so it is better to have query store capture data separately for readable secondary.
Justin Hoffmann commented
This would also be extremely valuable to my company.
Durgaprasad Potnuru commented
This will be invaluable for us too, and assist us in growing and directing more traffic to secondary replicas. Please give it priority.
Steve Strelzyk commented
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?
the question is where to store as the dB on Replica is ReadOnly, TempdB?
Alex Friedman commented
This will be invaluable for us, and assist us in growing and directing more traffic to secondary replicas. Please give it priority.