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