Predefined MDX Queries (Sun N1 Advanced Architecture for SAP Solutions 5.2.1 User's Guide)

Sun N1 Advanced Architecture for SAP Solutions 5.2.1 User's Guide

Predefined MDX Queries

The N1 AA Analyzer comes with some predefined MDX queries allowing you to perform the most common analyses on your system landscape.

Note –

These queries are read-only, you can neither modify nor delete them. These queries are available in every server group.

Table 3–3 MDX Queries


View name	Description	Benefits
CPU - Server group utilization	Get a CPU utilization overview of your server group. Key utilization values are displayed and the load is qualified. The qualification itself is based on threshold values that are customizable in the N1 AA. See Basic Setup. Note – Find details of this query and especially the meaning of the customizable parameters in the Appendix A, MDX Queries. Input/Usage Specify the time frame Select none, one or more servers	Quickly identify CPU bottlenecks or oversupply.
MEM - Server group utilization	Get a memory utilization overview of your server group. Key utilization values are displayed and the load is qualified. The qualification itself is based on threshold values, that are customizable. See Basic Setup. Note – Find details of this query and especially the meaning of the customizable parameters in the Appendix A, MDX Queries. Input/Usage Specify the time frame Select none, one, or more servers	Quickly identify memory bottlenecks or oversupply.
CPU - Application load distribution	CPU consumptions of all components belonging to the specified application are displayed in relation to each other. Data basis are the normalized CPU seconds in the specified time frame. Input/Usage Specify the time frame Select one application	Find the main CPU consuming components of an application.
MEM - Application load distribution	Memory consumptions of all components belonging to the specified application are displayed in relation to each other. Input/Usage Specify the timeframe Select one application	Find the main memory consuming components of an application.
CPU - Server load	Display the used CPU seconds of every component along the specified timeline. Input/Usage Specify the time frame Select one server	Find the CPU capacity situation on the server.
MEM - Server load	Display the used memory of every component along the specified timeline. Input/Usage Specify the timeframe Select one server	Find the memory capacity situation on the server.
CPU - Server load composition	CPU consumptions of all components running on the specified host are displayed in relation to each other. Data basis are the CPU seconds in the specified time frame. Input/Usage Specify the timeframe Select one server	Find the main CPU consuming components running on the server.
MEM - Server load composition	Average memory consumption, in bytes, of all components running on the specified host are displayed. The `None.Free` value represents the free physical memory capacity and can be negative. Input/Usage Specify the time frame Select one server	Find the main memory consuming components running on the server.
CPU - Server load simulation	What-If Analysis: Simulates the consolidation of application components on a target server. The output graphic displays the resulting CPU utilization on that server. The available server capacity is displayed as a horizontal line. All are based on the normalized CPU consumptions. Input/Usage Specify the time frame Select one target server Select one or more application components	Reduce Risk: Simulate capacity situation before application consolidation.
MEM - Server load simulation	What-If Analysis: Simulates the consolidation of application components on a target server. The output graphic displays the resulting memory utilization on that server. The available server capacity is displayed as a horizontal line. All are based on the measured memory consumptions. Input/Usage Specify the time frame Select one target server Select one or more application components	Reduce Risk: Simulate capacity situation before application consolidation.
CPU - Server load simulation (incl. base load)	Same as CPU – Server load simulation. The difference being that all component loads of application `None`except the `None.Free` value are left on the selected target server as some kind of base CPU consumption. Input/Usage Specify the time frame Select one target server Select one or more application components	Reduce Risk: Simulate capacity situation before application consolidation.
MEM - Server load simulation (incl. base load)	Same as MEM – Server load simulation. The difference being that all component loads of application `None` except the `None.Free` value are left on the selected target host as some kind of base memory consumption. Input/Usage Specify the time frame Select one target server Select one or more application components	Reduce Risk: Simulate capacity situation before application consolidation.