HiveBrain v1.2.0
Get Started
← Back to all entries
principlesqlMinor

Are there any advantages in SQL Server Always On vs. SQL Server 2008 R2 Mirroring with only two nodes?

Submitted by: @import:stackexchange-dba··
0
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.

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.