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 |