I’m proud to remotely present a technical session called “Modern SQL Server CPU Architecture” to the Colorado Springs SQL Server Users Group on April 15th, starting at 5:30pm Mountain time. It will be presented remotely via Microsoft Teams due to the COVID-19 outbreak. RSVP for this session here!

Abstract: Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, and instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.