AlwaysOn

Adding a Replica back into a SQL Server Availability Group

In one of my last blog postings I have already described a common pitfall when you try to add a new Replica into an Availability Group. In today’s blog posting I want to talk a little bit more about how you can add a Replica back into an Availability Group – when you have removed …

Adding a Replica back into a SQL Server Availability Group + read more

Adding Replicas into existing Availability Groups

Last week I have blogged about how you can run the Availability Group traffic through a different network card. In today’s blog posting I want to talk about some side effects of this approach when you want to add a new Replica into an existing Availability Group. Add new Replicas SQL Server Management Studio is …

Adding Replicas into existing Availability Groups + read more

How to run the Availability Group Traffic on a different NIC

When you deploy a new SQL Server Availability Group, the synchronization traffic between all replicas is routed by default always through your default network card. In today’s blog posting I want to show you how you can configure your SQL Server Availability Group, so that the network traffic goes through a dedicated different network card. …

How to run the Availability Group Traffic on a different NIC + read more

Automatic Seeding & Compression

Last week I have talked about the basic concepts behind Automatic Seeding in SQL Server 2016 Availability Groups. In today’s blog posting I want to continue by talking about Compression optimizations available in combination with Automatic Seeding. How do I enable Compression? If you are using Automatic Seeding when you add replicas or new databases …

Automatic Seeding & Compression + read more

Automatic Seeding in Always On Availability Groups in SQL Server 2016

Over the last few weeks I have done a lot of work in the area of Always On Availability Groups, and therefore I had also the chance to test drive the Automatic Seeding option that is available beginning with SQL Server 2016. In today’s blog posting I want to give you an overview about what …

Automatic Seeding in Always On Availability Groups in SQL Server 2016 + read more