Category: AlwaysOn Availability Groups
-
Availability Group fail-over test with PowerShell
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. For this reason, we use asynchronous commit with manual fail-over. We also conduct regular fail-over […]
-
Connecting to an Availability Group Listener with SQL Server Management Studio
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 within the same sub-net, the listener simply comes online on the new node. That node […]
-
FILESTREAM garbage collection with AlwaysOn Availability Groups
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 collection process. Paul Randal, as always, did a great job of explaining the garbage collection […]
-
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 SQL Server 2014 FAQ datasheets SQL Server 2014 Datasheet Decks SQL Server 2014 Level 100 […]
-
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 processing to secondary replicas. Cluster Level Operations From a network perspective the AG listener is […]
-
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 are no steps required for this to happen in an emergency but you might find a reason […]
-
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 Listeners folders in your object explorer. These we dealt with directly when setting up the […]
-
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 should always be manipulated via the AlwaysOn wizards in SSMS or via T-SQL. Microsoft explicitly states […]
-
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 architecture this will need to be accomplished once per node for the SQL Server Failover Cluster […]
-
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 disk added to the cluster, and 1 SQL Server Failover Cluster Instance already installed in […]