R710 SqL virtualization

Click next 25 on the database engine configuration

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Agent, and choose NT AUTHORITY\SYSTEM for SQL Server Database Engine. Click Next. 25. On the Database Engine Configuration screen, select Mixed Mode. 26. Enter a password for the system administrator account. 27. Click Add Current user. This may take several seconds. 28. Click Next. 29. On the Error and usage reporting screen, click Next. 30. On the installation rules screen, click Next. 31. On the Ready to Install screen, click Next. 32. After installation is complete, click Start, Administrative Tools, Adding an additional drive to the VM via the iSCSI initiator (Dell only) 1. Power on the VM, and open the console. 2. Click Start, Control Panel, and double-click iSCSI Initiator. 3. Click the Discovery tab. 4. Click Add Portal… 5. Add the IP address of the Dell EqualLogic storage group. 6. Click OK. 7. Click the Targets tab. 8. Find the relevant SQL Data volume for this VM, and select it. Click Log On… 9. Check the checkbox to allow automatic logon on reboot, and to also enable multipath. 10. Click OK. Adding an additional virtual drive to the VM via vSphere (HP only) 1. Power off the VM, right-click and choose Edit Settings. 2. Click Add Principled Technologies, Inc.: Virtualized OLTP workload performance comparison of end-to-end solutions: Dell PowerEdge R710 with Dell EqualLogic storage vs. HP ProLiant DL385 G5 with HP StorageWorks EVA 4400 storage 12 3. 4. 5. 6. 7. 8. 9. 10. Choose Hard Disk, and click Next. Choose Create a new virtual disk, and click Next. Choose 60GB for the size and select Specify a datastore. Click Browse. Select the appropriate datastore. We alternated database storage between the two datastores available on the HP Storage. Click OK. Click Next. Click Next. Click Finish. Click OK. Configuring additional drives in Disk Management 1. Power on the VM, and open the console. 2. Click Start, Administrative Tools, Computer Management. 3. Click Disk Management 4. Right click the uninitialized disks (if any), and choose Initialize Disk. 5. Choose MBR. 6. Right-click the volume and choose New Simple Volume. Click Next. 7. Keep the default drive space and click Next. 8. Keep the default drive letter assignment and click Next. 9. Choose NTFS, 64KB allocation unit size, and check the Perform a quick format checkbox. Click Next. 10. Click Finish. 11. Create folders necessary for the database restore. We used <driveletter>:\SQLData. Creating the additional VMs on the host server After installing and configuring the initial VM, we created the additional VMs through automated cloning scripts. Cloning the VMs We used a shell script on the ESX Server to copy the Virtual Disks, and clone the VMs. This shell script copied the VM definition and virtual disks, and registered the new VM in ESX, using the vmware-cmd utility. Using these automated cloning scripts saved time and let us confirm that we configured all VMs similarly. Configuring the additional VMs after cloning 1. In vSphere, expand the host, then click the VM. 2. Click the consol...
View Full Document

Ask a homework question - tutors are online