Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Read-only queries on Always On mirror Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 6:11 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 18, 2014 9:32 AM
Points: 79, Visits: 667
I have a question about what would happen to read-only queries that are configured to run on the mirror (not principle) database server if the mirrored server is temporarily unavailable. Let’s assume that SQL 2012 Always On feature is used on two (principle and mirror) servers and that the read-only queries are setup to connect to the mirror server using the availability group listener.

If the mirror is unavailable will the queries be routed to the principle server?

Thanks in advanced for the help.



Post #1347522
Posted Tuesday, August 28, 2012 6:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 28, 2013 7:46 AM
Points: 290, Visits: 112
Check this link : http://blogs.msdn.com/b/jtarquino/archive/2011/12/12/configuring-a-readable-secondary-routing-in-sql-server-2012-alwayson.aspx

You can configure the Routing URL and Routing List to re-direct your read queries to either Principal or other available secondaries.

HTH
Kishore
Post #1350864
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse