Page History
...
| Info |
|---|
|
| Column Name | Column Description |
|---|---|
SYTM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYTM_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. |
SYTM_PWHG_ID | Hour group ID. |
SYTM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYTM_LOG_SEMAPHORE_WAITED_SUM | Number of context switches, caused by contention on a log semaphore. |
SYTM_ULC_SEMAPHORE_WAITS_SUM | Number of context switches, caused by contention on PLC. |
SYTM_TRANSACTIONS_SUM | Number of committed transactions. |
SYTM_INS_HEAP_ROWS_SUM | Number of rows inserted to heap tables. |
SYTM_INS_CLUS_ROWS_SUM | Number of rows inserted to clustered tables. |
SYTM_INS_DOL_ROWS_SUM | Number of rows inserted to data-only-lock tables. |
SYTM_UPD_DEFERRED_ROWS_SUM | Number of rows updated in deferred mode. |
SYTM_UPD_DIRECT_PLACE_ROWS_SUM | Number of rows updated directly, in-place. |
SYTM_UPD_CHEAP_DIRECT_ROWS_SUM | Number of rows updated directly, not in-place. |
SYTM_UPD_EXPENSIVE_ROWS_SUM | Number of rows updated directly, expansive (causing row movement). |
SYTM_UPD_DOL_DEFERRED_ROWS_SUM | Number of rows updated in deferred mode in DOL tables. |
SYTM_UPD_DOL_ROWS_SUM | Number of rows updated in DOL tables. |
SYTM_UPD_DOL_REPLACE_ROWS_SUM | Number of rows replaced in DOL tables. |
SYTM_UPD_DOL_SHRINK_ROWS_SUM | Number of rows shrunken, while updated in DOL tables. |
SYTM_DOL_CHEAP_EXPANDS_SUM | Number of rows expanded, while updated in DOL tables. The row was the last row on the page. |
SYTM_DOL_EXPENSIVE_EXPANDS_SUM | Number of rows expanded, while updated in DOL tables. The update caused row movement. |
SYTM_DOL_EXPANDS_FORWARDS_SUM | Number of rows expanded and forwarded, while updated in DOL tables. |
SYTM_DOL_FORWARDS_RET_ROWS_SUM | Number of rows that were forwarded already and now fit in original page and returned to original page in DOL tables. |
SYTM_DEL_DEFERRED_ROWS_SUM | Number of rows deleted in deferred mode. |
SYTM_DEL_APL_ROWS_SUM | Number of rows deleted directly. |
SYTM_DEL_DOL_ROWS_SUM | Number of rows deleted from DOL tables. |
SYTM_FULL_LOG_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because the ULC became full. |
SYTM_ENDXACT_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a transaction ended. |
SYTM_CHANGE_DB_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a database changed. |
SYTM_SYS_LOG_REC_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because a system transaction occurred within the user transaction. |
SYTM_UNPIN_FLUSHES_SUM | Number of times that ULC was flushed to transaction log because of other reasons. |
SYTM_LOG_RECORDS_SUM | Average number of log records per transaction. |
SYTM_ULC_SIZE_MAX | Maximum number of bytes used in ULCs. |
SYTM_LOG_SEMAPHORE_GRANTED_SUM | Number of log semaphore requests granted immediately. |
SYTM_ULC_SEMAPHORE_REQ_SUM | Number of ULC semaphore requests. |
SYTM_TRAN_LOG_ALLOC_SUM | Number of times additional pages were allocated to the transaction log. |
SYTM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDC_DATA_CACHE_MANAGEMENT_T
Contains overtime counter values. Includes counters that are relevant to Data Cache statistics.
| 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. |