asked
Increase SQL server performance
I have received a request to create an environment with SQL 2012 where a database is made highly available and also where performance is increased where the database will be active on both servers, reading from both to increase performance. From what I can gather this is not possible. Is there any way to achieve this goal?
With AlwaysOn Availability Groups you can have readable secondary replicas, and if you configure them as synchronous then yes, you can scale out reads. By the very nature of having multiple replicas it will also tick the 'high availability' requirement too. Not promising that it will increase performance, as that will depend on what issue you are trying to solve.
AlwaysOn High availability is a best option. Have a look on [alwayson availability groups][1] [1]:
http://www.sqlserverlogexplorer.com/alwayson-availability-groups-failover/ this will help you.
18 People are following this question.
