Dell PowerEdge R820 - Manual (Page 10)

Dell Virtualization Solution for Microsoft SQL Server 2012 using PowerEdge R820
10
Test Methodology
The test scenarios were implemented to showcase the database consolidation capabilities of Dell
PowerEdge R820. Guest virtual machines were configured on a PowerEdge R820 server and Individual
SQL Server instances were deployed on each of the Guest VMs. The performance effects of having
additional VMs were analyzed using standard OLTP database workloads (TPC-E).TPC-E was chosen to be
the test workload because of its CPU intensive nature of the simulated database transactions.
In the test configuration, PowerVault MD3620F was used as the external storage to host the database
files. The storage (and the overall configuration) was sized appropriately to reduce the disk IOs to
relieve the storage level stress on the configuration. This helped us to make sure that each of the VMs
is able to contribute efficiently to the overall R820 server utilization. Table 1 shows the hardware and
software component details used for the VM scalability tests.
Test Configuration Details Table 1.
Components Details
Server Model
PowerEdge R820
Processor
4* Intel® Xeon® Processor E5-4620 @2.20
GHz,4 Cores per socket; Hyper threading
disabled
Memory
256 GB (16x 16GB, DDR3 @ 1600 Mhz)
HBAs
2* QLogic QLE2562 8 Gbps Dual port HBAs
Multipathing Software
Dell MD Series DSM
Storage(FC) MD3620F, with two MD1220 Expansion
Enclosure
FC Switch Brocade 5100
Network Switch Dell Power Connect 6348
Virtualization Hyper-V
Operating System
Windows 2008 R2 SP1 Enterprise Edition
Database Benchmark TPC-E benchmark(OLTP)