Grid performance table information

The grid performance metrics data is contained in three tables within the database. There is no master table.

The metric_fact, metric_scoped_path, and metric_storage_duration tables are created after grid performance metrics configuration. The metric_fact and metric_storage_duration tables have a foreign key relationship to the metric_scoped_path table. The metric_fact table contains the actual recorded management metrics and basic metrics information. The metric_storage_duration table contains the storage duration values associated with each metric type and path, as well as the scoped path for which the duration applies. The metric_scoped_path table contains information about the scoped paths that are referenced by the records in the metric_fact and metric_storage_duration tables. A scoped path describes the type of the scope, environment, grid, peer, component, or adapter and the names that describe the path to that scope.

The following tables offer details about the fields in each grid performance metrics table, and grid performance metrics collections at the grid and peer levels.

Fields in the metric_scoped_path table

Field	Description
ID	Unique record identifier and primary key
ENVIRONMENT_NAME	The name of the environment
GRID_NAME	The name of the grid for which the metric was collected Note: If the Scope value is not grid, this value is NULL.
PEER_NAME	The name of the peer for which the metric was collected Note: If the Scope value is not a peer, component, or adapter, this value is NULL
COMPONENT_NAME	The adapter name for which the metrics was collected Note: If the Scope value is not component, this value is NULL.
ADAPTER_NAME	The name of the adapter for which the metrics was collected Note: If the Scope value is not adapter, this value is NULL.
SCOPE	The scope type: environment, grid, peer, component, adapter

Fields in the metric_fact table

Field	Description and sample values
ID	Unique record identifier and primary key
TIME	Time at which the metric was recorded. The format is YYYY-MM-DD HH:MM:SS.
TYPE	A string containing the metric type Sample values: NUMBER_OF_QUEUED_WORKFLOWS NUMBER_OF_FAILED_ADAPTERS NUMBER_OF_RUNNING_PROCESSES NUMBER_OF_RUNNING_ADAPTERS MEMORY_USE NUMBER_OF_ACTIVE_MODULES
VALUE	The actual value that was recorded Note: This is a string representation of the value, though the value itself can be numeric, string, or a format defined by the system.
SCOPED_PATH_ID	The scoped path for which the metric was recorded Note: This field is a foreign key to the metric_scoped_path table.

Fields in the metric_storage_duration table

Field	Description and sample values
ID	Unique record identifier and primary key
DURATION	The storage duration in milliseconds
TYPE	A string containing the metric type for which the storage duration applies These values correspond to enumeration values defined by the system. Sample value: NUMBER_OF_RUNNING_PROCESSES
SCOPE	The scope for which the duration applies
SCOPED_PATH_ID	A foreign key to the SCOPED_PATH table The referenced scoped path describes the scope and names associated with the scope for which the storage duration applies.

Grid performance table information

Comments