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 BMC Atrium Orchestrator environment |
GRID_NAME | The name of the grid for which the metric was collected |
PEER_NAME | The name of the peer for which the metric was collected |
COMPONENT_NAME | The adapter name for which the metrics was collected |
ADAPTER_NAME | The name of the adapter for which the metrics was collected |
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. |
TYPE | A string containing the metric type
|
VALUE | The actual value that was recorded |
SCOPED_PATH_ID | The scoped path for which the metric was recorded |
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 |
SCOPE | The scope for which the duration applies |
SCOPED_PATH_ID | A foreign key to the SCOPED_PATH table |
Comments
Log in or register to comment.