AlwaysOn Availability Groups

Top 10 Tips for Availability Groups

Top 10 Tips for Availability Groups

I have enjoyed working with Availability Groups ever since they were released with SQL Server 2012. Each major version since, the feature has improved and along the way so has my knowledge of them. Knowledge born from mistakes and lessons…

Measuring Availability Group Synchronization Lag

With all of the high-availability (HA) and disaster recovery (DR) features, the database administrator must understand how much data loss and downtime is possible under the worst case scenarios. Data loss affects your ability to meet recovery point objectives (RPO)…

Availability Group Architecture – DR on the Cheap

Availability Group Architecture – DR on the Cheap

Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will take cost reduction one step further by short-changing the disaster recovery site. Disaster recovery on the…

Availability Group Architecture – FCI hybrid

Availability Group Architecture – FCI hybrid

Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group. In this post, I will add SQL Server Failover Cluster Instances to the mix and cut the…

Availability Group Architecture – Adding a Second Site

Availability Group Architecture – Adding a Second Site

Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture, adding in a second site to achieve more than just high-availability. Cross sub-net availability group In…

Availability Group Architecture – High-Availability Only

Availability Group Architecture – High-Availability Only

Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features but we have to decide how to use them. This is the first of a four-part…

Synchronizing Server Objects for Availability Groups

Synchronizing Server Objects for Availability Groups

Updated: 9/8/2017 In addition to the release based method demonstrated below. I created a SQL Agent job based method using dbatools here. This method was created in response to a lot of feedback from DBAs like you. Original After we…

Failing over AlwaysOn Availability Groups

Failing over AlwaysOn Availability Groups

Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail…