White Papers

51 BP1062 | Best Practices for Decision Support Systems with Microsoft SQL Server 2012 using Dell EqualLogic PS Series
Storage Arrays
A Configuration details
This section contains an overview of the hardware configurations used throughout the testing described in
this document.
Test configuration hardware components Table 12
Test
Configuration
Hardware Components
SQL Server® 1
One PowerEdge R820 server running Windows Server 2012, hosting 1 SQL Server
database instance:
BIOS Version: 1.4.0
4 x 8 Core Intel
®
Xeon
®
E5-4620 Processors 2.20 GHz
128 GB RAM, 4 x 146GB 15K SAS internal disk drives
Broadcom 5720 1GbE quad-port NIC (LAN on motherboard), firmware version
7.4.8
Intel(R) Ethernet 10G 2P X520 Firmware level 13.5.2
SQL Server® 2 One PowerEdge R820 server running Windows Server 2012, hosting 1 SQL Server
database instance:
BIOS Version: 1.4.0
4 x 8 Core Intel® Xeon® E5-4620 Processors 2.20 GHz
128 GB RAM, 4 x 146GB 15K SAS internal disk drives
Broadcom 5720 1GbE quad-port NIC (LAN on motherboard), firmware version
7.4.8
Intel(R) Ethernet 10G 2P X520 Firmware level 13.5.2
INFRA SERVER One (1) Dell PowerEdge R710 Server running VMware ESXi 5, hosting two (2)
Windows Server 2008 R2 virtual machines for Active Directory and vCenter:
BIOS Version: 6.3.0
Quad Core Intel® Xeon® X5570 Processor 2.67 GHz
48 GB RAM,2 x 146GB 15K SAS internal disk drives
Broadcom 5709c 1GbE quad-port NIC (LAN on motherboard) – firmware version
7.4.8
LOAD GEN
SERVER
One (1) Dell PowerEdge R710 Server running VMware ESXi 5, hosting 1 Windows
Server 2008 R2 virtual machine for Quest Benchmark Factory:
BIOS Version: 6.3.0
Quad Core Intel® Xeon® X5650 Processor 2.67 GHz
48 GB RAM, 2 x 146GB 15K SAS internal disk drives
Broadcom 5709c 1GbE quad-port NIC (LAN on motherboard) – firmware version
7.4.8
MONITOR
SERVER
One (1) Dell PowerEdge R710 Server with Windows Server 2008 R2 for SANHQ:
BIOS Version: 6.3.0
Intel Xeon X5650 Processor 2.67 GHz
48 GB RAM,2 x 146GB 15K SAS internal disk drives
Broadcom 5709c 1GbE quad-port NIC (LAN on motherboard) – firmware version