Page History
...
Info |
---|
|
Column Name | Column Description |
---|---|
SYIM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYIM_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. |
SYIM_PWHG_ID | Hour group ID. |
SYIM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYIM_NC_UPDATES_SUM | Number of insert and update operations to a table with indexes that potentially requires modifications to one or more indexes. |
SYIM_NC_UPDATES_INDEXES_SUM | Number of non-clustered indexes that require maintenance, as a result of insert and update operations. |
SYIM_NC_DELETES_SUM | Number of delete operations to a table with indexes that potentially required modifications to one or more indexes. |
SYIM_NC_DELETE_INDEXES_SUM | Number of non-clustered indexes that required maintenance, as a result of delete operations. |
SYIM_NC_RID_UPDATES_SUM | Number of page splits that required maintenance of a non-clustered index. |
SYIM_NC_RID_UPDATE_INDEXES_SUM | Number of non-clustered indexes that required maintenance, as a result of a clustered page split. |
SYIM_NC_DOL_NC_DELETES_SUM | Number of update / delete operations for DOL tables that required maintenance of a non-clustered index. |
SYIM_NC_DOL_NC_DELETES_INDEX_SUM | Number of non-clustered indexes that required maintenance, as a result of update / delete operations for DOL tables. |
SYIM_PAGE_SPLITS_SUM | Number of page splits for data pages, clustered index pages or non-clustered index pages, because there was not enough room for a new row. |
SYIM_INDEX_RETRIES_SUM | Number of times the ASE server retried to split a page, due to contention. |
SYIM_ADD_INDEX_LEVEL_SUM | Number of times a new index level was added. |
SYIM_PAGE_SHRINKS_SUM | Number of page shrinks, due to deleting index rows. |
SYIM_BT_BACKWARD_SCANS_SUM | Number of backward scans on DOL tables. |
SYIM_BT_FORWARD_SCANS_SUM | Number of forward scans on DOL tables. |
SYIM_BACKWARD_SCANS_SUM | Number of backward scans on APL tables. |
SYIM_FORWARD_SCANS_SUM | Number of forward scans on APL tables. |
SYIM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYCM_CACHE_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Metadata Cache statistics.
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. |