Dell PowerEdge R510 - Manual (Page 9)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 7
Figure 3. Internal Storage Controller Settings
RAID configuration
One of the most critical decisions that we have to make when deploying a new storage solution is which
RAID type(s) to use as that choice heavily impacts the performance of the application. We have
configured the proposed Fast Track configuration using RAID 1 disk groups for database data files and
database log files. Four RAID 1 data disk groups and one RAID 1 log disk group were created. Figure 3
shows the proposed RAID configuration.
Figure 4. RAID Configuration
RAID 1 RAID 1 RAID 1 RAID 1
RAID 1
Data
Logs Hot Spares
Application Configuration
The sections below explain the settings applied for the operating system and database layers.
Windows Server 2008 R2 SP1
Default settings were used for the Windows 2008 R2 SP1 operating system.