Database Reference
In-Depth Information
Figure 5.3
CPU utilization for an OLTP-type system.
Figure 5.4
graphs data from a system that is running batch databases. The database
enters the work cycle at 1 a.m. and exits at 4 a.m. The average workload utilization for
this server is 17.4%, with 75% during active hours, peaking at 95% utilization at 3 a.m.
During non-peak hours, average utilization is 5.9%, which lasts for approximately 20
hours.
Figure 5.4
CPU utilization on a batch workload system.
When these workload types are combined on the same physical host, in separate virtual
machines, there is an increase in system utilization throughout the day, without
contention for the physical CPU, as depicted in
Figure 5.5
. Average physical CPU
utilization increases to 33.3%, up from 21.9% (OLTP) and 17.4% (batch), and the
server is only inactive for eight hours versus 12 hours for OLTP and 20 hours for the
batch server.
