Dell PowerEdge R820 - Manual (Page 3)

Dell Virtualization Solution for Microsoft SQL Server 2012 using PowerEdge R820
iii
Contents
Executive summary ..................................................................................................... 4
Introduction ............................................................................................................. 4
Objectives................................................................................................................ 4
Microsoft Hyper-V Overview .......................................................................................... 5
System Center Virtual Machine Manager......................................................................... 5
SQL Server 2012 Virtualization overview ........................................................................... 6
SQL Server 2012 Licensing .......................................................................................... 6
Why Dell™ Server & Storage Hardware ............................................................................. 7
Dell PowerEdge R820 as a Virtualization Platform ............................................................. 7
Dell SQL Server 2012 Reference architecture using PowerEdge R820 ......................................... 7
Single Server Reference Architecture ............................................................................ 7
Highly Available Reference Architecture ........................................................................ 8
Performance and Scalability of Virtual Machines achieved ..................................................... 9
Test Methodology .................................................................................................. 10
Results and Analysis ............................................................................................... 12
Conclusion ............................................................................................................. 15
Appendix A ............................................................................................................. 17
Tables
Table 1. Test Configuration Details .............................................................................. 10
Table 2. Virtual Server Configuration Details .................................................................. 11
Table 3. Observed Consolidation Capability of R820 for the specific OLTP workload .................. 16
Table 4. Hyper-V performance counters(Medium VMs) ....................................................... 17
Table 5. Hyper-V performance counters(Large VMs).......................................................... 17
Figures
Figure 1. SVCMM ........................................................................................................ 5
Figure 2. Single Server Reference Architecture .................................................................. 8
Figure 3. HA Reference Architecture ............................................................................... 9
Figure 4. SQL Server Storage Layout.............................................................................. 12
Figure 5. Database Transactions per Second .................................................................... 13
Figure 6. Database Batch Requests per Sec ..................................................................... 13
Figure 7. PowerEdge R820 CPU Utilization ...................................................................... 14
Figure 8. Impact of Hyper-threading on Large VMs ............................................................ 15