Architecting for High Performance SQL Server on Virtual Machines
summary
Checklist of actionable fixes and measurable effects: disable energy saving power plans (one case yields a 30% IO drop), avoid oversizing vCPUs for tier‑1 VMs—reducing to eight cores removed CPU ready spikes in two customer incidents, prevent memory ballooning or use reservations/Lock Pages cautiously to avoid swapping, prefer PV SCSI adapters and multiple queues for throughput, use affinity or dedicated clusters (n+2 hosts) for consistency, bake VM/OS settings into templates and enforce with PowerShell/Pester and monitoring (Grafana/Telegraf) to validate results.
AI-written summary · about
chapters (7)
- 0:00Start
- 3:56Let's talk about your VMware environment...
- 9:30So, you wanna go fast?
- 27:43Let's talk about your VM configuration - Memory
- 36:36Let's talk about your VM configuration - Disks
- 43:53But what about SQL Server's config?
- 45:45Resources
related talks
47mArchitecting for High Performance SQL Server on Virtual Machines
54mYour Performance Tuning Check List
57mYour Performance Tuning Check List
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
49mSQL Server on Azure VM - Configuring for Price-Performance
42mSQL Server on Azure VM - Configuring for price-performance
58mFixing poor performance patterns in Azure SQL Database applications
57mSQL Server hates you(?) - what the DBAs never told the developers