26.After installation completes, click StartAll ProgramsMicrosoft SQL Server 2008 R2Configuration ToolsSQL Server Configuration Manager.

27.Expand the Network Configuration node, and select the relevant instance.

28.In the right pane, right-click TCP/IP, and choose Enable.

29.In the left pane, click SQL Server Services.

30.In the right pane, right-click the SQL Server service, and select Restart.

31.Create a SQL Server login for the ds2user (see the Setting up DVD Store section below for the specific script to use).

32.Place the DVD Store backup file you prepared in a folder on the VM C: drive.

Configuring additional VM drives in Disk Management

1.In Hyper-V Manager, right-click the virtual machine, and choose Connect.

2.On the Action menu, choose Start.

3.Log into the VM.

4.Click the Server Manager icon on the taskbar.

5.Click Disk Management.

6.Right-click the disks assigned for SQL Server data and log use, and choose Online.

7.Create the folders necessary for the database. We used <driveletter>:\SQLData for the SQL Server database volume and <driveletter>:\SQLLog for the SQL Server transaction log volume.

8.Repeat steps 6 and 7 for each volume on the VM.

9.Repeat steps 1 through 8 for each VM.

Creating the additional VMs on each host server

After installing and configuring the initial VM, we disconnected the primary VHD file, and then copied

that VHD to all other VMs to use for their operating system VHD. We reconfigured all IP addresses and

hostnames on new VMs. Using Hyper-V Manager, we also connected each VM’s associated SQL Server data

LUNs and SQL Server log LUNs. We repeated this process on each host server.

Configuring the additional VMs after cloning

1.In Hyper-V Manager, right-click the virtual machine, and choose Connect.

2.On the Action menu, choose Start.

3.Click StartControl Panelright-click Network Connections, and double-click the Local Area Connection.

4.Select Internet Protocol Version 4 (TCP/IPv4), and click Properties.

5.In the Internet Protocol Version 4 (TCP/IPv4) Properties screen, select the Use the following IP address radio button.

6.Enter a valid static IP address for this new VM, subnet mask, and default gateway.

7.Click OK, and click Close to exit.

8.Click StartControl PanelSystem.

9.Click Change Settings to change the computer name.

10.Click the Change button.

11.Enter the new computer name.

12.Click OK, and click OK again.

13.Restart the VM.

Virtualized database performance comparison: Dell PowerEdge

A Principled Technologies test report 13

R815 vs. IBM System x3850 X5