Cisco Cisco UCS B420 M3 Blade Server White Paper

Cisco

© 2011 Cisco and/or its affiliates. All rights reserved. This document is Cisco Public Information.

Page 2 of 36

Contents

Executive Summary ................................................................................................................................................. 3

Introduction .............................................................................................................................................................. 3

Audience and Scope ............................................................................................................................................. 4

Today’s Challenges .............................................................................................................................................. 4

Consideration for Consolidation ............................................................................................................................ 4

The Solution: SQL Server Consolidation Using Cisco Unified Computing System With VMware vSphere .... 4

Cisco Unified Computing System Solution Overview ............................................................................................ 4

VMware vSphere 4.1 Architecture ........................................................................................................................ 6

Microsoft SQL Server 2008 R2 ............................................................................................................................. 6

EMC VNX Storage System ................................................................................................................................... 7

Server Consolidation Case Study .......................................................................................................................... 8

Case Study: Microsoft SQL Server 2008 R2 Using VMware vSphere 4.1 ............................................................ 8

Testing Methodology and Configurations ........................................................................................................... 10

Test Configurations ............................................................................................................................................. 12

Logical Layout of Tested Configurations ............................................................................................................. 13

Workload ............................................................................................................................................................. 18

Test Results ........................................................................................................................................................... 19

Scenario 1: SQL Server Consolidation Using Cisco UCS B200 M2 and B230 M2 With 10 GB DB .................... 19

Scenario 2: SQL Server Consolidation and Scalability Testing Using Cisco UCS B250 M2 with 10 GB and 100
GB Databases ..................................................................................................................................................... 24

Scenario 3: SQL Server Consolidation Using Cisco UCS B440 M2 With 100 GB Database .............................. 30

Consolidated OPM, CPU and Memory Usage with Small Database Consolidation ............................................ 34

Consolidated Results of OPM, CPU and Memory Usage with Large Database Consolidation ........................... 35

Conclusion ............................................................................................................................................................. 35

For More Information ............................................................................................................................................. 36

Acknowledgments ................................................................................................................................................. 36