Page History
...
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 |
SYST_PWHG_ID
should be used. | |
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
...
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 |
SYST_PWHG_ID
should be used. | |
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_ | |