HP Matrix Operating Environment Software - Manual (Page 109)

Predefined analysis queries
Capacity Advisor provides a set of predefined queries that cover some commonly desired
perspectives on resource use for a group of servers in the data center. These queries are listed in
the tables below.
The predefined queries cannot be edited, but you can use any of them as the basis for a new query
with a new name.
Predefined queries cannot be deleted from Capacity Analysis.
Finding underused systems
Capacity Analysis can find underused systems by searching for systems where the peak use is a
tiny percentage of system capacity.
Several predefined queries provide ways to look for underused systems.
Table 9 Predefined analysis queries: Finding underused systems
Description Query name
Physical servers having little to no resource utilization over the
selected interval.
Consider removing these systems or converting them to VMs.
Low usage hardware
A VM's peak memory utilization is significantly less than what is
allocated. Allocating too much memory to a VM that does not need
it can prevent other VMs from being run.
Consider reducing the memory by half.
VMs with over-provisioned memory allocations
VMs with a peak CPU utilization significantly less than what is
provisioned.
Consider removing half of the vCPUs from these systems to reduce
overhead in the hypervisor and possibly reduce the licensing costs
of the software running in the VM.
VMs with over-provisioned vCPUs
Physical peak memory utilization significantly less than what is
provisioned. It is probably safe to remove half of the memory, or
move this workload to a smaller server. Systems with over-provisioned memory allocations
VMs that have had little to no resource utilization over the interval.
These VMs could be deleted, making room for more useful VMs. Low usage VMs
This guide also includes a custom query example that finds underused systems. See “Example:
Finding large underused VMs that could be replaced with medium or small VMs” (page 125) .
Finding overused systems
Capacity Analysis can identify servers that are overused over a longer time horizon. When CPU
utilization is above 70 or 80%, queuing delays for interactive workloads can exceed the time the
CPU spends doing useful work. Response times can double or triple long before CPU use reaches
100%. Searching for, and fixing, these more subtle cases of system overuse now can prevent crisis
situations later.
The predefined queries below provide ways to look for overused systems.
Predefined analysis queries 109