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. |
PW_SYPQ_PLL_QUERY_STATS_T
Contains overtime counter values. Includes counters that are relevant to Parallel Queries statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYPQ_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYPQ_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYPQ_PWHG_ID | Hour group ID. |
SYPQ_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYPQ_PARALLEL_QUERIES_SUM | Total number of queries eligible to be run in parallel. |
SYPQ_PLL_THREAD_LIMIT_ADJ_SUM | Number of times the number of worker processes for a cached query plan was adjusted, due to a session-level limit. |
SYPQ_PLL_NOTHREAD_ADJ_SUM | Number of times the number of worker processes for a cached query plan was adjusted, due to lack of available worker processes. |
SYPQ_NETWORK_BUF_IMMEDIATE_SUM | Number of parallel network buffer merge locks with no wait. |
SYPQ_NETWORK_BUF_WAIT_SUM | Number of parallel network buffer merge locks with wait. |
SYPQ_RESULT_BUF_IMMEDIATE_SUM | Number of parallel result buffer merge locks with no wait. |
SYPQ_RESULT_BUF_WAIT_SUM | Number of parallel result buffer merge locks with wait. |
SYPQ_WORKTAB_BUF_IMMEDIATE_SUM | Number of parallel work table merge locks with no wait. |
SYPQ_WORKTAB_BUF_WAIT_SUM | Number of parallel work table merge locks with wait. |
SYPQ_PLL_SORT_MERGE_WAIT_SUM | Number of contention on a parallel sort buffer merge locks that are caused by producers (returning rows from parallel scans). |
SYPQ_PLL_SORTING_WAIT_SUM | Number of contention on a parallel sort buffer merge locks that are caused by consumers (performing the parallel sort). |
SYPQ_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYMS_MISC_STATISTICS_T
Contains overtime counter values. Includes miscellaneous counters.
Info |
---|
|
Column Name | Column Description |
---|---|
SYMS_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYMS_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYMS_PWHG_ID | Hour group ID. |
SYMS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYMS_ESP_REQUESTS_SUM | Number of extended stored procedure calls. |
SYMS_ESP_EXEC_TICKS_SUM | Average time for all extended stored procedures. |
SYMS_HK_GC_WAKES_SUM | Number of times the housekeeper garbage collection checked for space that can be reclaimed. |
SYMS_HK_GC_PAGES_SUM | Number of pages reclaimed by the housekeeper garbage collection. |
SYMS_HK_STATS_WAKES_SUM | Number of times the housekeeper chore tasks checked to see if statistics needed to be written. |
SYMS_SPINS_FOR_PLAN_SUM | Number of times that a process attempting to use |
SYMS_TXT_SIZE_OVERFLOWS_SUM | Number of times that SQL batch text exceeded the text buffer size. |
SYMS_TXT_REQS_MAX | Maximum size of a SQL batch. |
SYMS_PROC_READS_SUM | Number of times that stored procedures were read from disk, rather than found and copied in the procedure cache. |
SYMS_PROC_REMOVALS_SUM | Number of times that a procedure aged out of cache. |
SYMS_PROC_REQS_SUM | Number of times stored procedures were executed. |
SYMS_PROC_WRITES_SUM | Number of procedures created. |
SYMS_MEM_PAGES_ALLOCS_SUM | Number of times that a new page was allocated in the memory. |
SYMS_PAGES_FREES_SUM | Number of times that a page was freed. |
SYMS_CHECKPOINT_TOTAL_SUM | Number of normal checkpoints. |
SYMS_HK_FREE_DB_CKPTS_SUM | Number of checkpoints performed by the housekeeper wash task. |
SYMS_CHECKPOINT_TIME_SUM | Interval of normal checkpoints. |
SYMS_HK_TIME_DB_CKPTS_SUM | Interval of free checkpoints. |
SYMS_NET_PACKETS_RECEIVED_SUM | Number of network packets ASE received. |
SYMS_NET_PACKETS_SENT_SUM | Number of network packets ASE sent. |
SYMS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYMS_RECOMP_CURSOR_CHANGE_SUM | Number of times stored procedures were recompiled due to cursor permission change. |
SYMS_RECOMP_INDEX_CHANGE_SUM | Number of times stored procedures were recompiled due to index change. |
SYMS_RECOMP_ISOLEVEL_SUM | Number of times stored procedures were recompiled due to isolation level change. |
SYMS_RECOMP_PERMISSIONS_SUM | Number of times stored procedures were recompiled due to permissions change. |
SYMS_RECOMP_SCHEMA_SUM | Number of times stored procedures were recompiled due to schema change. |
SYMS_RECOMP_TABLE_MISSING_SUM | Number of times stored procedures were recompiled due to table missing. |
SYMS_RECOMP_TEMP_TAB_MISS_SUM | Number of times stored procedures were recompiled due to temporary table missing. |
SYMS_RECOMP_COMP_PHASE_SUM | Number of times recompilation was triggered at compilation phase. |
SYMS_RECOMP_EXEC_PHASE_SUM | Number of times recompilation was triggered at execution phase. |
SYMS_RECOMP_EXEC_CURSOR_SUM | Number of times recompilation was triggered at execute cursor execution phase. |
SYMS_RECOMP_REDEFIN_PHASE_SUM | Number of times recompilation was triggered at redefinition phase. |
SYMS_STATEMENTS_DROPPED_SUM | Number of statements that were dropped instead of cached. |
SYMS_STMT_IN_CACHE_SUM | Number of times a query plan was reused. |
SYMS_STMT_NOT_IN_CACHE_SUM | Number of times an SQL statement was not found in cache. |
SYMS_STMT_NOT_CACHED_SUM | Number of statements Adaptive Server would have cached if the statement cache were enabled. |
SYMS_STMT_CACHED_SUM | Number of SQL statements in cache. |
SYMS_STMT_RESTORED_SUM | Number of query plans regenerated from the SQL text. |
PW_SYLM_LOCK_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Lock statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYLM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYLM_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYLM_PWHG_ID | Hour group ID. |
SYLM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYLM_WAIT_EX_LATCH_SUM | Number of times a task was switched out because it needed to wait for an EX latch type. |
SYLM_WAIT_NO_LATCH_SUM | Number of times a task was switched out because it needed to wait for a NO latch type. |
SYLM_WAIT_SH_LATCH_SUM | Number of times a task was switched out because it needed to wait for an SH latch type. |
SYLM_SPLIT_INDEX_DEADLOCK_SUM | Number of times ASE server retried to split a page, due to contention and ended in a deadlock. |
SYLM_GRANTED_LOCKS_SUM | Number of times locks were granted immediately. |
SYLM_WAITED_LOCKS_SUM | Number of times a task had to wait for a lock. |
SYLM_LOCK_CONTENTION_SUM | Number of times there was lock contention. |
SYLM_DEADLOCKS_SUM | Number of deadlocks. |
SYLM_HASHTABLE_LOOKUPS_SUM | Number of times the lock hash table was searched for a lock on a page, row, or table. |
SYLM_GRANTED_EX_TAB_SUM | Number of times an exclusive table lock type was granted immediately. |
SYLM_WAITED_EX_TAB_SUM | Number of times a task had to wait for an exclusive table lock type. |
SYLM_GRANTED_SH_TAB_SUM | Number of times a shared table lock type was granted immediately. |
SYLM_WAITED_SH_TAB_SUM | Number of times a task had to wait for a shared table lock type. |
SYLM_GRANTED_EX_INT_SUM | Number of times an exclusive intent lock type was granted immediately. |
SYLM_WAITED_EX_INT_SUM | Number of times a task had to wait for an exclusive intent lock type. |
SYLM_GRANTED_SH_INT_SUM | Number of times a shared intent lock type was granted immediately. |
SYLM_WAITED_SH_INT_SUM | Number of times a task had to wait for a shared Intent lock type. |
SYLM_GRANTED_EX_PAGE_SUM | Number of times an exclusive page lock type was granted immediately. |
SYLM_WAITED_EX_PAGE_SUM | Number of times a task had to wait for an exclusive page lock type. |
SYLM_GRANTED_SH_PAGE_SUM | Number of times a shared page lock type was granted immediately. |
SYLM_WAITED_SH_PAGE_SUM | Number of times a task had to wait for a shared page lock type. |
SYLM_GRANTED_UP_PAGE_SUM | Number of times an update page lock type was granted immediately. |
SYLM_WAITED_UP_PAGE_SUM | Number of times a task had to wait for an update page lock type. |
SYLM_GRANTED_EX_ROW_SUM | Number of times an exclusive row lock type was granted immediately. |
SYLM_WAITED_EX_ROW_SUM | Number of times a task had to wait for an exclusive row lock type. |
SYLM_GRANTED_SH_ROW_SUM | Number of times a shared row lock type was granted immediately. |
SYLM_WAITED_SH_ROW_SUM | Number of times a task had to wait for a shared row lock type. |
SYLM_GRANTED_UP_ROW_SUM | Number of times an update row lock type was granted immediately. |
SYLM_WAITED_UP_ROW_SUM | Number of times a task had to wait for an update row lock type. |
SYLM_GRANTED_SH_NKL_SUM | Number of times a shared next key lock type was granted immediately. |
SYLM_WAITED_SH_NKL_SUM | Number of times a task had to wait for a shared next key lock type. |
SYLM_GRANTED_EX_ADDRESS_SUM | Number of times an exclusive address lock type was granted immediately. |
SYLM_WAITED_EX_ADDRESS_SUM | Number of times a task had to wait for an exclusive address lock type. |
SYLM_GRANTED_SH_ADDRESS_SUM | Number of times a shared address lock type was granted immediately. |
SYLM_WAITED_SH_ADDRESS_SUM | Number of times a task had to wait for a shared address lock type. |
SYLM_EX_TAB_DEADLOCK_SUM | Number of times an exclusive table deadlock has occurred. |
SYLM_SH_TAB_DEADLOCK_SUM | Number of times a shared table deadlock has occurred. |
SYLM_EX_INT_DEADLOCK_SUM | Number of times an exclusive intent deadlock has occurred. |
SYLM_SH_INT_DEADLOCK_SUM | Number of times a shared intent deadlock has occurred. |
SYLM_EX_PAGE_DEADLOCK_SUM | Number of times an exclusive page deadlock has occurred. |
SYLM_UP_PAGE_DEADLOCK_SUM | Number of times an updated page deadlock has occurred. |
SYLM_SH_PAGE_DEADLOCK_SUM | Number of times a shared page deadlock has occurred. |
SYLM_EX_ROW_DEADLOCK_SUM | Number of times an exclusive row deadlock has occurred. |
SYLM_UP_ROW_DEADLOCK_SUM | Number of times an updated row deadlock has occurred. |
SYLM_SH_ROW_DEADLOCK_SUM | Number of times a shared row deadlock has occurred. |
SYLM_SH_NKL_DEADLOCK_SUM | Number of times a shared next key deadlock has occurred. |
SYLM_EX_ADDR_DEADLOCK_SUM | Number of times an exclusive address deadlock has occurred. |
SYLM_SH_ADDR_DEADLOCK_SUM | Number of times a shared address deadlock has occurred. |
SYLM_DEADLOCK_SRCH_SUM | Number of times Adaptive Server initiated a deadlock search. |
SYLM_DEADLOCK_SRCH_SKIP_SUM | Number of times a task started to perform deadlock checking, but found deadlock checking in progress and skipped its check. |
SYLM_TOTAL_PROMOTIONS_SUM | Number of lock promotions. |
SYLM_EX_TAB_PROMOTIONS_SUM | Number of times an exclusive page to exclusive table escalation has occurred. |
SYLM_SH_TAB_PROMOTIONS_SUM | Number of times a shared page to shared table escalation has occurred. |
SYLM_EX_ROWPROMOTIONS_SUM | Number of times an exclusive row to exclusive table escalation has occurred. |
SYLM_SH_ROW_PROMOTIONS_SUM | Number of times a shared row to shared table escalation has occurred. |
SYLM_SH_NKL_PROMOTIONS_SUM | Number of times a shared next key to shared table escalation has occurred. |
SYLM_TOTAL_TIMEDOUTS_SUM | Number of times a task was waiting for a lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_EX_TAB_TIMEDOUTS_SUM | Number of times a task was waiting for an exclusive table lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_TAB_TMEDOUTS_SUM | Number of times a task was waiting for a shared table lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_EX_INT_TIMEDOUTS_SUM | Number of times a task was waiting for an exclusive intent lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_INT_TIMEDOUTS_SUM | Number of times a task was waiting for a shared intent lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_EX_PAGE_TIMEDOUTS_SUM | Number of times a task was waiting for an exclusive page lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_UP_PAGE_TIMEDOUTS_SUM | Number of times a task was waiting for an update page lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_PAGE_TIMEDOUTS_SUM | Number of times a task was waiting for a shared page lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_EX_ROW_TIMEDOUTS_SUM | Number of times a task was waiting for an exclusive row lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_UP_ROW_TIMEDOUTS_SUM | Number of times a task was waiting for an update row lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_ROW_TIMEDOUTS_SUM | Number of times a task was waiting for a shared row lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_EX_ADDR_TIMEDOUTS_SUM | Number of times a task was waiting for an exclusive address lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_ADR_TIMEDOUTS_SUM | Number of times a task was waiting for a shared address lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_SH_NKL_TIMEDOUTS_SUM | Number of times a task was waiting for a shared next key lock and the transaction was rolled back, due to a session-level or server-level lock timeout. |
SYLM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYLM_HASH_CHAIN_LENGTH_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_TABLE_HASHTAB_LKUP_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_TAB_AVG_CHAIN_LEN_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_PAGEROW_HASHTAB_LKUP_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_PAGEROWAVG_CHAIN_LEN_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_ADDRESS_HASHTAB_LKUP_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SYLM_ADDRESS_AVG_CHAIN_LEN_SUM | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SYTM_TRAN_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Transaction statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYTM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYTM_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYTM_PWHG_ID | Hour group ID. |
SYTM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYTM_LOG_SEMAPHORE_WAITED_SUM | Number of context switches, caused by contention on a log semaphore. |
SYTM_ULC_SEMAPHORE_WAITS_SUM | Number of context switches, caused by contention on PLC. |
SYTM_TRANSACTIONS_SUM | Number of committed transactions. |
SYTM_INS_HEAP_ROWS_SUM | Number of rows inserted to heap tables. |
SYTM_INS_CLUS_ROWS_SUM | Number of rows inserted to clustered tables. |
SYTM_INS_DOL_ROWS_SUM | Number of rows inserted to data-only-lock tables. |
SYTM_UPD_DEFERRED_ROWS_SUM | Number of rows updated in deferred mode. |
SYTM_UPD_DIRECT_PLACE_ROWS_SUM | Number of rows updated directly, in-place. |
SYTM_UPD_CHEAP_DIRECT_ROWS_SUM | Number of rows updated directly, not in-place. |
SYTM_UPD_EXPENSIVE_ROWS_SUM | Number of rows updated directly, expansive (causing row movement). |
SYTM_UPD_DOL_DEFERRED_ROWS_SUM | Number of rows updated in deferred mode in DOL tables. |
SYTM_UPD_DOL_ROWS_SUM | Number of rows updated in DOL tables. |
SYTM_UPD_DOL_REPLACE_ROWS_SUM | Number of rows replaced in DOL tables. |
SYTM_UPD_DOL_SHRINK_ROWS_SUM | Number of rows shrunken, while updated in DOL tables. |
SYTM_DOL_CHEAP_EXPANDS_SUM | Number of rows expanded, while updated in DOL tables. The row was the last row on the page. |
SYTM_DOL_EXPENSIVE_EXPANDS_SUM | Number of rows expanded, while updated in DOL tables. The update caused row movement. |
SYTM_DOL_EXPANDS_FORWARDS_SUM | Number of rows expanded and forwarded, while updated in DOL tables. |
SYTM_DOL_FORWARDS_RET_ROWS_SUM | Number of rows that were forwarded already and now fit in original page and returned to original page in DOL tables. |
SYTM_DEL_DEFERRED_ROWS_SUM | Number of rows deleted in deferred mode. |
SYTM_DEL_APL_ROWS_SUM | Number of rows deleted directly. |
SYTM_DEL_DOL_ROWS_SUM | Number of rows deleted from DOL tables. |
SYTM_FULL_LOG_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because the ULC became full. |
SYTM_ENDXACT_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a transaction ended. |
SYTM_CHANGE_DB_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a database changed. |
SYTM_SYS_LOG_REC_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a system transaction occurred within the user transaction. |
SYTM_UNPIN_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because of other reasons. |
SYTM_LOG_RECORDS_SUM | Average number of log records per transaction. |
SYTM_ULC_SIZE_MAX | Maximum number of bytes used in ULCs. |
SYTM_LOG_SEMAPHORE_GRANTED_SUM | Number of log semaphore requests granted immediately. |
SYTM_ULC_SEMAPHORE_REQ_SUM | Number of ULC semaphore requests. |
SYTM_TRAN_LOG_ALLOC_SUM | Number of times additional pages were allocated to the transaction log. |
SYTM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDC_DATA_CACHE_MANAGEMENT_T
Contains overtime counter values. Includes counters that are relevant to Data Cache statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYDC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDC_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYDC_PWHG_ID | Hour group ID. |
SYDC_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDC_COUNTER_INSTANCE | The Instance of this counter. |
SYDC_READ_WAITS_SUM | Number of cache search misses resulting in a read. |
SYDC_SYSTEM_DISK_WRITES_SUM | Number of I/O waits caused by I/O requests or restarted I/O requests. |
SYDC_HK_EXECUTIONS_SUM | Number of times the housekeeper executes on a cache. |
SYDC_IO_PACING_SUM | Number of times an I/O extensive task was switched off, due to exceeding an I/O batch limit. |
SYDC_CNTXSW_GROUP_COMMIT_SUM | Number of times a task issued a commit and had to wait till the buffer log got full and was written to disk. |
SYDC_LOG_LASTPAGE_WRITES_SUM | Number of times a task issued a commit and had to wait till the buffer log was written to disk. |
SYDC_CNTXSW_MODIFY_CNFLCT_SUM | Number of times a task issued a commit and had to wait till the buffer log was written to disk. |
SYDC_HK_WASH_SUM | Number of time the housekeeper tasks perform buffer cache washes. |
SYDC_HK_WASH_CLEAN_SUM | Number of time the housekeeper tasks perform buffer cache washes and found it clean. |
SYDC_LOG_PAGE_WRITES_SUM | Number of times a buffer transaction log page is written to disk. |
SYDC_BUFSEARCH_FINDS_SUM | Number of times a needed page was found in a cache. |
SYDC_BUFSEARCH_FINDS_IN_SUM | Number of times a needed page was found in a cache in the wash mark. |
SYDC_BUFSEARCH_CALLS_SUM | Number of times a cache was searched for a specific page. |
SYDC_LRU_BUFGRAB_2K_SUM | Number of times a buffer is replaced from the pool with I/O size 2K. The page that was replaced, was not changed or was already written to disk, known as clean. |
SYDC_LRU_BUFGRAB_4K_SUM | Number of times a buffer is replaced from the pool with I/O size 4K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_8K_SUM | Number of times a buffer is replaced from the pool with I/O size 8K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_16K_SUM | Number of times a buffer is replaced from the pool with I/O size 16K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_32K_SUM | Number of times a buffer is replaced from the pool with I/O size 32K. The page that was replaced was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_64K_SUM | Number of times a buffer is replaced from the pool with I/O size 64K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_128K_SUM | Number of times a buffer is replaced from the pool with I/O size 128K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_256K_SUM | Number of times a buffer is replaced from the pool with I/O size 256K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_512K_SUM | Number of times a buffer is replaced from the pool with I/O size 512K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_BUFGRAB_DIRTY_2K_SUM | Number of times a buffer is replaced from the pool with I/O size 2K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_4K_SUM | Number of times a buffer is replaced from the pool with I/O size 4K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_8K_SUM | Number of times a buffer is replaced from the pool with I/O size 8K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_16K_SUM | Number of times a buffer is replaced from the pool with I/O size 16K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_32K_SUM | Number of times a buffer is replaced from the pool with I/O size 32K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_64K_SUM | Number of times a buffer is replaced from the pool with I/O size 64K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_128K_SUM | Number of times a buffer is replaced from the pool with I/O size 128K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_256K_SUM | Number of times a buffer is replaced from the pool with I/O size 256K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_512K_SUM | Number of times a buffer is replaced from the pool with I/O size 512K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFUNKEEP_LRU_SUM | Number of buffers that used the normal cache strategy and were placed at the MRU end of the cache. |
SYDC_BUFUNKEEP_MRU_SUM | Number of buffers that were placed at the wash marker, using the fetch-and-discard strategy. |
SYDC_LARGE_IO_PERFORMED_SUM | Number of times a request for a large I/O was performed for a buffer. |
SYDC_PREFETCH_REQ_SUM | Number of times a large I/O was requested for a buffer. |
SYDC_LEVEL0_BUFPREDIRTY_SUM | Average number of pages requested at isolation level 0 for a cache. |
SYDC_BUFWASH_THROUPUT_SUM | Throughput of the buffer wash mark. |
SYDC_BUFWASH_PASS_CLEAN_SUM | Number of buffers that were clean, when they passed the wash marker. |
SYDC_BUFWASH_PASS_WRITE_SUM | Number of times that I/O was already active on a buffer, when it entered the wash area. |
SYDC_BUFWASH_WRITE_DIRTY_SUM | Number of times that a buffer entered the wash area dirty and was not already in I/O. |
SYDC_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYIM_INDEX_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Index Management statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYIM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYIM_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYIM_PWHG_ID | Hour group ID. |
SYIM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYIM_NC_UPDATES_SUM | Number of insert and update operations to a table with indexes that potentially requires modifications to one or more indexes. |
SYIM_NC_UPDATES_INDEXES_SUM | Number of non-clustered indexes that require maintenance, as a result of insert and update operations. |
SYIM_NC_DELETES_SUM | Number of delete operations to a table with indexes that potentially required modifications to one or more indexes. |
SYIM_NC_DELETE_INDEXES_SUM | Number of non-clustered indexes that required maintenance, as a result of delete operations. |
SYIM_NC_RID_UPDATES_SUM | Number of page splits that required maintenance of a non-clustered index. |
SYIM_NC_RID_UPDATE_INDEXES_SUM | Number of non-clustered indexes that required maintenance, as a result of a clustered page split. |
SYIM_NC_DOL_NC_DELETES_SUM | Number of update / delete operations for DOL tables that required maintenance of a non-clustered index. |
SYIM_NC_DOL_NC_DELETES_INDEX_SUM | Number of non-clustered indexes that required maintenance, as a result of update / delete operations for DOL tables. |
SYIM_PAGE_SPLITS_SUM | Number of page splits for data pages, clustered index pages or non-clustered index pages, because there was not enough room for a new row. |
SYIM_INDEX_RETRIES_SUM | Number of times the ASE server retried to split a page, due to contention. |
SYIM_ADD_INDEX_LEVEL_SUM | Number of times a new index level was added. |
SYIM_PAGE_SHRINKS_SUM | Number of page shrinks, due to deleting index rows. |
SYIM_BT_BACKWARD_SCANS_SUM | Number of backward scans on DOL tables. |
SYIM_BT_FORWARD_SCANS_SUM | Number of forward scans on DOL tables. |
SYIM_BACKWARD_SCANS_SUM | Number of backward scans on APL tables. |
SYIM_FORWARD_SCANS_SUM | Number of forward scans on APL tables. |
SYIM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYCM_CACHE_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Metadata Cache statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYCM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYCM_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYCM_PWHG_ID | Hour group ID. |
SYCM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYCM_ACTIVE_OPEN_OBJECTS_MAX | Number of objects that were active. |
SYCM_OPEN_OBJECTS_MAX | Maximum number of objects that were active (from server reboot). |
SYCM_OPEN_OBJECTS_FAILED_SUM | Number of times the objects cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_OBJECTS_REUSES_SUM | Number of times the objects cache had to be searched for reusable descriptors. |
SYCM_ACTIVE_OPEN_INDEXES_MAX | Number of indexes that were active. |
SYCM_OPEN_INDEXES_MAX | Maximum number of indexes that were active (from server reboot). |
SYCM_OPEN_INDEXES_FAILED_SUM | Number of times the indexes cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_INDEXES_REUSES_SUM | Number of times the indexes cache had to be searched for reusable descriptors. |
SYCM_ACTIVE_OPEN_DATABASES_SUM | Number of databases that were active. |
SYCM_OPEN_DATABASES_MAX | Maximum number of databases that were active (from server reboot). |
SYCM_OPEN_DATABASES_FAILED_SUM | Number of times the databases cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_DATABASES_REUSES_SUM | Number of times the databases cache had to be searched for reusable descriptors. |
SYCM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYES_ENGINES_T
Contains overtime counter values. Includes counters that are relevant to Engine statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYES_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYES_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYES_PWHG_ID | Hour group ID. |
SYES_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYES_COUNTER_INSTANCE | Instance of this counter. |
SYES_CLOCK_TICKS_SUM | Number of clock ticks an engine got from the operating system. |
SYES_IDLE_TICKS_SUM | Number of clock ticks an engine was idle. |
SYES_ENGINE_SLEEPS_SUM | Number of times an engine yielded (gave up) to the operating system. |
SYES_DCHECK_CALLS_SUM | Number of times an engine checks for disk I/O. |
SYES_DCHECKS_CALLING_DPOLL_SUM | Number of times an I/O request was completed, when an engine checked for disk I/O. |
SYES_DPOLL_COMPLETED_AIOS_SUM | Number of completed I/O requests. |
SYES_ENGINE_DELAYED_AIOS_SUM | Number of delayed I/O requests, due to engine limit. |
SYES_OS_DELAYED_AIOS_SUM | Number of delayed I/O requests, due to an OS limit. |
SYES_SERVER_DELAYED_SUM | Number of delayed I/O requests, due to a server limit. |
SYES_CONTEXT_SWITCHES_SUM | Number of times an engine switches context from one user task to another. |
SYES_INCOMPATIBLE_TASKS_SUM | Number of times an engine skipped a user task at the head of a run queue. |
SYES_OUTSTANDING_AIOS_SUM | Maximum number of pending I/Os. |
SYES_BYTES_RECEIVED_SUM | Number of bytes an engine received from the network. |
SYES_BYTES_SENT_SUM | Number of bytes an engine sent to the network. |
SYES_PACKETS_RECEIVED_SUM | Number of packets an engine received from the network. |
SYES_PACKETS_SENT_SUM | Number of packets an engine sent to the network. |
SYES_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYKN_KERNELS_T
Contains overtime counter values. Includes counters that are relevant to Kernel statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYKN_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYKN_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYKN_PWHG_ID | Hour group ID. |
SYKN_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYKN_WTM_CONNECT_REQS_SUM | Total number of requests for a worker process. |
SYKN_WTM_DENIED_REQS_SUM | Number of denied worker process requests. |
SYKN_WTM_TERMINATIONS_SUM | Number of worker process requests terminated by the user. |
SYKN_WTM_THREAD_REQS_SUM | Total number of worker processes used. |
SYKN_WTM_HTM_SUM | Maximum number of worker processes used. |
SYKN_WTM_MEMORY_ALLOC_REQS_SUM | Number of requests for memory allocation for worker processes. |
SYKN_WTM_MEMORY_FAIL_REQS_SUM | Number of failed requests for memory allocation for worker processes. |
SYKN_WTM_MEMORY_HWM_MAX | Total memory used by a worker process. |
SYKN_PROCESSES_CREATED_SUM | Summary of opened connections. |
SYKN_PROCESSES_CREATED_MAX | Number of maximum opened connections. |
SYKN_TASK_YIELDS_CNTXSW_SUM | Number of context switches caused by voluntary yields. |
SYKN_PRIORITY_CHANGED_HIGH_SUM | Number of times the priority changes to high priority. |
SYKN_PRIORITY_CHANGED_LOW_SUM | Number of times the priority changes to low priority. |
SYKN_PRIORITY_CHANGED_MED_SUM | Number of times the priority changes to medium priority. |
SYKN_PRIORITY_HIGH_SLICES_SUM | Number of times a user task in high priority exceeded the time allotted for execution. |
SYKN_PRIORITY_LOW_SLICES_SUM | Number of times a user task in low priority exceeded the time allotted for execution. |
SYKN_PRIORITY_MED_SLICES_SUM | Number of times a user task with medium priority exceeded the time allotted for execution. |
SYKN_GINEMASK_CALLS_SUM | Number of time a user changed the engine group binding of any user task. |
SYKN_OUTSTANDING_AIOS_SUM | Maximum number of I/Os pending in the server. |
SYKN_UDALLOC_SLEEPS_SUM | Number of I/Os delayed by reaching the limit of disk I/O structures. |
SYKN_UDALLOC_CALLS_SUM | Number of times that ASE requested disk I/Os. |
SYKN_KSALLOC_CALLS_SUM | Total number of packets received and sent. |
SYKN_KSALLOC_SLEEPS_SUM | Total number of times the network I/O was delayed. |
SYKN_NET_CHECK_BLOCKING_SUM | Number of times ASE performed blocking network checks. |
SYKN_NET_CHECK_NONBLOCKING_SUM | Number of times ASE performed non-blocking network checks. |
SYKN_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDI_DISK_IO_T
Contains overtime counter values. Includes counters that are relevant to Disk I/O statistics.
Info |
---|
|
Column Name | Column Description |
---|---|
SYDI_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDI_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are GMT. On all other summary levels, the time is zeroed. |
SYDI_PWHG_ID | Hour group ID. |
SYDI_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDI_COUNTER_INSTANCE | The Instance of this counter. |
SYDI_P_MISSES_SUM | Number of misses in the disk cache. |
SYDI_P_HITS_SUM | Number of hits in the disk cache. |
SYDI_TOTAL_READS_SUM | Number of pages read from the device. |
SYDI_TOTAL_WRITES_SUM | Number of pages written to the device. |
SYDI_APF_PHYSICAL_READS_SUM | Number of pages read from the device by an asynchronous prefetch. |
SYDI_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYWI_WAIT_INFO
Contains wait event counters info.
Column Name | Column Description |
---|---|
SYWI_WAIT_GROUP | Normalized, wait group names. |
SYWI_WAIT_TYPE | Wait type identifier. |
SYWI_GROUP_FROM_VERSION | Group from - based on Sybase version. |
SYWI_GROUP_TILL_VERSION | Group till - based on Sybase version. |
SYWI_COUNTER_FROM_VERSION | Counter from - based on Sybase version. |
SYWI_COUNTER_TILL_VERSION | Counter till - based on Sybase version. |
SYWI_EXPLANATION | Counter explanation. |
PW_SYWC_WAIT_COUNTERS_T
Contains wait counter data.
Column Name | Column Name |
---|---|
SYWC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWC_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 |
SYWC_PWHG_ID | Hour group ID. |
SYWC_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWC_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWC_WAIT_TYPE | Wait type ID. |
SYWC_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWC_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYWG_WAIT_GROUPS_T
Contains wait counter data group by wait groups.
Column Name | Column Name |
---|---|
SYWG_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWG_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 |
SYWG_PWHG_ID | Hour group ID. |
SYWG_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWG_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWG_WAIT_GROUP | Wait group ID. |
SYWG_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWG_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYRA_REP_AGENT_STATS_T
Column Name | Column Name |
---|---|
SYRA_PWII_INSTANCE_ID | Adaptive Server Enterprise instance name. |
SYRA_REP_SERVER_ID | Replication server name. |
SYRA_DATABASE_ID | Database name. |
SYRA_TIMESTAMP | Timestamp. |
SYRA_PWHG_ID | Hour group ID. |
SYRA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYRA_RECEIVED_TIMESTAMP | Received timestamp. |
SYRA_SUM_IO_WAIT_SUM | Time that the RepAgent waited for the replication server to parse the LTL, normalize the LTL according to the replication definitions, pack the LTL into a binary format, and then send to the SQM. |
SYRA_TRUNCPT_MOVED_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and moved the secondary truncation point in the log. |
SYRA_TRUNCPT_GOTTEN_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and got it. |
SYRA_PACKETS_SENT_SUM | Total number of packets sent. |
SYRA_FULL_PACKETS_SENT_SUM | Number of packets that were sent full. |
SYRA_LOG_RECORDS_SCANNED_SUM | Number of log records scanned. |
SYRA_LOG_RECORDS_PROCESSED_SUM | Number of log records scanned, converted to LTL, and then sent to the replication server. |
SYRA_XCMDTEXT_PROCESSED_SUM | Number of DML commands read from the log. |
SYRA_XWRTEXT_PROCESSED_SUM | Number of writetext operations that are being replicated. |
SYRA_XROWIMAGE_PROCESSED_SUM | Number of row images that are processed. |
SYRA_ROWID | Row ID. |