we have configured SQL Server – Always On Availability group with SQL SERVER 2022 Enterprise Edition. where there is 2 instance which are also configured with Readable secondary ‘Yes’. According to my little knowledge all the read queries should return data from my secondary instances. but it didn’t happen.
i have attached my configuration[enter image description here](https://i.sstatic.net/8ZvjC4TK.png)
want to active the readable secondary replica
New contributor
user3024056 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.