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.
I have gotten a lot of email questions recently about TDE and SQL Server, specifically around the encryption hierarchy involved in protecting the encrypted data
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
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.