Dell SMB Reference Configuration for Microsoft SQL Server 2012 Fast Track Data Warehouse on
PowerEdge R720xd
3
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. Dell Fast Track Reference Architecture Solution Details ........................................... 4
Table 2. Tested Dell Fast Track Reference Architecture Component Details .............................. 5
Table 3. Mount Point Naming and the Storage Enclosure Mapping ........................................... 9
Table 4. Performance Metrics ..................................................................................... 14
Figures
Figure 1. Proposed Dell Fast Track Reference Architecture.................................................... 5
Figure 2. Memory Slot Locations .................................................................................... 6
Figure 3. Virtual Disk Settings ....................................................................................... 7
Figure 4. Internal Storage Controller Settings .................................................................... 8
Figure 5. RAID Configuration ......................................................................................... 8
Figure 6. Storage System Components ........................................................................... 10
Figure 7. SQLIO Line Rate Test from Cache (Small File) ...................................................... 12
Figure 8. SQLIO Real Rate Test from Disk (Large File) ........................................................ 13