Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Managing process metrics

Process metrics data is generated by schedules and through the execution of workflow processes. You can collect this data from processes running on a grid by configuring the connection to the database appropriately.

For successful collection of process metrics data, the grid must have a configured connection to the database, and at least one peer on that grid must be designated as a synchronization point (sync point). Peers that have been designated as sync points upload the process metrics data to the database.

The first time that process metrics data is uploaded to the database, the system verifies that tables exist to contain the data. If the tables do not exist, the system creates them automatically.

Note

The database user ID used in metric configuration must have authority to create tables, indexes, and sequences, and to populate data into the created tables on an ongoing basis.

The process metrics tables might become large over time as workflows execute. (For schema information for the process metrics tables, see Process metrics table information). You must resize these tables appropriately for your environment and execution load, and decide if and when to archive and purge the data.

Recommendation

BMC recommends that you contact your company's reporting, data warehouse, or database administrator for assistance with exporting and purging metric table data.

BMC Atrium Orchestrator Grid Manager does not display any collected process metrics. To view process metrics, you must use the tools available for the database program that you are using to collect the data. However, if you install the graphing components on the configuration distribution peer (CDP), you can generate process metrics reports.

This topic includes the following sections:

Process metrics table information

The process metrics data is contained in the metric and metric_detail tables within the database. There is no master table. The tables are created after process metrics data collection is configured. The metric_detail table has a foreign key relationship to the metric table.

The following tables offer details about the fields in each process metrics table.

Fields in the metric table

Field

Description

ID

Unique record identifier of the metric and primary key

GRID_NAME

Name of the grid on which the process occurred for which the metric is recorded

PEER_NAME

Name of the peer where the process occurred for which the metric is recorded

START_TIME

Start time of the process or action whose information is recorded as a metric

CATEGORY

Type of metric being recorded

DESCRIPTION

Description of the process or action whose information is recorded as a metric

DURATION

Length of time the process or action took to finish

STATUS

Status of the process or action

ENTITY_ID

Unique identifier of the process or action

USER_ID

User name of the person or system who invoked the process or the action


Fields in the metric_detail table

Field

Description and sample values

ID

Unique record identifier and primary key

NAME

Metric for which the VALUE is captured

VALUE

Metric value that corresponds to the NAME attribute or item

METRIC_ID

Cross-referenced value for the ID in the metric table

SEQUENCE_NUM

Sequence number of the metric detail records of a metric record (internal use only)

Video demonstration

The following BMC Communities video series demonstrates how to collect process metrics data generated through the execution of BAO workflow processes. 

Part one (5:42) shows how to set up an external database, configure the process metrics database in Grid Manager, and designate a peer as a sync point.

The video mentions the Value Dashboard component, which is not supported in 7.7.x releases (it is available in 7.8 and later), however, you can use the graphing server to generate process metrics reports.

 https://youtu.be/nHN0E_5kEfc

Part two (8:11) demonstrates how to restart the peer service, so that it reads the database driver file and creates the relevant metrics tables in the external database and how to verify that the tables are in the database. It shows how to set up a workflow to capture process metrics, export the export the process, activate it on the grid, set up appropriate permissions for the workflow, set up a process schedule that runs the workflow, turn on metrics collection, and verify that the metrics were collected.

 https://youtu.be/oMR1QcVWc0o

Was this page helpful? Yes No Submitting... Thank you

Comments