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 without registration, duration hours minute second in high quality. This video was added by user Glenn Berry 10 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,43 once and liked it 5 people.