In 10.2.500 under the Query Execution Settings I see a new check box labeled Use Primary Database. I have searched but I am unable to find any documentation on what this is for. Does anyone know what this will do?
Ron -Did you find anything on this?
Hi John, no I never have.
I was working with Support and some consultants. If I have an answer later I will update this post.
Thx, much appreciated.
I came across this post, as we are setting up new SQL Servers using Always-On Availability Groups. What this will do is off-load BAQs to your Secondary Server and its databases if the Read-Only Routing is configured.