- This event has passed.
GLASS User Group Remote Presentation 2019
August 13, 2019 @ 5:30 pm - 8:00 pmFree
Heraflux is proud to announce that David Klee will be presenting a remote user group session entitled “Modern CPU Architecture and SQL Server Performance” for the Greater Lansing Area for SQL Server on August 13th, 2019. Please RSVP for the user group 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.