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