Page History
...
| Info |
|---|
|
| Column Name | Column Description |
|---|---|
SYCM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYCM_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. |
SYCM_PWHG_ID | Hour group ID. |
SYCM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYCM_ACTIVE_OPEN_OBJECTS_MAX | Number of objects that were active. |
SYCM_OPEN_OBJECTS_MAX | Maximum number of objects that were active (from server reboot). |
SYCM_OPEN_OBJECTS_FAILED_SUM | Number of times the objects cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_OBJECTS_REUSES_SUM | Number of times the objects cache had to be searched for reusable descriptors. |
SYCM_ACTIVE_OPEN_INDEXES_MAX | Number of indexes that were active. |
SYCM_OPEN_INDEXES_MAX | Maximum number of indexes that were active (from server reboot). |
SYCM_OPEN_INDEXES_FAILED_SUM | Number of times the indexes cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_INDEXES_REUSES_SUM | Number of times the indexes cache had to be searched for reusable descriptors. |
SYCM_ACTIVE_OPEN_DATABASES_SUM | Number of databases that were active. |
SYCM_OPEN_DATABASES_MAX | Maximum number of databases that were active (from server reboot). |
SYCM_OPEN_DATABASES_FAILED_SUM | Number of times the databases cache had to be searched for reusable descriptors and all descriptors were in use. |
SYCM_OPEN_DATABASES_REUSES_SUM | Number of times the databases cache had to be searched for reusable descriptors. |
SYCM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYES_ENGINES_T
Contains overtime counter values. Includes counters that are relevant to Engine statistics.
| 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. |