Adaptive Server 15.7 SP100 includes changes to existing monitoring tables.
| Description | Datatype | Description |
|---|---|---|
| NumLevel0Waiters | float | Number of times a Level0 Scan start waited because of a utility's wait request. |
| AvgLevel0WaitTime | float | Average time, in milliseconds, Adaptive Server waited for Level0 access. |
The MaxHashSchemaSize and NumberOfSchemasReused columns of the monRepLogActivity table have been removed.
The NumberOfTruncPointRequested and NumberOfTruncPointMoved columns are populated only when the single task scanning of a log model is used. When the Multiple Replication Paths (MRP) model is used, these columns values are 0. The monRepSenders table contains related information for the MRP model.
| Description | Datatype | Description |
|---|---|---|
| NumberOfTruncPointRequested | int | Total number of times RepAgent asked Replication Server for a new truncation point. |
| NumberOfTruncPointMoved | int | Total number of times RepAgent moved the secondary truncation point. |
| AvgTruncPointInterval | int | Displays the average time between truncation point requests. This value is an indication of the effectiveness of the trunc point request interval configuration parameter. If trunc point request interval is set correctly, the values of trunc point request interval and AvgTruncPointInterval will be the same. |
| Name | Datatype | Attribute | Description |
|---|---|---|---|
| SpinlockSlotID | int | ID for this spinlock in the spinlock memory pool |
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
| Name | Datatype | Attribute | Description |
|---|---|---|---|
| TableAccesses | bigint | Counter | Number of pages from which data was retrieved without an index |
| IndexAccesses | bigint | Counter | Number of pages from which data was retrieved using an index |
| ULCFlushes | bigint | Counter | Total number of times the User Log Cache was flushed |
| ULCFlushFull | bigint | Counter | Number of times the User Log Cache was flushed because it was full |
| WorkTables | bigint | Counter | Total number of work tables created |
| TempDBObjects | bigint | Counter | Total number of temporary tables created |
| Rollbacks | bigint | Counter | Total number of transactions rolled back |
| Selects | bigint | Counter | Total number of select operations executed |
| Updates | bigint | Counter | Total number of update operations executed |
| Inserts | bigint | Counter | Total number of insert operations executed |
| Deletes | bigint | Counter | Total number of delete operations executed |
| Merges | bigint | Counter | Total number of merge operations executed |
| ULCKBWritten | bigint | Counter | Number of kilobytes written to the user log cache |
| PagesRead | bigint | Counter | Number of pages read server-wide |
| PagesWrite | bigint | Counter | Number of pages written server-wide |
| PhysicalReads | bigint | Counter | Number of buffers read from the disk |
| PhysicalWrites | bigint | Counter | Number of buffers written to the disk |
| LogicalReads | bigint | Counter | Number of buffers read from cache |