How to Pick the Best AMD EPYC 9004 CPUs for SQL Server 2022
The new Zen 4 AMD EPYC 9004 "Genoa" server processors offer a significant performance boost over their predecessors, and they will be excellent choices for SQL Server 2022. They have a 14% IPC uplift and higher base and boost clock speeds. This means that raw single-threaded CPU performance should increase by 25-30% in most workloads.
AMD EPYC 9004 has up to 96C/192T with twelve channels of DDR5-4800 memory, 128 lanes of PCIe 5.0 support and 64 lanes of CXL 1.1 support. This family also has AVX-512 support which SQL Server 2022 can leverage to help Columnstore queries in batch mode.
Early Geekbench scores provide more evidence of how much more raw CPU performance Genoa has. SQL Server 2022 will also get a substantial benefit from platform improvements like DDR5 and PCIe 5.0.
⏱️TIMESTAMPS⏱️
0:00 Intro
0:41 Zen 4 Generational improvements
1:08 Genoa clock speed increases
1:46 AMD EPYC 9004 platform improvements
2:28 Preferred AMD Milan processors
3:04 AMD EPYC 9004 initial SKU list
4:11 Secret decoder ring for AMD EPYC 9004 names
5:10 Best AMD EPYC Milan SKUs for SQL Server
6:45 Best AMD EPYC Genoa SKUs for SQL Server
8:27 Intel Xeon Platinum 8375C Geekbench score
9:07 AMD EPYC 9374F Geekbench score
10:27 Bonus Chorizo footage!
🔴 Subscribe for more content like this
SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER: / glennalanberry
👥 - FACEBOOK: / glenn.berry.92
LinkedIn: / glberry
Host, Video: Glenn Berry
Watch video How to Pick the Best AMD EPYC 9004 CPUs for SQL Server 2022 online, duration hours minute second in high quality that is uploaded to the channel Glenn Berry 10 November 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 2,436 times and liked it 59 visitors.
