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. |
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. |
PW_SYWC_WAIT_COUNTERS_T
Contains wait counter data.
Column Name | Column Name |
---|---|
SYWC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWC_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 |
SYWC_PWHG_ID | Hour group ID. |
SYWC_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWC_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWC_WAIT_TYPE | Wait type ID. |
SYWC_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWC_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYWG_WAIT_GROUPS_T
Contains wait counter data group by wait groups.
Column Name | Column Name |
---|---|
SYWG_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWG_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 |
SYWG_PWHG_ID | Hour group ID. |
SYWG_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWG_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWG_WAIT_GROUP | Wait group ID. |
SYWG_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWG_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYRA_REP_AGENT_STATS_T
Column Name | Column Name |
---|---|
SYRA_PWII_INSTANCE_ID | Adaptive Server Enterprise instance name. |
SYRA_REP_SERVER_ID | Replication server name. |
SYRA_DATABASE_ID | Database name. |
SYRA_TIMESTAMP | Timestamp. |
SYRA_PWHG_ID | Hour group ID. |
SYRA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYRA_RECEIVED_TIMESTAMP | Received timestamp. |
SYRA_SUM_IO_WAIT_SUM | Time that the RepAgent waited for the replication server to parse the LTL, normalize the LTL according to the replication definitions, pack the LTL into a binary format, and then send to the SQM. |
SYRA_TRUNCPT_MOVED_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and moved the secondary truncation point in the log. |
SYRA_TRUNCPT_GOTTEN_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and got it. |
SYRA_PACKETS_SENT_SUM | Total number of packets sent. |
SYRA_FULL_PACKETS_SENT_SUM | Number of packets that were sent full. |
SYRA_LOG_RECORDS_SCANNED_SUM | Number of log records scanned. |
SYRA_LOG_RECORDS_PROCESSED_SUM | Number of log records scanned, converted to LTL, and then sent to the replication server. |
SYRA_XCMDTEXT_PROCESSED_SUM | Number of DML commands read from the log. |
SYRA_XWRTEXT_PROCESSED_SUM | Number of writetext operations that are being replicated. |
SYRA_XROWIMAGE_PROCESSED_SUM | Number of row images that are processed. |
SYRA_ROWID | Row ID. |