SQL Server: Virtualization
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction- 7m 59s
—Introduction 1m 51s
—Why am I teaching this course? 1m 26s
—Course Expectations 1m 1s
—Virtualization Support 1m 27s
—Course Structure 2m 12sHow Virtualization Works- 12m 32s
—Introduction 1m 45s
—CPU Virtualization 1m 14s
—x86 Architecture Levels of Privilege 1m 0s
—Virtual Machine Monitor (VMM) 1m 28s
—Types of Virtualization (1): Full using Binary Translation 1m 32s
—Types of Virtualization (2): Para/OS-Assisted 1m 16s
—Hardware Virtualization 1m 18s
—Types of Virtualization (3): Hardware-Assisted 0m 57s
—Soft Memory Virtualization 0m 58s
—Summary 0m 59sWhy Virtualization is Popular- 12m 4sSQL Server Considerations- 22m 46sVirtual Machine Resource Configuration- 1h 21mHigh Availability and Disaster Recovery- 37m 2sBacking Up SQL Server Virtual Machines- 8m 24sMonitoring Performance- 52m 45sLimitations and Reasons Not to Virtualize- 12m 35s
