My latest article on SQLPerformance.com was published today and highlights the potential for performance problems while using the hot-add vCPU feature in ESX 5+ with wide VMs for SQL Server.
This is a potentially hidden problem with serious performance implications that should be checked for if you are using VMware to run wide VMs with greater than 8 vCPUs on NUMA hardware.
For most people that are reading this post, I’d venture to guess that you have no idea what Trace Flag 460 is or when you
Did you know that there is a limit to the number of actions you can add to a single event in Extended Events? While I
Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a lot about Extended Events and have been
I’ve been doing a lot of work with SQL Server 2022 lately and one of my absolute favorite new features that I just came across
The introduction of DATABASE SCOPED CONFIGURATIONS in SQL Server 2016 enabled different configuration settings at the individual database level. However, there is no logging of
While I was doing some research for a client on how to accomplish a specific task, I happened across a BOL topic that caught my
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.