Page History
...
| Info |
|---|
|
| Column Name | Column Description |
|---|---|
SYNS_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYNS_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and |
SYNS_PWHG_ID | Hour group ID. |
SYNS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYNS_DATABASE_ID | ID of the database to which the statement belongs, normalized in table |
SYNS_TOTAL_INSYBASE_TIME_SUM | Total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYNS_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this statement. |
SYNS_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SYNS_CPU_SUM | Amount of time the process was actively executing a statement. |
SYNS_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SYNS_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYNS_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SYNS_LOG_WAIT_SUM | Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a COMMIT or ROLLBACK operation. |
SYNS_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYNS_LOG_SUSPEND_SUM | The amount of time the process was waiting for an operation of the log file to terminate. This state is generally encountered during a transaction log full. |
SYNS_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYNS_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYNS_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYNS_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYNS_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYNS_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SYNS_NUM_OF_SESSIONS_NOT_ENDED | Number of statement executions, which ended during the row's timeframe. |
SYNS_NUM_OF_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SYNS_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SYNS_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SYNS_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYNS_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYNS_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SYNS_SLA_RED_SUM | For future use. |
SYNS_SLA_YELLOW_SUM | For future use. |
SYNS_SLA_GREEN_SUM | For future use. |
SYNS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYNS_ROWID | Unique row number. |
SYNS_WORK_TYPE | Type of session, such as batch, dialog, or queue. |
PW_SYPQ_PLL_QUERY_STATS_T
Contains overtime counter values. Includes counters that are relevant to Parallel Queries statistics.
| Info |
|---|
|