Page History

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

The Instance of this counter.

Number of cache search misses resulting in a read.

Number of I/O waits caused by I/O requests or restarted I/O requests.

Number of times the housekeeper executes on a cache.

Number of times an I/O extensive task was switched off, due to exceeding an I/O batch limit.

Number of times a task issued a commit and had to wait till the buffer log got full and was written to disk.

Number of times a task issued a commit and had to wait till the buffer log was written to disk.

Number of times a task issued a commit and had to wait till the buffer log was written to disk.

Number of time the housekeeper tasks perform buffer cache washes.

Number of time the housekeeper tasks perform buffer cache washes and found it clean.

Number of times a buffer transaction log page is written to disk.

Number of times a needed page was found in a cache.

Number of times a needed page was found in a cache in the wash mark.

Number of times a cache was searched for a specific page.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Number of buffers that used the normal cache strategy and were placed at the MRU end of the cache.

Number of buffers that were placed at the wash marker, using the fetch-and-discard strategy.

Number of times a request for a large I/O was performed for a buffer.

Number of times a large I/O was requested for a buffer.

Average number of pages requested at isolation level 0 for a cache.

Throughput of the buffer wash mark.

Number of buffers that were clean, when they passed the wash marker.

Number of times that I/O was already active on a buffer, when it entered the wash area.

Number of times that a buffer entered the wash area dirty and was not already in I/O.

Local date and time the row was loaded into the PMDB.

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

Number of insert and update operations to a table with indexes that potentially requires modifications to one or more indexes.

Number of non-clustered indexes that require maintenance, as a result of insert and update operations.

Number of delete operations to a table with indexes that potentially required modifications to one or more indexes.

Number of non-clustered indexes that required maintenance, as a result of delete operations.

Number of page splits that required maintenance of a non-clustered index.

Number of non-clustered indexes that required maintenance, as a result of a clustered page split.

Number of update / delete operations for DOL tables that required maintenance of a non-clustered index.

Number of non-clustered indexes that required maintenance, as a result of update / delete operations for DOL tables.

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.

Number of times the ASE server retried to split a page, due to contention.

Number of times a new index level was added.

Number of page shrinks, due to deleting index rows.

Number of backward scans on DOL tables.

Number of forward scans on DOL tables.

Number of backward scans on APL tables.

Number of forward scans on APL tables.

Local date and time the row was loaded into the PMDB.

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

Number of objects that were active.

Maximum number of objects that were active (from server reboot).

Number of times the objects cache had to be searched for reusable descriptors and all descriptors were in use.

Number of times the objects cache had to be searched for reusable descriptors.

Number of indexes that were active.

Maximum number of indexes that were active (from server reboot).

Number of times the indexes cache had to be searched for reusable descriptors and all descriptors were in use.

Number of times the indexes cache had to be searched for reusable descriptors.

Number of databases that were active.

Maximum number of databases that were active (from server reboot).

Number of times the databases cache had to be searched for reusable descriptors and all descriptors were in use.

Number of times the databases cache had to be searched for reusable descriptors.

Local date and time the row was loaded into the PMDB.

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

Instance of this counter.

Number of clock ticks an engine got from the operating system.

Number of clock ticks an engine was idle.

Number of times an engine yielded (gave up) to the operating system.

Number of times an engine checks for disk I/O.

Number of times an I/O request was completed, when an engine checked for disk I/O.

Number of completed I/O requests.

Number of delayed I/O requests, due to engine limit.

Number of delayed I/O requests, due to an OS limit.

Number of delayed I/O requests, due to a server limit.

Number of times an engine switches context from one user task to another.

Number of times an engine skipped a user task at the head of a run queue.

Maximum number of pending I/Os.

Number of bytes an engine received from the network.

Number of bytes an engine sent to the network.

Number of packets an engine received from the network.

Number of packets an engine sent to the network.

Local date and time the row was loaded into the PMDB.

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

Total number of requests for a worker process.

Number of denied worker process requests.

Number of worker process requests terminated by the user.

Total number of worker processes used.

Maximum number of worker processes used.

Number of requests for memory allocation for worker processes.

Number of failed requests for memory allocation for worker processes.

Total memory used by a worker process.

Summary of opened connections.

Number of maximum opened connections.

Number of context switches caused by voluntary yields.

Number of times the priority changes to high priority.

Number of times the priority changes to low priority.

Number of times the priority changes to medium priority.

Number of times a user task in high priority exceeded the time allotted for execution.

Number of times a user task in low priority exceeded the time allotted for execution.

Number of times a user task with medium priority exceeded the time allotted for execution.

Number of time a user changed the engine group binding of any user task.

Maximum number of I/Os pending in the server.

Number of I/Os delayed by reaching the limit of disk I/O structures.

Number of times that ASE requested disk I/Os.

Total number of packets received and sent.

Total number of times the network I/O was delayed.

Number of times ASE performed blocking network checks.

Number of times ASE performed non-blocking network checks.

Local date and time the row was loaded into the PMDB.

ID of the Sybase instance.

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.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

The Instance of this counter.

Number of misses in the disk cache.

Number of hits in the disk cache.

Number of pages read from the device.

Number of pages written to the device.

Number of pages read from the device by an asynchronous prefetch.

Local date and time the row was loaded into the PMDB.

Normalized, wait group names.

Wait type identifier.

Group from - based on Sybase version.

Group till - based on Sybase version.

Counter from - based on Sybase version.

Counter till - based on Sybase version.

Counter explanation.

ID of the Sybase instance.

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 SQAM_PWHG_ID should be used.

Hour group ID.

The timeframe needed to calculated the row (in minutes).

Local date and time the row was loaded into the PMDB.

Wait type ID.

Wait event's counter.

Summarized wait event's total wait time.