Dell POWEREDGE R720XD - Manual (Page 10)

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd
10
Figure 6 represents the storage system configuration for the proposed Fast Track reference.
Figure 6. Storage System Components
Data file 1
Data file 2
Data file 3
Data file 4
User database Temp DB
SQL SERVER
Data file 5
Data file 6
Data file 7
Data file 8
Data file 9
Logs
Data file 1
Data file 2
Data file 3
Data file 4
Data file 5
Data file 6
Data file 7
Data file 8
Data file 9
Logs
INTERNAL STORAGE
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 1
RAID 10
Virtual disk group 1
Virtual disk group 2
Virtual disk group 3
Virtual disk group 4
Virtual disk group 5
Virtual disk group 6
Virtual disk group 7
Virtual disk group 8
Virtual disk group 9
Virtual disk group 10
The production, staging, and system temp databases were deployed per the recommendations provided
in the Microsoft Fast Track Data Warehouse 4.0 Reference Guide.
Application Configuration
The sections below explain the settings applied for the operating system and database layers.
Windows Server 2008 R2 SP1
Settings used for Windows 2008 R2 SP1 operating system:
 Enable Lock Pages In Memory: This Policy setting is enabled to prevent the system from
paging memory to disk.
For more information, refer to
How to: Enable the Lock Pages in Memory Option in the
Reference Section.