Page History
...
| 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. |