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
Course info
Rating
(183)
Level
Intermediate
Updated
June 19, 2013
Duration
4h 7m
Table of contents
Introduction
7m 59s
Description
Course info
Rating
(183)
Level
Intermediate
Updated
June 19, 2013
Duration
4h 7m
Description

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.

About the author
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.

More from the author
SQL Server: Change Data Capture
Intermediate
2h 10m
27 Mar 2015
SQL Server: Using SQL Sentry Plan Explorer
Intermediate
2h 4m
26 Dec 2013
More courses by Jonathan Kehayias