Dell PowerEdge R510 - Manual (Page 7)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 5
Table 2. Dell Fast Track Reference Architecture Solution Details
Solution Description Configuration ID
Dell Fast Track 3.0 Configuration PowerEdge R510 7068273
Dell Fast Track 3.0 Configuration PowerEdge R510
with Dell Boomi
7068280
Dell PowerEdge R510 Server
The Dell PowerEdge R510 server is a 2-socket, 2U high-capacity, multi-purpose rack server offering an
excellent balance of internal storage, redundancy, and value in a compact chassis.
The PowerEdge R510 server was developed with a purposeful design, energy-optimized options, the
performance of the Intel Xeon processor 5500 and 5600 series, DDR3 memory, and enterprise-class
manageability. For more technical specifications of R510 Server, please refer to the Power Edge R510
Technical Guide, a link to which is provided in the References section of this document.
Processors
The Microsoft Fast Track 3.0 reference guide describes how to achieve a balance between components
such as storage, memory, and processors. In order to balance the available internal storage and
memory for the Dell PowerEdge R510, a single Intel Xeon X5675 Six core processor operating at
3.07GHz speed was used.
Note : For environments that require high processing capabilities, a second socket can be populated.
Memory
For FTDW architecture, Microsoft recommends using 8GB of memory per processor core. With enough
memory installed on the system, the large-scale queries involving Hash joins and sorting operations will
benefit from SQL Server offloading operations from the Tempdb to Memory. Selection of Memory DIMMS
will also play a critical role in the performance of the entire stack. In our test configuration, we have
configured the database server with 48GB of RAM running at 1066 MHz speed. Refer to the Microsoft
Fast track 3.0 Reference Guide for detailed recommendations on system memory configuration.
Internal Storage Controller (PERC H700) Settings
The Dell PERC H700 is an enterprise level SAS 2.0 RAID controller that provides disk management
capabilities, high available, and security features in addition to improved performance of up to 6GB/s
throughput. Figure 2 shows the management console accessible through the BIOS utility.