Page History
...
Info |
---|
|
Column Name | Column Description |
---|---|
SYDC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDC_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. |
SYDC_PWHG_ID | Hour group ID. |
SYDC_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDC_COUNTER_INSTANCE | The Instance of this counter. |
SYDC_READ_WAITS_SUM | Number of cache search misses resulting in a read. |
SYDC_SYSTEM_DISK_WRITES_SUM | Number of I/O waits caused by I/O requests or restarted I/O requests. |
SYDC_HK_EXECUTIONS_SUM | Number of times the housekeeper executes on a cache. |
SYDC_IO_PACING_SUM | Number of times an I/O extensive task was switched off, due to exceeding an I/O batch limit. |
SYDC_CNTXSW_GROUP_COMMIT_SUM | Number of times a task issued a commit and had to wait till the buffer log got full and was written to disk. |
SYDC_LOG_LASTPAGE_WRITES_SUM | Number of times a task issued a commit and had to wait till the buffer log was written to disk. |
SYDC_CNTXSW_MODIFY_CNFLCT_SUM | Number of times a task issued a commit and had to wait till the buffer log was written to disk. |
SYDC_HK_WASH_SUM | Number of time the housekeeper tasks perform buffer cache washes. |
SYDC_HK_WASH_CLEAN_SUM | Number of time the housekeeper tasks perform buffer cache washes and found it clean. |
SYDC_LOG_PAGE_WRITES_SUM | Number of times a buffer transaction log page is written to disk. |
SYDC_BUFSEARCH_FINDS_SUM | Number of times a needed page was found in a cache. |
SYDC_BUFSEARCH_FINDS_IN_SUM | Number of times a needed page was found in a cache in the wash mark. |
SYDC_BUFSEARCH_CALLS_SUM | Number of times a cache was searched for a specific page. |
SYDC_LRU_BUFGRAB_2K_SUM | Number of times a buffer is replaced from the pool with I/O size 2K. The page that was replaced, was not changed or was already written to disk, known as clean. |
SYDC_LRU_BUFGRAB_4K_SUM | Number of times a buffer is replaced from the pool with I/O size 4K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_8K_SUM | Number of times a buffer is replaced from the pool with I/O size 8K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_16K_SUM | Number of times a buffer is replaced from the pool with I/O size 16K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_32K_SUM | Number of times a buffer is replaced from the pool with I/O size 32K. The page that was replaced was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_64K_SUM | Number of times a buffer is replaced from the pool with I/O size 64K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_128K_SUM | Number of times a buffer is replaced from the pool with I/O size 128K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_256K_SUM | Number of times a buffer is replaced from the pool with I/O size 256K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_LRU_BUFGRAB_512K_SUM | Number of times a buffer is replaced from the pool with I/O size 512K. The page that was replaced, was not changed or was already written to disk, known as clean page. |
SYDC_BUFGRAB_DIRTY_2K_SUM | Number of times a buffer is replaced from the pool with I/O size 2K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_4K_SUM | Number of times a buffer is replaced from the pool with I/O size 4K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_8K_SUM | Number of times a buffer is replaced from the pool with I/O size 8K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_16K_SUM | Number of times a buffer is replaced from the pool with I/O size 16K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_32K_SUM | Number of times a buffer is replaced from the pool with I/O size 32K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_64K_SUM | Number of times a buffer is replaced from the pool with I/O size 64K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_128K_SUM | Number of times a buffer is replaced from the pool with I/O size 128K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_256K_SUM | Number of times a buffer is replaced from the pool with I/O size 256K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFGRAB_DIRTY_512K_SUM | Number of times a buffer is replaced from the pool with I/O size 512K. The page that was replaced, was changed and not written to disk, known as dirty page. |
SYDC_BUFUNKEEP_LRU_SUM | Number of buffers that used the normal cache strategy and were placed at the MRU end of the cache. |
SYDC_BUFUNKEEP_MRU_SUM | Number of buffers that were placed at the wash marker, using the fetch-and-discard strategy. |
SYDC_LARGE_IO_PERFORMED_SUM | Number of times a request for a large I/O was performed for a buffer. |
SYDC_PREFETCH_REQ_SUM | Number of times a large I/O was requested for a buffer. |
SYDC_LEVEL0_BUFPREDIRTY_SUM | Average number of pages requested at isolation level 0 for a cache. |
SYDC_BUFWASH_THROUPUT_SUM | Throughput of the buffer wash mark. |
SYDC_BUFWASH_PASS_CLEAN_SUM | Number of buffers that were clean, when they passed the wash marker. |
SYDC_BUFWASH_PASS_WRITE_SUM | Number of times that I/O was already active on a buffer, when it entered the wash area. |
SYDC_BUFWASH_WRITE_DIRTY_SUM | Number of times that a buffer entered the wash area dirty and was not already in I/O. |
SYDC_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYIM_INDEX_MANAGEMENTS_T
Contains overtime counter values. Includes counters that are relevant to Index Management statistics.
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. |