Choosing Database Hardware for SQL Server 2019

This course explains how to evaluate and choose hardware for SQL Server database workloads while balancing performance, scalability, and licensing costs. It considers processor architectures, socket configurations, and physical or virtualized environments.

Syllabus

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