SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

High Availability Upgrades

By Steve Jones,

SQL Server 2012 will be released soon. I have no idea of the exact date, though I suspect a peek at the SQL Server developers' vacation schedule in Redmond might provide some clue. The announcement last year was a first half of 2012, so I do expect to see the product RTM sometime between now and July 1.

One of the highly anticipated features in SQL Server 2012 is the Always On feature, which will dramatically increase the ease with which we can build databases that can not only tolerate hardware failures, but be deployed (physically) further apart, and with more flexibility in how backups can be taken. If you haven't read about Always On, I'd urge you to start looking at this feature and see if it's something that can help your company.

Unlike Database Mirroring in SQL Server 2008 R2, which is limited to one secondary database, Always On will allow us to have multiple secondaries. The current mirror databases are unreadable, unless you count the kludgy database snapshot feature. In SQL Server 2012, however, we can actually use the secondary databases to query, providing some limited scale out capabilities. I think that's fantastic, and it's a large step forward for the SQL Server platform. I'm wondering if your company feels the same way.

Will the read only secondaries available in SQL Server 2012 convince your company to upgrade?

There are lots of other features in SQL Server 2012, some great advances in other parts of the platform that might be worth upgrading for, but I regularly see people struggling with scale issues. With the changes in licensing as well, these new scalability features are worth examining, and I'm wondering how important they are for your business. Important enough to justify the price of an upgrade? Let us know today.

Steve Jones

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. They have a great version of Message in a Bottle if you want to check it out.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 244 | Views in the last 30 days: 1
Related Articles

SQL Server Podcasts

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help....


Backup FileGroup and Restore on Secondary Database

Backup FileGroup and Restore on Secondary Database with same filegroups


Initialize Secondary Database Tab Log Shipping

Initialize Secondary Database Tab (Third Option)


Powerscripting Podcast 2

I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcas...


Log Shipping Secondary Server Failed

Log Shipping Secondary Server machine went down