Monitoring Table Changes

Adaptive Server version 15.7 ESD #2 includes changes to some monitoring tables.

monCachedStatement adds these columns:

Monitoring table Description
AvgScanRows Average number of scanned rows read per execution
MaxScanRows

Maximum number of scanned rows read per execution

AvgQualifyingReadRows Average number of qualifying data rows per read command execution

MaxQualifyingReadRows

Maximum number of qualifying data rows per read command execution
AvgQualifyingWriteRows Average number of qualifying data rows per write command execution
MaxQualifyingWriteRows Maximum number of qualifying data rows per write command execution
LockWaits Total number of lock waits
LockWaitTime Total amount of time, in milliseconds, spent waiting for locks
SortCount Total number of sort operations
SortSpilledCount Total number of sort operations spilled to disk
TotalSortTime Total amount of time, in milliseconds, spent in sorts
MaxSortTime Maximum amount of time, in milliseconds, spent in a sort