Overview
This course aims to help learners optimize the performance of their business-critical SQL Servers in virtualized environments. By properly managing virtualization-related bottlenecks, participants will learn to ensure that the performance of SQL Servers is primarily limited by code. Through live examples and years of experience, learners will understand and address major roadblocks to performance such as CPU scheduling, storage queueing, and memory overcommitment. The course covers tools, techniques, and processes to measure and validate system performance, focusing on key components underneath the data. The intended audience for this course includes database administrators, SQL Server professionals, and IT professionals looking to enhance the performance of virtual SQL Servers.
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