Dell PowerEdge External Media System 1434 Dell SMB Reference Configuration for - Page 10

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Figure 6 represents the storage system configuration for the proposed Fast Track reference. Figure 6. Storage System Components SQL SERVER User database Temp DB Data file 1 Data file 1 Data file 2 Data file 2 Data file 3 Data file 3 Data file 4 Data file 4 Data file 5 Data file 5 Data file 6 Data file 6 Data file 7 Data file 7 Data file 8 Data file 8 Data file 9 Data file 9 Logs Logs INTERNAL STORAGE 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 RAID 1 RAID 1 RAID 1 RAID 1 RAID 1 RAID 1 RAID 1 RAID 1 RAID 1 RAID 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. 10