Choosing Database Hardware for SQL Server 2019

Choosing Database Hardware for SQL Server 2019

PASS Data Community Summit via YouTube Direct link

Intels Advantage

16 of 33

16 of 33

Intels Advantage

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Choosing Database Hardware for SQL Server 2019

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Overview
  3. 3 Database Hardware
  4. 4 Dont reuse old hardware
  5. 5 Save money on hardware
  6. 6 The best hardware takes care of all your problems
  7. 7 How do you go about picking hardware
  8. 8 What kind of workload do you have
  9. 9 What form factor do you want
  10. 10 What sockets do you need
  11. 11 What about populating just one socket
  12. 12 SQL Server license costs
  13. 13 SQL Server license limits
  14. 14 Single Socket vs Dual Socket
  15. 15 AMD vs Intel
  16. 16 Intels Advantage
  17. 17 Intel Processors
  18. 18 Intel Processor Family Tree
  19. 19 TPCE Benchmark
  20. 20 AMD Performance Advantages
  21. 21 AMD Zen Architecture
  22. 22 AMD Zen Roadmap
  23. 23 TPCH Benchmark
  24. 24 TwoSocket Server
  25. 25 TwoSocket Server Architecture
  26. 26 Cost Comparison
  27. 27 Meltdown and Spectra
  28. 28 Processor security vulnerabilities
  29. 29 Microsoft Security Guide
  30. 30 Capacity vs Performance
  31. 31 Capacity
  32. 32 Performance
  33. 33 Pictures

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.