I have a number of SQL Server Availability Groups in my organization. Of them, most are multi-site configurations for disaster recovery. Naturally, the latency that a separate data center implies is more than my application can handle for its writes….
Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over…
It seems that, of the DBAs who use FILESTREAM, it is common to ask, “why do I have more file system objects then I have rows with BLOB columns?” This question inevitably bring us to the topic of the garbage…
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 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 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 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 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 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 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…