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
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 …
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
SQL Server Availability Groups were introduced back with SQL Server 2012. They are an awesome replacement for Database Mirroring (introduced back with SQL Server 2005 SP1), but with one huge limitation: the nodes on which the replicas are hosted must be part of the same Windows cluster. This doesn’t sound that at first, but a …
How to create a SQL Server Availability Group WITHOUT an Active Directory Domain + read more
In the last 2 blog postings you have learned how to setup your first Availability Group with SQL Server 2012. Today I want to show you how you can join an additional Replica to an existing Availability Group. When you have followed the last 3 blog postings, you should have now an Availability Group called …
SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
