Filter
Top Products
A Principled Technologies test report 13
Virtualized database performance comparison: Dell PowerEdge
R815 vs. IBM System x3850 X5
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.