SQL Server: Virtualization
Learn how to properly configure, control, and monitor virtual machines, and troubleshoot problems when running SQL Server in a virtualized environment using VMware or Hyper-V, applicable for DBAs, VM admins, and any other IT admins responsible for SQL Server and/or virtualization
What you'll learn
Virtualization of SQL Server instances have become very popular in IT infrastructures, but it's very common to see misconfigured virtual machines resulting in severe performance problems of the SQL Server workloads. This course will show you how to properly configure, control, and monitor VMware and Hyper-V virtual machines being used for SQL Server instances, and how to troubleshoot and fix common performance problems caused by virtualization issues. The course begins by explaining how virtualization works under the covers and why virtualization has become so popular. It then discusses the various memory, CPU, and storage considerations that must be taken into account when virtualizing SQL Server, and demonstrates how to properly configure virtual machines for use with SQL Server. Next the course discusses the high availability and disaster recovery options that VMware and Hyper-V provide, plus how to back up virtual machines. Finally the course shows how to monitor and improve virtual machine guest and host performance in VMware and Hyper-V, and discusses some of the limitations that could prevent a SQL Server workload from being successfully virtualized. This course is perfect for all IT admins and DBAs who are responsible for any aspect of a virtualized SQL Server environment, from SQL Server 2005 onward.
Table of contents
- Introduction 2m
- CPU Virtualization 1m
- x86 Architecture Levels of Privilege 1m
- Virtual Machine Monitor (VMM) 1m
- Types of Virtualization (1): Full using Binary Translation 2m
- Types of Virtualization (2): Para/OS-Assisted 1m
- Hardware Virtualization 1m
- Types of Virtualization (3): Hardware-Assisted 1m
- Soft Memory Virtualization 1m
- Summary 1m
- Introduction 1m
- Determining vCPU Count 2m
- SQL VM CPU Allocations 2m
- CPU Co-Scheduling 2m
- CPU Co-Scheduling Types 2m
- CPU Co-Scheduling Problems 2m
- VMware CPU Ready Time 2m
- Demo: Explaining Demo Environment Configuration 3m
- Demo: VMware CPU Ready Time 5m
- VM Sizing Considerations 1m
- VM Sizing Considerations (2) 1m
- Virtual NUMA (vNUMA) Configuration 2m
- vNUMA Optimized Configuration 1m
- Demo: vNUMA Configuration in VMware ESX 5+ 3m
- Demo: vNUMA Configuration in Hyper-V 3m
- Ensuring VM Resource Allocations 3m
- Hyper-V CPU Reserve 2m
- Demo: Configuring Hyper-V CPU Reserve 3m
- Demo: Bin Packing Problem 3m
- VMware CPU Reservation 1m
- Demo: VMware CPU Reservation 5m
- Hyper-V CPU Relative Weight 2m
- Demo: Hyper-V CPU Relative Weight 1m
- VMware CPU Shares 1m
- Demo: VMware CPU Shares 3m
- Hyper-V Dynamic Memory 3m
- Demo: Hyper-V Dynamic Memory 3m
- Implications of VMware Memory Overcommit 2m
- VMware Memory De-Duplication 2m
- VMware Balloon Driver 3m
- Demo: VMware Balloon Driver Effects 7m
- VMware Best Practices for SQL Server 4m
- Summary 2m
- Introduction 2m
- Virtualization High-Availability Basics 3m
- Demo: VMware HA 6m
- Demo: Hyper-V HA 2m
- Demo: VMware vMotion 3m
- Demo: Hyper-V Live Migration 3m
- Demo: Hyper-V Storage Migration 4m
- Demo: VMware Storage vMotion 3m
- VMware Fault Tolerance 2m
- Hyper-V Replicas 2m
- Hyper-V Replica Limitations 1m
- SQL Server High-Availability Options 2m
- Virtual Machine Failover Clustering 2m
- Database Mirroring and Availability Groups 2m
- Summary 1m
- Introduction 2m
- Understanding % Processor Time in a VM 3m
- Demo: % Processor Time in a VM 4m
- Monitoring on VMware 3m
- VMware Host Counters (esxtop) 3m
- Demo: esxtop 5m
- Virtual Center 3m
- Demo: Virtual Center Performance Data 6m
- vCenter CPU Ready Summation 3m
- VMware Guest PerfMon Counters 1m
- VMware VM Processor Counters 4m
- VMware VM Memory Counters 3m
- Demo: Guest PerfMon Counters 3m
- Hyper-V Host Performance Counters 2m
- Demo: Hyper-V Host Performance Counter Permissions 2m
- Demo: Hyper-V Host Performance Counters 1m
- Hyper-V Root % Processor Time 1m
- Demo: Hyper-V Root Monitoring 2m
- Hyper-V Host Resource Monitoring 2m
- Summary 1m
About the author
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Se... more