2013
Pluralsight
Jonathan Kehayias
4h 07m
English
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
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.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 2.93 MB 0:01:51 128kbps 148.00 1024x768 15 frames/second 01.Introduction
02.Why am I teaching this course 2.29 MB 0:01:26 128kbps 189.00 1024x768 15 frames/second 01.Introduction
03.Course Expectations 1.66 MB 0:01:01 128kbps 148.00 1024x768 15 frames/second 01.Introduction
04.Virtualization Support 2.30 MB 0:01:27 128kbps 170.00 1024x768 15 frames/second 01.Introduction
05.Course Structure 3.24 MB 0:02:12 128kbps 97.00 1024x768 15 frames/second 01.Introduction
01.Introduction 2.79 MB 0:01:45 128kbps 135.00 1024x768 15 frames/second 02.How Virtualization Works
02.CPU Virtualization 1.83 MB 0:01:14 128kbps 117.00 1024x768 15 frames/second 02.How Virtualization Works
03.x86 Architecture Levels of Privilege 1.64 MB 0:01:00 128kbps 168.00 1024x768 15 frames/second 02.How Virtualization Works
04.Virtual Machine Monitor (VMM) 2.26 MB 0:01:28 128kbps 142.00 1024x768 15 frames/second 02.How Virtualization Works
05.Types of Virtualization (1) - Full using Binary Translation 2.53 MB 0:01:32 128kbps 193.00 1024x768 15 frames/second 02.How Virtualization Works
06.Types of Virtualization (2) - Para-OS-Assisted 2.15 MB 0:01:16 128kbps 219.00 1024x768 15 frames/second 02.How Virtualization Works
07.Hardware Virtualization 1.96 MB 0:01:18 128kbps 133.00 1024x768 15 frames/second 02.How Virtualization Works
08.Types of Virtualization (3) - Hardware-Assisted 1.56 MB 0:00:57 128kbps 166.00 1024x768 15 frames/second 02.How Virtualization Works
09.Soft Memory Virtualization 1.56 MB 0:00:58 128kbps 159.00 1024x768 15 frames/second 02.How Virtualization Works
10.Summary 1.47 MB 0:00:59 128kbps 104.00 1024x768 15 frames/second 02.How Virtualization Works
01.Introduction 2.43 MB 0:01:33 128kbps 129.00 1024x768 15 frames/second 03.Why Virtualization is Popular
02.Virtualization is Cheaper 3.81 MB 0:02:31 128kbps 190.00 1024x768 15 frames/second 03.Why Virtualization is Popular
03.Lower Total Cost of Ownership 2.19 MB 0:01:28 128kbps 136.00 1024x768 15 frames/second 03.Why Virtualization is Popular
04.Simplified Disaster Recovery 2.67 MB 0:01:45 128kbps 152.00 1024x768 15 frames/second 03.Why Virtualization is Popular
05.High Availability is Built-In 2.15 MB 0:01:20 128kbps 150.00 1024x768 15 frames/second 03.Why Virtualization is Popular
06.Reposition IT as a Utility 3.77 MB 0:02:30 128kbps 165.00 1024x768 15 frames/second 03.Why Virtualization is Popular
07.Summary 1.29 MB 0:00:53 128kbps 111.00 1024x768 15 frames/second 03.Why Virtualization is Popular
01.Introduction 2.40 MB 0:01:27 128kbps 138.00 1024x768 15 frames/second 04.SQL Server Considerations
02.Determining VM Candidates 2.74 MB 0:01:52 128kbps 76.00 1024x768 15 frames/second 04.SQL Server Considerations
03.How Non-DBAs View SQL Servers 3.20 MB 0:02:01 128kbps 151.00 1024x768 15 frames/second 04.SQL Server Considerations
04.The Reality of SQL Server 4.34 MB 0:02:42 128kbps 179.00 1024x768 15 frames/second 04.SQL Server Considerations
05.Understanding SQL Server Memory Requirements 5.32 MB 0:03:16 128kbps 231.00 1024x768 15 frames/second 04.SQL Server Considerations
06.SQL VM CPU Considerations 4.42 MB 0:02:52 128kbps 165.00 1024x768 15 frames/second 04.SQL Server Considerations
07.VM Storage Planning 3.33 MB 0:02:02 128kbps 164.00 1024x768 15 frames/second 04.SQL Server Considerations
08.VM Storage Planning (2) 3.52 MB 0:02:09 128kbps 179.00 1024x768 15 frames/second 04.SQL Server Considerations
09.Providing Direct SAN Access to VMs 4.18 MB 0:02:36 128kbps 205.00 1024x768 15 frames/second 04.SQL Server Considerations
10.Summary 2.64 MB 0:01:42 128kbps 117.00 1024x768 15 frames/second 04.SQL Server Considerations
01.Introduction 1.88 MB 0:01:13 128kbps 131.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
02.Determining vCPU Count 2.96 MB 0:01:52 128kbps 163.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
03.SQL VM CPU Allocations 2.85 MB 0:01:53 128kbps 125.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
04.CPU Co-Scheduling 2.32 MB 0:01:30 128kbps 172.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
05.CPU Co-Scheduling Types 2.58 MB 0:01:39 128kbps 141.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
06.CPU Co-Scheduling Problems 3.07 MB 0:01:55 128kbps 159.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
07.VMware CPU Ready Time 2.97 MB 0:01:56 128kbps 125.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
08.Demo - Explaining Demo Environment Configuration 4.71 MB 0:02:44 128kbps 217.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
09.Demo - VMware CPU Ready Time 8.54 MB 0:05:17 128kbps 171.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
10.VM Sizing Considerations 2.12 MB 0:01:21 128kbps 102.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
11.VM Sizing Considerations (2) 1.77 MB 0:01:06 128kbps 136.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
12.Virtual NUMA (vNUMA) Configuration 2.93 MB 0:01:50 128kbps 209.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
13.vNUMA Optimized Configuration 1.79 MB 0:01:07 128kbps 142.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
14.Demo - vNUMA Configuration in VMware ESX 5+ 5.66 MB 0:02:52 128kbps 314.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
15.Demo - vNUMA Configuration in Hyper-V 5.15 MB 0:02:48 128kbps 240.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
16.Ensuring VM Resource Allocations 4.08 MB 0:02:40 128kbps 155.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
17.Hyper-V CPU Reserve 3.51 MB 0:02:17 128kbps 162.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
18.Demo - Configuring Hyper-V CPU Reserve 4.32 MB 0:02:43 128kbps 180.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
19.Demo - Bin Packing Problem 5.54 MB 0:02:54 128kbps 319.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
20.VMware CPU Reservation 1.60 MB 0:01:03 128kbps 91.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
21.Demo - VMware CPU Reservation 9.25 MB 0:04:57 128kbps 405.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
22.Hyper-V CPU Relative Weight 2.79 MB 0:01:49 128kbps 132.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
23.Demo - Hyper-V CPU Relative Weight 2.81 MB 0:01:26 128kbps 185.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
24.VMware CPU Shares 1.64 MB 0:01:03 128kbps 127.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
25.Demo - VMware CPU Shares 6.81 MB 0:03:27 128kbps 274.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
26.Hyper-V Dynamic Memory 4.10 MB 0:02:39 128kbps 169.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
27.Demo - Hyper-V Dynamic Memory 6.16 MB 0:03:16 128kbps 266.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
28.Implications of VMware Memory Overcommit 3.14 MB 0:01:57 128kbps 226.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
29.VMware Memory De-Duplication 3.69 MB 0:02:22 128kbps 145.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
30.VMware Balloon Driver 4.06 MB 0:02:35 128kbps 192.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
31.Demo - VMware Balloon Driver Effects 12.5 MB 0:06:34 128kbps 295.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
32.VMware Best Practices for SQL Server 6.25 MB 0:03:55 128kbps 192.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
33.Summary 3.30 MB 0:02:05 128kbps 140.00 1024x768 15 frames/second 05.Virtual Machine Resource Configuration
01.Introduction 2.85 MB 0:01:49 128kbps 141.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
02.Virtualization High-Availability Basics 4.63 MB 0:02:55 128kbps 169.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
03.Demo - VMware HA 10.0 MB 0:05:34 128kbps 298.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
04.Demo - Hyper-V HA 4.08 MB 0:02:12 128kbps 308.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
05.Demo - VMware vMotion 5.78 MB 0:02:42 128kbps 402.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
06.Demo - Hyper-V Live Migration 6.04 MB 0:03:24 128kbps 355.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
07.Demo - Hyper-V Storage Migration 6.79 MB 0:03:32 128kbps 387.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
08.Demo - VMware Storage vMotion 6.70 MB 0:03:24 128kbps 309.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
09.VMware Fault Tolerance 2.86 MB 0:01:43 128kbps 191.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
10.Hyper-V Replicas 2.50 MB 0:01:36 128kbps 180.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
11.Hyper-V Replica Limitations 1.94 MB 0:01:14 128kbps 152.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
12.SQL Server High-Availability Options 3.46 MB 0:02:07 128kbps 203.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
13.Virtual Machine Failover Clustering 3.11 MB 0:01:59 128kbps 147.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
14.Database Mirroring and Availability Groups 2.55 MB 0:01:38 128kbps 145.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
15.Summary 1.81 MB 0:01:07 128kbps 169.00 1024x768 15 frames/second 06.High Availability and Disaster Recovery
01.Introduction 2.34 MB 0:01:26 128kbps 137.00 1024x768 15 frames/second 07.Backing Up SQL Server Virtual Machines
02.Virtual Machine Backup Solutions 2.25 MB 0:01:28 128kbps 141.00 1024x768 15 frames/second 07.Backing Up SQL Server Virtual Machines
03.Problems with VM Backups 4.05 MB 0:02:23 128kbps 215.00 1024x768 15 frames/second 07.Backing Up SQL Server Virtual Machines
04.SQL Server Backup 2.92 MB 0:01:48 128kbps 176.00 1024x768 15 frames/second 07.Backing Up SQL Server Virtual Machines
05.Summary 1.91 MB 0:01:16 128kbps 94.00 1024x768 15 frames/second 07.Backing Up SQL Server Virtual Machines
01.Introduction 3.09 MB 0:01:56 128kbps 162.00 1024x768 15 frames/second 08.Monitoring Performance
02.Understanding % Processor Time in a VM 4.00 MB 0:02:32 128kbps 166.00 1024x768 15 frames/second 08.Monitoring Performance
03.Demo - % Processor Time in a VM 6.02 MB 0:03:38 128kbps 327.00 1024x768 15 frames/second 08.Monitoring Performance
04.Monitoring on VMware 3.95 MB 0:02:38 128kbps 107.00 1024x768 15 frames/second 08.Monitoring Performance
05.VMware Host Counters (esxtop) 5.20 MB 0:03:22 128kbps 153.00 1024x768 15 frames/second 08.Monitoring Performance
06.Demo - esxtop 7.12 MB 0:04:32 128kbps 177.00 1024x768 15 frames/second 08.Monitoring Performance
07.Virtual Center 4.94 MB 0:03:08 128kbps 147.00 1024x768 15 frames/second 08.Monitoring Performance
08.Demo - Virtual Center Performance Data 13.1 MB 0:06:12 128kbps 407.00 1024x768 15 frames/second 08.Monitoring Performance
09.vCenter CPU Ready Summation 4.11 MB 0:02:38 128kbps 198.00 1024x768 15 frames/second 08.Monitoring Performance
10.VMware Guest PerfMon Counters 2.01 MB 0:01:22 128kbps 89.00 1024x768 15 frames/second 08.Monitoring Performance
11.VMware VM Processor Counters 5.56 MB 0:03:41 128kbps 108.00 1024x768 15 frames/second 08.Monitoring Performance
12.VMware VM Memory Counters 4.05 MB 0:02:42 128kbps 118.00 1024x768 15 frames/second 08.Monitoring Performance
13.Demo - Guest PerfMon Counters 4.52 MB 0:02:47 128kbps 141.00 1024x768 15 frames/second 08.Monitoring Performance
14.Hyper-V Host Performance Counters 3.31 MB 0:02:05 128kbps 143.00 1024x768 15 frames/second 08.Monitoring Performance
15.Demo - Hyper-V Host Performance Counter Permissions 3.38 MB 0:01:39 128kbps 365.00 1024x768 15 frames/second 08.Monitoring Performance
16.Demo - Hyper-V Host Performance Counters 1.68 MB 0:00:54 128kbps 202.00 1024x768 15 frames/second 08.Monitoring Performance
17.Hyper-V Root % Processor Time 2.17 MB 0:01:23 128kbps 131.00 1024x768 15 frames/second 08.Monitoring Performance
18.Demo - Hyper-V Root Monitoring 3.27 MB 0:01:58 128kbps 212.00 1024x768 15 frames/second 08.Monitoring Performance
19.Hyper-V Host Resource Monitoring 3.35 MB 0:02:06 128kbps 160.00 1024x768 15 frames/second 08.Monitoring Performance
20.Summary 2.13 MB 0:01:25 128kbps 121.00 1024x768 15 frames/second 08.Monitoring Performance
01.Introduction 1.81 MB 0:01:05 128kbps 139.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
02.Technical Limitations 3.83 MB 0:02:23 128kbps 198.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
03.Technical Limitations (2) 3.91 MB 0:02:21 128kbps 167.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
04.Non-Technical Limitations 4.22 MB 0:02:36 128kbps 200.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
05.Other Considerations 3.56 MB 0:02:17 128kbps 155.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
06.Summary 3.03 MB 0:01:50 128kbps 192.00 1024x768 15 frames/second 09.Limitations and Reasons Not to Virtualize
Download File Size:317.81 MB
|
