HP Capacity Advisor 7.2 User Guide

• Use less than 1.6 cores most of the time
• Use less than 3 GB of RAM most of the time
Using the Capacity Analysis query language, this query can be expressed as follows:
Match ALL of:
Type = MICROSOFT HYPERV VMGUEST
Core count = 4
15-Min CPU (cores) <= 1.6
15-Min Memory (GB) <= 3
Once you locate the large VMs that can be resized, you want to produce information to justify
why a large VM could be exchanged for a smaller one. To do this, you decide to add the following
information:
• The average loads.
• The 90th percentile loads.
• Information to identify the system: The system name and operating system running on the
system.
You would not be interested in the hardware model and location, since the query is about VMs.
You also would not be interested in the server type or core count, since all systems being listed
would have the same values.
Defining the query
Defining this analysis query consists of three basic steps:
1. Creating and naming the new query.
2. Selecting the data to include in the query results.
3. Defining the filter that selects which systems appear in the query results.
Creating and naming the query
1. In the Analysis tab, select Actions→New....
2. In the Analysis Query Definition screen:
a. Enter a query name of Low usage Large VMs.
b. Select the Viewable by all check box if others will be using this query, or leave it unselected
if you will be the only person using the query.
c. Enter a description such as These Large VMs are candidates for being replaced with
Medium or even small VMs.
Selecting the data to include in the query results
1. Click Choose… to display the Attribute Selection dialog box.
Custom query examples 123