Heraflux is proud to announce that we are speaking and helping to coordinate this year’s SQL Saturday in Chicago, to be held at Benedictine University in Lisle, Illinois, on March 23rd.
David Klee is presenting a new session at 11:10am in room A called “Modern CPU Architecture and SQL Server Performance“.
Session 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.
If you’d like to meet up at the event, contact us and we’ll find a quiet spot and talk tech!