Microsoft CSS team released a new post of their learning series on SQL Server 11 HADRON. In this article they share how is the synchronous commit request processed and what is behind the scenes of that process. You can read the article here.
The following step-by-step guide is provided by Microsoft SQL Server CSS engineers based on the CTP version of SQL Server 11 or code-name Denali. The guide can be found here.
I urge you to read it and just note some of the specifics which probably will not be changed upon final release of the product. I am talking about things like HADRON instances are stand-alone instances, you must first enable the feature on service level and creating availability groups. Some of the screens/features/setting might be changed or removed by the time the RTM is released but still this is as much as we can get with the current version.
I’d like to share today two very important whitepapers published on the SQLCAT team site. Both of them are regarding high availability solutions – design and real-life examples.
The first one is Failure Is Not an Option: Zero Data Loss and High Availability and describes “how to combine SQL Server high availability technologies to provide a zero data loss, highly available solution for database applications involving financial transactions”. The whitepaper can be downloaded from here.
The second one is on written by Paul S. Randal (SQLskills.com) and is called Proven SQL Server Architectures for High Availability and Disaster Recovery. It applies to SQL Server 2005, 2008 and 2008 R2 and “describes five commonly-deployed architectures using SQL Server 2005 and SQL Server 2008 that are designed to meet the high-availability and disaster recovery requirements of enterprise applications. The whitepaper will describe the architectures and also present case studies that illustrate how real-life customers have deployed these architectures to meet their business requirements”. Download the whitepaper here.