Specifications
Implementing Live Migration for SQL Server 2008 R2 CHAPTER 4 79
11. From the Virtual Machines section of the results pane in Hyper-V Manager, right-
click the name of the SQL Server VM you just created, and click Connect. The Virtual
Machine Connection tool opens.
12. In the Action menu in the Virtual Machine Connection window, click Start.
13. Follow the prompts to install the Windows Server 2008 R2 operating system.
14. When the operating system installation is complete, install SQL Server 2008 R2.
Real World
A
fter an operating system is set up, best practice guidelines recommend the
installation of the Hyper-V Integration Services tools for every VM that was
created. The Hyper-V Integration Services tool provides virtual server client (VSC)
code, which ultimately increases Hyper-V performance of the VM from an I/O,
memory management, and network performance perspective. Hyper-V Integration
Services is installed by connecting to the VM and selecting Insert The Integration
Services Setup Disk from the Action Menu of the Virtual Machine Connection win-
dow. Click Install in the AutoPlay dialog box to install the tools.
Conguring a SQL Server VM for Live Migration
Organizations interested in using Live Migration need to set up a VM for Live Migration. This
is accomplished by reconguring the automatic start action for the VM and then preparing
the VM for high availability by using Failover Cluster Manager. The following steps illustrate
this series of actions in more detail:
1. Create a SQL Server 2008 R2 VM based on the steps in the previous section. Verify that
the VM is using CSV.
2. In Hyper-V Manager, under Virtual Machines, highlight the VM created in the previ-
ous steps (SQLServer2008R2-VM01 in the example in this chapter). In the Action pane,
under the VM name, click Settings.
3. In the left pane, click Automatic Start Action.