Provides information regarding the overall state of the SAP ASE server.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monState are:
|
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
| InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
| LockWaitThreshold |
int |
Time (in seconds) that a process must wait for a lock before it is counted as blocked and reported in the LockWaits column. The default value for LockWaitThreshold is 5 seconds. The default is used if you do not specify a value in the where clause of the query (for example LockWaitThreshold=30). |
|
| LockWaits |
int |
Number of process that have waiting for a lock longer than the value of LockWaitThreshold. |
|
| DaysRunning |
int |
Number of days the SAP ASE server has been running. |
|
| CheckPoints |
int |
Specifies if any checkpoint is currently running. |
|
| NumDeadlocks |
int |
Counter |
Total number of deadlocks that have occurred. |
| DiagnosticDumps |
int |
Specifies if a shared memory dump is currently in progress for this server. |
|
| Connections |
int |
Number of active inbound connections. |
|
| MaxRecovery |
int |
The maximum time (in minutes), per database, that the SAP ASE server uses to complete its recovery procedures in case of a system failure; also, the current Run Value for the recovery interval in minutes configuration option. |
|
| Transactions |
int4 |
Number of transactions run, server-wide. |
|
| 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 |
| 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 |
| TempDBObjects | bigint | Counter | Total number of temporary tables created |
| WorkTables | bigint | Counter | Total number of work tables created |
| 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 |
| ULCKBWritten | bigint | Counter | Number of kilobytes written to the user log cache |
| PagesRead | bigint | Counter | Number of pages read server-wide |
| PagesWritten | 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 |
|
StartDate |
datetime |
Date and time the SAP ASE server was started. |
|
|
CountersCleared |
datetime |
Date and time the monitor counters were last cleared. |