Cisco Cisco UCS B250 M2 Extended Memory Blade Server Libro blanco
© 2011 Cisco and/or its affiliates. All rights reserved. This document is Cisco Public Information.
Page 19 of 36
Following that we then added more virtual machines to the configuration with each virtual machine now supporting
four databases under one SQL server instance. Benchmark scores and resource usages were collected with this
configuration as well.
In the second scenario, we started the test with one database (large database) in one SQL instance on one virtual
machine and captured the benchmark score and resource utilization. Later we started adding one virtual machine
at a time to the same physical machine and simultaneously started the workload on all the virtual machines. In this
way, more virtual machines added to the physical machine and the workload has been tested and captured the
benchmark score at every instance of adding new virtual machine.
The primary metric is OPM, which the driver program calculates and reports in a test file on the client machines.
Table 5 details the workload parameters used for 10 GB and 100 GB consolidation study.
Table 4.
OLTP Client Parameters for Small and Large Database Consolidation Study
Test Results
Scenario 1: SQL Server Consolidation Using Cisco UCS B200 M2 and B230 M2 With 10 GB DB
Figure 10 shows the resource utilization of Cisco UCS B200 M2, especially CPU and memory of the physical
Machine after adding each virtual machine one after another with four small databases in each virtual machine and
concurrently running OLTP workload on each virtual machine. Workload was capped to make sure that resources
(Memory and CPU) were not saturated. In this testing process we observed 93 percent of memory utilization and
67 percent CPU utilization. As it is shown in the graph, physical machine still had enough CPU to handle any
unexpected spikes in the workloads.