- This event has passed.
(Virtual) SQL Saturday Memphis 2020
October 3, 2020 @ 8:00 am - 5:00 pmFree
I’m thrilled to have been selected to present at this year’s SQL Saturday in Memphis, to be held this year online due to COVID-19. The event will be held online on Saturday, October 3, 2020. I’m presenting an updated session called “Modern SQL Server CPU Architectures for Performance” at 830a Eastern time.
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, public cloud CPU selection, and SQL Server 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.