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 an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and |
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 an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and |
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. |