As you might know I have created over this summer a physical 3-node VMware vSphere home lab, so that I can test-drive VMware vSphere in combination with SQL Server – which is these days a quite interesting combination that I see very often during my various SQL Server consulting engagements. But it was a quite …
Today I want to talk about a very important topic in SQL Server – setting a Processor Affinity – and the unwanted side effects that you introduce with this approach. First of all I want to talk a little bit about what a Processor Affinity is, and how it relates to SQL Server. What is a …
Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects + read more
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
Today I’ve announced my SQLpassion Online Training for October 2017. On October 5 I’m running a one-day long webinar about SQL Server Locking & Blocking. If you are interested in attending one of the online trainings, hurry up for registration because the space is limited! Thanks for your time, -Klaus
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
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.
