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 …
Today I’ve announced my SQLpassion Online Trainings for September 2017. On September 12 I’m doing a free webcast from 11:00 – 12:00 (GMT + 1), where I will talk about how to troubleshoot Deadlocks in SQL Server. And 2 days later on September 14 (my birthday!) I’m running a one-day long webinar about SQL Server …
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
You don’t have the time to set a whole day or even a whole week in a SQL Server training? No problem: just check-out my brand-new Self-Paced Online Trainings that I offer for your immediate access: SQL Server Query Tuning Strategies – If you have a database driven application which reacts very slowly when the …
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.
