Table Reference

This section lists the statistics database tables that are related to each performance metric.

The table below lists the base name for the tables that contain each type of metric. In the AMPS statistics database, static properties (such as the client name of a connection) are stored in a STATIC table, while statistics that are captured at each interval are stored in a DYNAMIC table.

The amps-sqlite3 script automatically handles the join from STATIC tables to DYNAMIC tables to allow you to query using the base table name directly.

For queries that use other tools, include a join between the corresponding STATIC and DYNAMIC table static_id fields. For example, to query information for clients, join ICLIENTS_STATIC and ICLIENTS_DYNAMIC on ICLIENTS_STATIC.static_id = ICLIENTS_DYNAMIC.static_id.

Host Metrics

Metric Category

Base Table Names

cpu (host level)

HCPU (instance info in ICPUS)

disk capacity and activity

HDISKS

memory (host level)

HMEMORY (instance info in IMEMORY)

network activity

HNET

Instance Metrics