Cisco Cisco UCS B200 M1 Blade Server Weißbuch
© 2011 Cisco and/or its affiliates. All rights reserved. This document is Cisco Public Information.
Page 34 of 36
Consolidated OPM, CPU and Memory Usage with Small Database Consolidation
Based on the results we can clearly identify the boundaries of various deployment scenarios that one encounters
consolidating Microsoft SQL server on a virtualized environment. Following table describes generic guideline for
picking suitable blade while consolidating SQL server on virtualized environment. For an entry level configuration
B200-M2 provides an ideal platform for consolidating up to 24 databases. As memory requirement increases one
can choose B230-M2 as it provides larger memory capacity with higher computing power. Note that i/o capacity
was not saturated in any of the experiments and we still have lot of room from I/O capacity. With larger I/O
requirement and better redundancy B250-M2 becomes the choice for the consolidation with its good balance of
memory and I/O bandwidth needed for Microsoft SQL server. Note that in this paper testing was done with 256G
on B230-M2. As seen in from the result, B230-M2 shows linear scalability in terms of number virtual machines and
can potentially support close to 17 virtual machines hosting around 68 databases.
Workload Characteristics
I/O Characteristics
Suggested Blade
Max Memory
Average memory requirement
Average i/o
B200-M2
192G
Highly memory bound
Average i/o
B230-M2
512G
Moderately memory bound
High i/o
B250-M2
384G