Skip to main content
Database Administrators

Return to Question

Fixed image link; added tags
Source Link
Paul White ♦
Paul White ♦
  • 90.3k
  • 30
  • 423
  • 663

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 hereRead-only routing summary

I want to active the readable secondary replica.

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

I want to active the readable secondary replica.

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

Read-only routing summary

I want to active the readable secondary replica.

Post Migrated Here from stackoverflow.com (revisions)
Source Link
user3024056
user3024056

AlwaysOn Availability Secondary replica not work as read only

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

I want to active the readable secondary replica.