Reference Configuration

Microsoft SQL Server 2012 Fast Track Reference Configurations using PowerEdge R720 and PowerVault MD3620i
iii
Contents
Executive summary ..................................................................................................... 4
Introduction to Microsoft SQL Server Fast Track reference architectures ................................... 4
What’s new with Dell Microsoft Fast Track reference architectures? ......................................... 4
Dell Microsoft SQL Server 2012 Fast Track reference architectures using PowerEdge R720 and
PowerVault MD3620i ................................................................................................... 5
Single server reference architecture ............................................................................. 6
Highly available reference architecture ......................................................................... 7
Reference architecture configuration hardware component details ....................................... 8
Reference architecture configuration tuning details .......................................................... 9
Reference architecture performance details .................................................................... 16
Summary ............................................................................................................... 16
Tables
Table 1. Recommended reference architectures with Solution IDs .......................................... 5
Table 2. Single server reference architecture details .......................................................... 6
Table 3. Highly available reference architecture details ...................................................... 7
Table 4. Mount point naming and storage enclosure mapping .............................................. 15
Table 5. Performance metrics .................................................................................... 16
Figures
Figure 1. Single server reference architecture ................................................................... 6
Figure 2. Highly available reference architecture ............................................................... 7
Figure 3. Cabling diagram for single server configuration ...................................................... 9
Figure 4. Enabling Jumbo frames on storage iSCSI host ports ............................................... 10
Figure 5. Enabling storage High Performance Tier(Turbo Mode) ............................................ 11
Figure 6. Modifying storage cache block size ................................................................... 11
Figure 7. Modifying the virtual disk segment size .............................................................. 12
Figure 8. Enabling Jumbo packets on network adapter ports ................................................ 12
Figure 9. Enabling Jumbo frames on switch ports ............................................................. 13
Figure 10. Storage LUN layout ...................................................................................... 14