Changed Monitoring Tables

SAP ASE 16.0 includes changes to existing monitoring tables.

monCachedStatement

monCachedStatement in SAP ASE 16.0 and later:
  • Updates the metrics for these columns approximately every 5 seconds for completed and in-process queries:
    Description Datatype Attribute Description
    TotalLIO bigint counter Cumulative logical I/O
    TotalPIO bigint counter Cumulative physical I/O
    TotalCPUTime bigint counter Cumulative elapsed time, in seconds, this statement spent using CPU
    TotalElapsedTime bigint counter Cumulative amount of time, in seconds spent executing this statement
    Versions of SAP ASE earlier than 16.0 updated metrics in monCachedStatement when the statement finished. However, when SAP ASE 16.0 and later executes a statement cache, it periodically updates these values while it executes a query:
    • TotalLIO
    • MaxLIO
    • TotalPIO
    • MaxPIO
    • TotalCPUTime
    • MaxCPUTime
    • TotalElapsedTime
    • MaxElapsedTime

    Other metrics (for example, MinLIO and AvgLIO) are updated after query executions are finished.

  • Increments the UseCount column when statement begin execution. The value for UseCount is
    (number of completed queries) + (number of ongoing queries)
    The CurrentUsageCount column includes the number of active queries for a statement. The number of completed executions for a statement is:
    (Value of UseCount) – (value of CurrentUsageCount)
  • Increments the value for columns that describe maximums (for example, MaxCPUTime) for currently executing statements if the metric described by the column (in this case, CpuTime) exceeds the maximum value used during an intermediate update. Maximum columns reflect up-to-date metrics (including metrics for active queries), which helps determine if a currently executing query is consuming resources that exceed previous or normal usage.

monDeadLock

Description Datatype Attribute Description
partitionid int Null Unique identifier for the partition

monLocks

Description Datatype Attribute Description
partitionid int Null Unique identifier for the partition

monOpenObjectActivity

SAP ASE version 16.0 and later adds these columns to the monOpenObjectActivity monitoring tables.

Description Datatype Attribute Description
Scans int counter Number of scans performed on this object.
LastScanDate datetime counter Date of the last scan on this object
Updates int counter Number of updates performed on this object.
LastUpdateDate datetime counter Date of the last update on this object
Inserts int counter Number of inserts performed on this object.
LastInsertDate datetime counter Date of the last insert on this object
Deletes int counter Number of deletes performed on this object.
LastDeleteDate datetime counter Date of the last delete on this object

monOpenPartitionActivity

SAP ASE version 16.0 and later adds these columns to the monOpenPartitionActivity monitoring tables.

Description Datatype Attribute Description
Scans int counter Number of scans performed on this object.
LastScanDate datetime counter Date of the last scan on this object
Updates int counter Number of updates performed on this object.
LastUpdateDate datetime counter Date of the last update on this object
Inserts int counter Number of inserts performed on this object.
LastInsertDate datetime counter Date of the last insert on this object
Deletes int counter Number of deletes performed on this object.
LastDeleteDate datetime counter Date of the last delete on this object

monProcess

Description Datatype Attribute Description
ClientDriverVersion varchar16   Version of the connectivity driver used by the client program

monRepLogActivity, monRepScannersTotalTime, and monRepSenders

SAP ASE versions 16.0 and later require that you enable the activate monitoring configuration parameter for the monRepLogActivity, monRepScannersTotalTime, and monRepSenders monitoring tables to start collecting monitoring data.

monRepScanners

SAP ASE version version 16.0 makes these changes to Status column of the monRepScanners monitoring table:
  • Removes the value spawned
  • Adds the values sync mode, async mode, and near sync mode

monRepScannersTotalTime

SAP ASE version version 16.0 changes the name of the MRPBootstrapTime column to BootstrapTime.

monSysExecutionTime

SAP ASE version 16.0 and later include these values for the OperationName column:
  • NetworkIO – Reports time spent sending and receiving netword data
  • DeviceIO – Reports time spent performing disk IO operations
  • CIPCIO – Reports time spent performing cluster interconnect network operations (Cluster Edition only)

monTables

The Description column in SAP ASE 16.0 and later supports 512 characters. Previous releases supported 255 characters.

monTableColumns

  • The Description column in SAP ASE version 16.0 and later supports 512 characters. Previous versions supported 255 characters.
  • The Label column in SAP ASE version 16.0 and later supports 150 characters. Previous versions support 50 characters.