The monSysExecutionTime monitoring table includes one row for each operation module executed by Adaptive Server.
Enable the enable monitoring and execution time monitoring configuration parameters for this monitoring table to collect data.
The columns for monSysExecutionTime are:
| Name | Datatype | Attribute | Description |
|---|---|---|---|
| InstanceID | smallint | (Cluster environments only) ID of an instance in a shared-disk cluster | |
| OperationID | int | Unique ID of an operation category | |
| OperationName | varchar(30) | Name of the operation category | |
| ExecutionTime | bigint | counter | Execution time, in microseconds, of each operation performed |
| ExecutionCnt | bigint | counter | Total number of occurrences of this operation type |