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.
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.