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. Read more