HADR

SQL Server 2014 CTP1 Product Guide

SQL Server 2014 CTP1 Product Guide

SQL Server 2014 CTP1 Product Guide has been released. List of Inclusions White papers SQL Server 2014 Mission Critical Performance SQL Server 2014 Faster Insights from Any Data SQL Server 2014 Platform for Hybrid Cloud SQL Server 2014 In-Memory OLTP…

How to: Configure SQL Server 2012 AlwaysOn – Part 7 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 7 of 7

How to: Configure SQL Server 2012 AlwaysOn Using the Availability Group Listener In this, final, section of the AlwaysOn blog series I will be explaining the Availability Group (AG) listener and how it can be used to off-load some server…

How to: Configure SQL Server 2012 AlwaysOn – Part 6 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 6 of 7

How to: Configure SQL Server 2012 AlwaysOn How to: Fail-over In this part of the blog series we will go over the various methods of manually failing over an Availability Group. Naturally if you are using automatic fail-over then there…

How to: Configure SQL Server 2012 AlwaysOn – Part 5 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 5 of 7

How to: Configure SQL Server 2012 AlwaysOn Explanation of Components Now that we have our AlwaysOn configuration setup I’d like to go over some of the components. Some are very self explanatory such as the Availability Replicas, Databases, and Group…

How to: Configure SQL Server 2012 AlwaysOn – Part 4 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 4 of 7

How to: Configure SQL Server 2012 AlwaysOn Setting up an Availability Group The AlwaysOn Availability Group is a logical group of databases that you want to fail-over to your secondary site together. It is also a Windows Cluster Resource and…

How to: Configure SQL Server 2012 AlwaysOn – Part 3 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 3 of 7

How to: Configure SQL Server 2012 AlwaysOn Enabling the AlwaysOn Feature Quick post on how to enable the AlwaysOn feature at the database instance level. This needs to be accomplished for each instance involved in the architecture. In our target…

How to: Configure SQL Server 2012 AlwaysOn – Part 2 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 2 of 7

How to: Configure SQL Server 2012 AlwaysOn Building the Environment When building our environment there is an assumption of basic familiarity with Windows Failover Clustering. The following will begin with a Windows Failover Cluster configured with 2 nodes, a shared…

Set Windows Failover Cluster Timeout Thresholds

Purpose: When dealing with a single site the default Windows Failover Cluster timeout settings have always done a good job for me but, once you branch out into multiple geographic sites, maintaining clusters across those sites often requires tweaking these…

How to: Configure SQL Server 2012 AlwaysOn – Part 1 of 7

How to: Configure SQL Server 2012 AlwaysOn – Part 1 of 7

How to: Configure SQL Server 2012 AlwaysOn Scope and Architecture This is the first post in a series to provide step-by-step instructions on how to setup and configure a SQL Server 2012 AlwaysOn in a dual data-center Windows clustered environment…