- This event has passed.
Capital Area SQL Server Users Group Presentation 2021.03.08
March 8, 2021 @ 5:00 pm - 7:30 pmFree
Our March meeting will again be online. NOTE: you MUST RSVP to this Meetup to view the Zoom URL!
Our March guest speaker is David Klee!
Topic: Modern CPU Architecture and SQL Server Performance
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.