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

Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on PowerEdge R720xd Contents Introduction ...4 Microsoft SQL Server Fast Track Data Warehouse 4 Dell Fast Track Data Warehouse Reference Architecture 4 Hardware Component Architecture 5 Internal Storage Controller (PERC H710P Mini) Settings 7 Application Configuration 10 Performance Benchmarking 11 Baseline Hardware Characterization using Synthetic I/O 11 Fast Track Database Validation 13 Fast Track Database Validation with Column Store Index (CSI 14 Reference Architecture Performance Details 14 Conclusion ...15 References ...16 Tables Table 1. Table 2. Table 3. Table 4. Dell Fast Track Reference Architecture Solution Details 4 Tested Dell Fast Track Reference Architecture Component Details 5 Mount Point Naming and the Storage Enclosure Mapping 9 Performance Metrics 14 Figures Figure 1. Figure 2. Figure 3. Figure 4. Figure 5. Figure 6. Figure 7. Figure 8. Proposed Dell Fast Track Reference Architecture 5 Memory Slot Locations 6 Virtual Disk Settings 7 Internal Storage Controller Settings 8 RAID Configuration 8 Storage System Components 10 SQLIO Line Rate Test from Cache (Small File 12 SQLIO Real Rate Test from Disk (Large File 13 3