October 20, 2014 at 4:44 pm
Hi all,
I am working with reporting services.
We have a reporting server. The database engine name of that server server1 (2012 version). It has now using the linked server to the OLTP production server2 ( 2008r2).
We are getting performance issues lot with that linked server
Now we are migrating 2008r2 to 2014 to get always on high availability group asynchronous to get the read only replica as the source to the report server.
How can we change that connection strings to point that report server to the always on read only copy?
Thanks in advance
October 21, 2014 at 1:55 am
You can either point directly to the secondary server or point to the listener adding the connection string property applicationintent=readonly. In this case you have to use the Native Client 11 as provider.
-- Gianluca Sartori
October 22, 2014 at 4:38 am
more importantly, as well as adding the listener you must correctly configure the read only routing within the AlwaysOn group to offload the read only intent connections to an AlwaysOn secondary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply