Changes to Monitoring Tables

Adaptive Server version 15.7 includes changes to some monitoring tables.

Changes to monCachePool

Monitoring table Description

LogicalReads

Number of buffers read from the pool

PhysicalWrites

Number of write operations performed for data in this pool (one write operation may include multiple pages)

APFReads

Number of APF read operations that loaded pages into this pool

APFPercentage

The configured asynchronous prefetch limit for this pool

WashSize

The wash size, in kilobytes, for a memory pool

Changes to monCachedProcedures

Monitoring table Description

ExecutionCount

Number of times Adaptive Server executed the stored procedure plan or tree since it was cached

CPUTime

Total number of milliseconds of CPU time used

ExecutionTime

Total amount of elapsed time (in milliseconds) Adaptive Server spent executing the stored procedure plan or tree

PhysicalReads

Number of physical reads performed

LogicalReads

Number of pages read

PhysicalWrites

Number of physical writes performed

PagesWritten

Number of pages written

Changes to monCachedStatement

Monitoring table Description

OptimizationGoal

Optimization goal stored in the statement cache

OptimizerLevel

Optimizer level stored in the statement cache

Changes to monDataCache

Monitoring table Description

Status

Status of the cache

Type

Type of cache

CacheSize

Total size of cache, in kilobytes

ReplacementStrategy

Cache replacement strategy

APFReads

Number of asynchronous prefetch (APF) reads for this data cache

Overhead

Cache overhead

Columns added to monDeadLock

Column Description
HeldClientApplName

Value for the clientapplname property set by the application holding the lock

HeldClientName

Value of the clientname property set by the application holding the lock

HeldClientHostName

Value for the clienthostname property set by the application holding the lock

HeldHostName

Name of the host machine on which the application that executed the query holding the lock is running

HeldNumLocks

Number of locks currently held by holding spid

HeldProcDBName

Name of the database in which the stored procedure was executing the blocking process at the time the deadlock occurred, if applicable

HeldProcedureName

Name of the stored procedure the blocking process was executing at the time the deadlock occurred, if applicable

HeldProgramName

Name of program running the process that holds the lock

HeldStmtNumber

Statement number in the SQL batch of the SQL statement holding the lock

ObjectDBName

Name of the database

ObjectID

Unique identifier for the object

WaitApplName

Name of the application waiting for the lock

WaitBatchID

Identifier of the SQL batch executed by the process waiting for the lock when the lock timeout occurred

WaitClientApplName

Value of the clientapplname property set by the application waiting for the lock

WaitClientHostName

Value of the clienthostname property set by the application waiting for the lock

WaitClientName

Value of the clientname property set by the application waiting for the lock

WaitCommand

Category of process or command that the process was executing when it was blocked and then timed out

WaitContextID

Unique context identifier for the process waiting for the lock when it was blocked by another process

WaitHostName

Name of the host running the process waiting for the lock

WaitLineNumber

Line number of the SQL statement in the SQL batch or stored procedure waiting for the lock

WaitProcDBID

Unique identifier for the database in which the stored procedure waiting for the lock resides, if applicable

WaitProcDBName

Name for the database where the stored procedure that is waiting for the lock resides, if applicable

WaitProcedureID

ID of the stored procedure waiting for the lock, if applicable

WaitProcedureName

Name for the stored procedure waiting for the lock, if applicable

WaitProgramName

Name of the program running the process

WaitStmtNumber

Line number in SQL batch waiting for the lock

WaitTranName

Name of the transaction in which the lock was requested

Changes to monErrorLog

Adaptive Server version 15.7 and later change the value for stack traces in the monErrorLog.Severity column. Earlier versions used 0 as a value for stacktraces. In Adaptive Server version 15.7, all rows representing stack traces have a Severity value of 99.

Changes to monLockTimeout

Monitoring table Description
HeldProgramName

Removed from monLockTimeout

WaitProgramName

Removed from monLockTimeout

HeldProcedureID

Unique object identifier for the stored procedure that the blocking process was executing when the timeout occurred

WaitProcedureID

Unique object identifier for the stored procedure that is waiting for the lock, if applicable

Changes to monOpenObjectActivity

Monitoring table Description
SharedLockWaitTime

The total amount of time, in milliseconds, that all tasks spent waiting for a shared lock

ExclusiveLockWaitTime

The total amount of time, in milliseconds, that all tasks spent waiting for an exclusive lock

UpdateLockWaitTime

The total amount of time, in milliseconds, that all tasks spent waiting for an update lock

ObjectCacheDate

Indicates the date and time when the object was added to the cache

Changes to monOpenPartitionActivity

Monitoring table Description
ObjectCacheDate

Indicates the date and time when the object was added to the cache

Changes to monProcess

Monitoring table Description
HostName

Name of the host machine on which the application that started the process is running

ClientName

Value of the clientname property set by the application

ClientHostName

Value of the clienthostname property set by the application

ClientApplName

Value of the clientapplname property set by the application

Changes to monProcessActivity

Monitoring table Description
HostName

Name of the host machine on which the application that executed the query is running

Application

Name of the application

ClientName

Value of the clientname property set by the application

ClientHostName

Value of the clienthostname property set by the application

ClientApplName

Value of the clientapplname property set by the application

Changes to monProcessLookup

Monitoring table Description
ClientName Value of the clientname property set by the application
ClientHostName Value of the clienthostname property set by the application
ClientApplName

Value of the clientapplname property set by the application

Changes to monProcessProcedures

Monitoring table Description
ExecutionCount

Number of times Adaptive Server executed this instance of the stored procedure held in the procedure cache

CPUTime

The amount of CPU time, in milliseconds, that Adaptive Server spent executing the instance of this stored procedure held in the procedure cache

ExecutionTime

Total amount of time, in milliseconds, Adaptive Server spent executing the instance of this stored procedure held in the procedure cache

PhysicalReads

Number of physical reads performed by the instance of this stored procedure held in the procedure cache

LogicalReads

Number of logical reads performed by the instance of this stored procedure held in the procedure cache

PhysicalWrites

Number of physical writes performed by the instance of this stored procedure held in the procedure cache

PagesWritten

Number of pages read by the instance of this stored procedure held in the procedure cache

Changes to monTableColumns

monTableColumns includes these changes:
  • Adaptive Server versions 15.7 and later include the column’s unit of measurement in the Description column of monTableColumns.
  • monTableColumn adds the Label column (datatype varchar(50)), which contains a brief description of the data presented in the column. You can use these values in application user interfaces instead of the actual column names.

Changes to monTables, monTableColumns, monWaitEventInfo, and monWaitClassInfo

These monitoring tables add the Language column (datatype varchar(30)), which allows you to specify the language in which Adaptive Server returns the values of the Description column and the monTableColumns.Label column.

See the Reference Manual: Tables.