Page History
...
| Info |
|---|
|
| Column Name | Column Description |
|---|---|
SYSE_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSE_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 |
SYSE_PWHG_ID | Hour group ID. |
SYSE_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSE_PROGRAM_ID | ID of the application program, normalized in table PW_SYPN_PROGRAM_NAMES_N. |
SYSE_DATABASE_ID | ID of the database to which the statement belongs, normalized in table |
SYSE_USER_ID | One of the Sybase users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table |
SYSE_LOGIN_ID | The name used to log in to the database. In case of Windows Authentication mode, it contains the domain and the Windows user name, normalized in table |
SYSE_MACHINE_ID | The ID of the client workstation, normalized in table |
SYSE_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SYSE_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYSE_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SYSE_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYSE_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SYSE_TOTAL_INSYBASE_TIME_SUM | Total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYSE_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this statement. |
SYSE_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SYSE_CPU_SUM | Amount of time the process was actively executing a statement. |
SYSE_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. |
SYSE_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYSE_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SYSE_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. |
SYSE_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYSE_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. |
SYSE_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYSE_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYSE_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYSE_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYSE_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYSE_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SYSE_NUM_OF_SESSIONS_NOT_ENDED | Number of statement executions, which ended during the row's timeframe. |
SYSE_NUM_OF_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SYSE_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SYSE_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SYSE_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYSE_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYSE_STAT_OPEN_TRANS_MAX | Number of |
transactions the process opened. | |
SYSE_PARALLEL_DEGREE_MIN | Minimum number of sessions executing this statement in parallel. |
SYSE_PARALLEL_DEGREE_MAX | Maximum number of sessions executing this statement in parallel. |
SYSE_SLA_RED_SUM | For future use. |
SYSE_SLA_YELLOW_SUM | For future use. |
SYSE_SLA_GREEN_SUM | For future use. |
SYSE_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYSE_ROWID | Unique row number. |
SYSE_START_BIT_ID | For future use. |
PW_SYNS_INSTANCE_STATS_T
Stores application performance statistics per timeslice for every combination of instance and database.
| 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. |