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