Choosing Database Hardware for SQL Server 2019

Explore the intricacies of selecting optimal database hardware for SQL Server 2019 in this comprehensive conference talk from PASS Data Community Summit. Delve into the impact of Microsoft's shift to core-based licensing on hardware selection criteria for database servers. Learn how to evaluate and choose appropriate hardware for various workloads, maximizing performance and scalability while minimizing licensing costs in both physical and virtualized environments. Gain insights into topics such as workload assessment, form factor considerations, socket requirements, and the pros and cons of single vs. dual socket configurations. Compare AMD and Intel processors, examining their respective advantages and performance benchmarks. Analyze two-socket server architecture, cost comparisons, and the implications of processor security vulnerabilities. Understand the balance between capacity and performance in hardware selection, equipping yourself with the knowledge to make informed decisions for your SQL Server 2019 infrastructure.

Intro
Overview
Database Hardware
Dont reuse old hardware
Save money on hardware
The best hardware takes care of all your problems
How do you go about picking hardware
What kind of workload do you have
What form factor do you want
What sockets do you need
What about populating just one socket
SQL Server license costs
SQL Server license limits
Single Socket vs Dual Socket
AMD vs Intel
Intels Advantage
Intel Processors
Intel Processor Family Tree
TPCE Benchmark
AMD Performance Advantages
AMD Zen Architecture
AMD Zen Roadmap
TPCH Benchmark
TwoSocket Server
TwoSocket Server Architecture
Cost Comparison
Meltdown and Spectra
Processor security vulnerabilities
Microsoft Security Guide
Capacity vs Performance
Capacity
Performance
Pictures