beautypg.com

Defining the query, Creating and naming the query, Selecting the data to include in the query results – HP Matrix Operating Environment Software User Manual

Page 123

background image

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.

2.

Select the check boxes for the following attributes:

System tab: Select System Name and OS.

CPU tab: Select 15-Min CPU (cores), 90%ile CPU (cores), and Avg CPU (cores).

Memory tab: Select 15-Min Memory (GB) and 90%ile Memory (GB).

Custom query examples

123