Category: AlwaysOn Availability Groups

  • Synchronizing SQL Server Instance Objects in an Availability Group

    Synchronizing SQL Server Instance Objects in an Availability Group

    Availability groups can no longer be considered new. The feature was released in SQL Server 2012 but I often notice that SQL Server Failover Cluster Instances (FCIs) are much better understood. For a very long time, when people thought about SQL Server they thought about the entire instance as a unit. Microsoft has been implementing […]

  • 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 learned implementing and managing them at multiple companies. Here are my top 10 tips for […]

  • 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) and downtime affects your recovery time objectives (RTO). When using Availability Groups (AGs), your RTO […]

  • 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 cheap This architecture is the most cost-effective way to use an Availability Group and have […]

  • 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 number of SQL Server instances from four to two. Availability Group and Failover Cluster Instances […]

  • 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 the architecture above, replica A and B are in the primary data center while replica […]

  • 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 blog series which focuses on my recommended availability group architectures. I will cover; what they […]

  • 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 create a strategy for synchronizing our data for disaster recovery, we then need to consider […]

  • Store Optional Connection Parameters in SQL Server Management Studio

    Store Optional Connection Parameters in SQL Server Management Studio

    About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS. At the time, I had presented three problems and only solutions for two of them. At this time, I am happy to announce that Microsoft has responded to our connect ticket and provided a current version work […]

  • 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 over. As a Christmas Present to all of you, I wanted to get a little bit […]