Overview
Dive deep into the world of virtualized SQL Server performance optimization in this comprehensive conference talk from PASS Data Community Summit. Explore the potential bottlenecks and performance killers that can affect business-critical SQL Servers in virtual environments. Learn about CPU scheduling, storage queueing, and memory overcommitment issues, and discover tools, techniques, and processes to measure and validate system performance. Gain valuable insights from real-world examples and years of experience in maximizing virtual SQL Server performance. Cover topics such as virtualization basics, CPU architecture, enterprise storage, networking challenges, physical compute considerations, and monitoring strategies. Master the art of right-sizing and configuring virtual machines for optimal SQL Server performance, and understand the importance of proper architecture in eliminating virtualization-related bottlenecks.
Syllabus
Introduction
What is virtualization
Traditional bare metal
CPU scheduling
Performance concerns
Enterprise storage
Storage latency
Disk spd
Networking
Network Scaling
Roundtrip Problem
Physical Compute
Compute Resource Selection
CPU Architecture
The Bottom Line
Geekbench
Geekbench V5
Cloud
Monitoring
VM Admin Perspective
Bottom Line
Right Sizing
Right Configuration
Hyper Threading
CPU Core Info
Taught by
PASS Data Community Summit