Read-only queries on Always On mirror

• sjs-36273

  SSCommitted

  Points: 1854

  More actions

  August 20, 2012 at 6:11 pm

  #260315

  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.

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  August 28, 2012 at 6:10 am

  #1530740

  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