Dell PowerEdge R510 - Manual (Page 6)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 4
Dell Fast Track Data Warehouse Reference
Architecture
In order to optimize data warehouse stack component performance, we must properly tune each layer.
The following sections explain the tuning of selected hardware and software.
Hardware Component Architecture
Redundant and robust tests have been conducted on DELL’s PowerEdge servers to determine best
practices and guidelines for building a balanced FTDW system.
Figure 1. Proposed Dell Fast Track Reference Architecture
Configuration availability may be further enhanced by configuring database clustering using multiple
servers.
Table 1. Tested Dell Fast Track Reference Architecture Component Details
Component Details
Server PowerEdge R510 (BIOS: 1.6.3)
CPU (1) Intel® Xeon® CPU X5675 @3.07GHz (HT Enabled)
Number of cores per socket 6
Total Number of CPU Cores 6
Memory 48GB RAM (3 * 16 DDR3 DIMMs @1066MHz)
Internal Hard Drives 12 x 600GB 15K RPM Serial-Attach SCSI 6Gbps 3.5in Hotplug Hard Drive
Operating System Microsoft Windows® 2008 R2 SP1 Enterprise Edition
Database Software Microsoft SQL Server 2008 R2 Enterprise Edition