Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
It looks as though as far as high availability goes, it's no better than a fully redundant clustered system. So if you have a good clustered system, then stick with it. However, I'm not really 100% sure about that, as my research is a bit thin (we won't be upgrading because the new licensing, combined with vmware's licensing change last year, left us with little budget for software upgrades) –  Mark Henderson Feb 1 '12 at 19:31
add comment

migrated from serverfault.com Feb 1 '12 at 19:38

This question came from our site for professional system and network administrators.

3 Answers

Readable Secondaries: you can query the 'mirror'. See AlwaysOn: High-Availability and reads Scale-Out.

share|improve this answer
    
This might be an advantage for those who need high performance but, as already noted, this is relevant for us since our database server is idling anyway. –  Adrian Grigore Feb 2 '12 at 12:34
    
Secondary Backups then perhaps –  Remus Rusanu Feb 3 '12 at 4:24
    
it is an advantage, but only if you have more than two nodes, which would not be the case for us. –  Adrian Grigore Feb 4 '12 at 7:59
    
So what? First you ask for advantages, then you shoot down every answer as you do not need it. –  TomTom Jun 11 '13 at 8:49
add comment

My understanding is that AlwaysOn is a shared nothing configuration. Brent Ozar kinds confirms this and extends it by saying that it doesn't require the same hardware.

Here's his writeup (from a few years ago, actually).

http://www.brentozar.com/archive/2010/11/sql-server-denali-database-mirroring-rocks/

Here's the BOL for AlwaysOn

http://msdn.microsoft.com/en-us/library/ff877884%28v=SQL.110%29.aspx

share|improve this answer
1  
But Mirroring with SQL Server 2008 R2 works just as well on different hardware. One of our servers runs on an Intel CPU, whereas the backup is using an AMD CPU. –  Adrian Grigore Feb 2 '12 at 12:36
add comment

I think there's a big advantage for people who target the database mirror - maybe not applicable in your scenario, since you're just connecting internally, but worth noting. When the cluster manager controls access, you have a single IP and DNS name that always points to your primary node, whichever node that is. To take advantage of mirroring, your client has to be mirror-aware (like the SQL Native Client is, but the OLDDB SQL client is not). With AlwaysOn, you can use any client or connection method you want and it will fail over to the active node as needed - you don't get the advanced features like readable secondaries without the native client, but at least it's something.

In your case, though, I'd agree that it doesn't provide anything particularly compelling.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.