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).

Total number of queries eligible to be run in parallel.

Number of times the number of worker processes for a cached query plan was adjusted, due to a session-level limit.

Number of times the number of worker processes for a cached query plan was adjusted, due to lack of available worker processes.

Number of parallel network buffer merge locks with no wait.

Number of parallel network buffer merge locks with wait.

Number of parallel result buffer merge locks with no wait.

Number of parallel result buffer merge locks with wait.

Number of parallel work table merge locks with no wait.

Number of parallel work table merge locks with wait.

Number of contention on a parallel sort buffer merge locks that are caused by producers (returning rows from parallel scans).

Number of contention on a parallel sort buffer merge locks that are caused by consumers (performing the parallel sort).

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 extended stored procedure calls.

Average time for all extended stored procedures.

Number of times the housekeeper garbage collection checked for space that can be reclaimed.

Number of pages reclaimed by the housekeeper garbage collection.

Number of times the housekeeper chore tasks checked to see if statistics needed to be written.

Number of times that a process attempting to use sp_showplan had to wait to acquire read access to the query plan.

Number of times that SQL batch text exceeded the text buffer size.

Maximum size of a SQL batch.

Number of times that stored procedures were read from disk, rather than found and copied in the procedure cache.

Number of times that a procedure aged out of cache.

Number of times stored procedures were executed.

Number of procedures created.

Number of times that a new page was allocated in the memory.

Number of times that a page was freed.

Number of normal checkpoints.

Number of checkpoints performed by the housekeeper wash task.

Interval of normal checkpoints.

Interval of free checkpoints.

Number of network packets ASE received.

Number of network packets ASE sent.

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

Number of times stored procedures were recompiled due to cursor permission change.

Number of times stored procedures were recompiled due to index change.

Number of times stored procedures were recompiled due to isolation level change.

Number of times stored procedures were recompiled due to permissions change.

Number of times stored procedures were recompiled due to schema change.

Number of times stored procedures were recompiled due to table missing.

Number of times stored procedures were recompiled due to temporary table missing.

Number of times recompilation was triggered at compilation phase.

Number of times recompilation was triggered at execution phase.

Number of times recompilation was triggered at execute cursor execution phase.

Number of times recompilation was triggered at redefinition phase.

Number of statements that were dropped instead of cached.

Number of times a query plan was reused.

Number of times an SQL statement was not found in cache.

Number of statements Adaptive Server would have cached if the statement cache were enabled.

Number of SQL statements in cache.

Number of query plans regenerated from the SQL text.

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 times a task was switched out because it needed to wait for an EX latch type.

Number of times a task was switched out because it needed to wait for a NO latch type.

Number of times a task was switched out because it needed to wait for an SH latch type.

Number of times ASE server retried to split a page, due to contention and ended in a deadlock.

Number of times locks were granted immediately.

Number of times a task had to wait for a lock.

Number of times there was lock contention.

Number of deadlocks.

Number of times the lock hash table was searched for a lock on a page, row, or table.

Number of times an exclusive table lock type was granted immediately.

Number of times a task had to wait for an exclusive table lock type.

Number of times a shared table lock type was granted immediately.

Number of times a task had to wait for a shared table lock type.

Number of times an exclusive intent lock type was granted immediately.

Number of times a task had to wait for an exclusive intent lock type.

Number of times a shared intent lock type was granted immediately.

Number of times a task had to wait for a shared Intent lock type.

Number of times an exclusive page lock type was granted immediately.

Number of times a task had to wait for an exclusive page lock type.

Number of times a shared page lock type was granted immediately.

Number of times a task had to wait for a shared page lock type.

Number of times an update page lock type was granted immediately.

Number of times a task had to wait for an update page lock type.

Number of times an exclusive row lock type was granted immediately.

Number of times a task had to wait for an exclusive row lock type.

Number of times a shared row lock type was granted immediately.

Number of times a task had to wait for a shared row lock type.

Number of times an update row lock type was granted immediately.

Number of times a task had to wait for an update row lock type.

Number of times a shared next key lock type was granted immediately.

Number of times a task had to wait for a shared next key lock type.

Number of times an exclusive address lock type was granted immediately.

Number of times a task had to wait for an exclusive address lock type.

Number of times a shared address lock type was granted immediately.

Number of times a task had to wait for a shared address lock type.

Number of times an exclusive table deadlock has occurred.

Number of times a shared table deadlock has occurred.

Number of times an exclusive intent deadlock has occurred.

Number of times a shared intent deadlock has occurred.

Number of times an exclusive page deadlock has occurred.

Number of times an updated page deadlock has occurred.

Number of times a shared page deadlock has occurred.

Number of times an exclusive row deadlock has occurred.

Number of times an updated row deadlock has occurred.

Number of times a shared row deadlock has occurred.

Number of times a shared next key deadlock has occurred.

Number of times an exclusive address deadlock has occurred.

Number of times a shared address deadlock has occurred.

Number of times Adaptive Server initiated a deadlock search.

Number of times a task started to perform deadlock checking, but found deadlock checking in progress and skipped its check.

Number of lock promotions.

Number of times an exclusive page to exclusive table escalation has occurred.

Number of times a shared page to shared table escalation has occurred.

Number of times an exclusive row to exclusive table escalation has occurred.

Number of times a shared row to shared table escalation has occurred.

Number of times a shared next key to shared table escalation has occurred.

Number of times a task was waiting for a lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an exclusive table lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared table lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an exclusive intent lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared intent lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an exclusive page lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an update page lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared page lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an exclusive row lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an update row lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared row lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for an exclusive address lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared address lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

Number of times a task was waiting for a shared next key lock and the transaction was rolled back, due to a session-level or server-level lock timeout.

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

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

For more information, search for "performance counters" on http://msdn.microsoft.com.

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 context switches, caused by contention on PLC.

Number of committed transactions.

Number of rows inserted to heap tables.

Number of rows inserted to clustered tables.

Number of rows inserted to data-only-lock tables.

Number of rows updated in deferred mode.

Number of rows updated directly, in-place.

Number of rows updated directly, not in-place.

Number of rows updated directly, expansive (causing row movement).

Number of rows updated in deferred mode in DOL tables.

Number of rows updated in DOL tables.

Number of rows replaced in DOL tables.

Number of rows shrunken, while updated in DOL tables.

Number of rows expanded, while updated in DOL tables. The row was the last row on the page.

Number of rows expanded, while updated in DOL tables. The update caused row movement.

Number of rows expanded and forwarded, while updated in DOL tables.

Number of rows that were forwarded already and now fit in original page and returned to original page in DOL tables.

Number of rows deleted in deferred mode.

Number of rows deleted directly.

Number of rows deleted from DOL tables.

Number of times that ULC was flushed to transaction log because the ULC became full.

Number of times that ULC was flushed to transaction log because a transaction ended.

Number of times that ULC was flushed to transaction log because a database changed.

Number of times that ULC was flushed to transaction log because a system transaction occurred within the user transaction.

Number of times that ULC was flushed to transaction log because of other reasons.

Average number of log records per transaction.

Maximum number of bytes used in ULCs.

Number of log semaphore requests granted immediately.

Number of ULC semaphore requests.

Number of times additional pages were allocated to the transaction log.

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 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.