R710 SqL virtualization

62 300399 294067 279060 303682 285749 307562 308072

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: 2857.49 3075.62 3080.72 2942.09 2666.62 2846.32 2777.46 2604.99 2635.35 2979.58 2899.64 2976.63 2871.03 3124.97 2604.99 2758.78 2804.66 3099.97 2912.25 2824.66 2896.52 3062.64 2754.74 3015.43 2754.74 Figure 5: Individual VM scores and minimum OPM score from the three runs on the HP ProLiant DL385 G5 solution. Higher numbers are better. Figure 6 details the power consumption, in watts, of the servers while idle and during the median run of the Microsoft SQL Server 2008 database workload. Server Dell PowerEdge R710 HP ProLiant DL385 G5 Idle power (watts) Average power (watts) 195.21 209.74 315.03 312.90 Figure 6: Average power usage (in watts) of the two servers while idle and during the median run of Microsoft SQL Server 2008 database workload. Lower numbers are better. Test methodology Setting up and configuring the storage Dell EqualLogic storage configuration Each of the four Dell EqualLogic arrays has 16 drives, for a total of 64 drives. Each of the five HP StorageWorks EVA 4400 storage trays has 12 drives, for a total of 60 drives. In order to match the drive count of the two storage configurations, we configured two Dell EqualLogic arrays in RAID 10 no-spares mode (16 active drives each) and two Dell EqualLogic arrays in regular RAID 10 mode (14 active drives each), for a total of 60 drives. We connected the Dell Server to the Dell EqualLogic storage via three 1Gb/s Ethernet cables. We configured the Dell EqualLogic storage into two storage pools. Figure 7 shows the storage layout. The VM operating system and log storage pool (Storage Pool 1) contained one Dell EqualLogic PS6000 Array. The database storage pool (Storage Pool 2) contained three Dell EqualLogic PS5000XV Arrays. We created one 1.28TB volume in the VM operating system and log storage pool. Following VMware’s best practices regarding adding storage to ESX, we used vSphere to connect this storage pool to ESX Server as a single data store via the ESX iSCSI initiator using one physical NIC. We created 11 60GB volumes in the database storage pool. We used the Microsoft iSCSI Initiator with the EqualLogic Host Integration Toolkit (HIT) within each VM to connect one 60GB volume to every VM through two virtual NIC’s shared between every VM. 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 4 Figure 7: The layout of the Dell EqualLogic storage. Setting up the storage 1. Using the command line, setup a storage group with the following RAID policies: a. PS5000XV-1: RAID-10 (no-spares) b. PS5000XV-2: RAID-10 c. PS5000XV-3: RAID-10 (no-spares) d. PS6000: RAID-10 2. Create a storage pool name of database with the following members: a. PS5000XV-1 b. PS5000XV-2 c. PS5000XV-3 3. Create a storage pool name of OS-Log with the following member: a. PS6000 4. Enable all network connections on each PS5000XV and PS6000 using the following IP address scheme: a. IP Address: 192.168.1.## (## being any num...
View Full Document

This document was uploaded on 01/20/2014.

Ask a homework question - tutors are online