principlesqlMinor
Are there any advantages in SQL Server Always On vs. SQL Server 2008 R2 Mirroring with only two nodes?
Viewed 0 times
nodes2008areadvantagessqlanyalwayswithtwomirroring
Problem
We are currently hosting a SaaS website on two Windows 2008 R2 / SQL Server 2008 R2 Servers. Would upgrading to SQL Server 2012 / Always On give us any advantages with respects to high availability?
Note that while we are looking for high availability, high performance is not really an issue for us at the moment, so being able to run read-only queries on backup database servers is not really important.
Note that while we are looking for high availability, high performance is not really an issue for us at the moment, so being able to run read-only queries on backup database servers is not really important.
Solution
Readable Secondaries: you can query the 'mirror'. See AlwaysOn: High-Availability and reads Scale-Out.
Context
StackExchange Database Administrators Q#12069, answer score: 5
Revisions (0)
No revisions yet.