Precise for Sybase tables

ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column.

Name of the instance.

Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).

Name of the server on which the instance is installed.

ID of the counter instance.

Group that includes the counter.

Counter name in the sysmonitor table.

Counter ID in the sysmonitor table.

ID of the Sybase instance.

Name of the database, normalized in table PW_SYDN_DATABASE_NAMES_N.

ID of the database in Sybase.

ID of the table.

The full object ID, normalized in table PW_SYKN_LOCKED_OBJECT_NAMES_N.

ID of the index.

Date and time the statistic was sampled.

On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed.

Hour group ID.

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

Size in Megabytes allocated to the object.

Size in Megabytes used by the object.

Size in Megabytes allocated to text pages of the object.

Size in Megabytes used for text pages of the object.

Size of data pages in Megabytes used by the objects.

Size in Megabytes allocated to the indexes of the object.

Size in Megabytes used by the indexes of the object.

Number of rows the table has.

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

ID of the Sybase instance.

ID of the device, normalized in table PW_SYEN_DEVICE_NAMES_N.

Date the statistic was sampled.

The time part is zeroed because the data is collected once a day.

Hour group ID.

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

Maximum device size in Megabytes.

Maximum space used in Megabytes.

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

ID of the Sybase instance.

ID of the database, normalized in table PW_SYDN_DATABASE_NAMES_N.

ID of the database in Sybase.

ID of the device, normalized in table PW_SYEN_DEVICE_NAMES_N.

Segment type:

• 3 = Data only (system and default segments)
• 4 = Log only
• 7 = Data and log

Date the statistic was sampled.

The time part is zeroed because the data is collected once a day.

Hour group ID.

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

Maximum segment size in Megabytes.

Maximum free space size in Megabytes.

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

ID of the Sybase instance.

Name of the cabinet in which the statement is stored.

Name of the folder within the cabinet.

Unique identifier (string) assigned to the statement.

Unique identifier (number) assigned to statements inserted in the statement workshop workspace.

Statements loaded into the PMDB have the value 0.

ID of the Sybase instance.

Name of the database to which the statement belongs.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to statements inserted in the SQL workspace.

Statements loaded into the PMDB have the value 0.

Date and time the batch was explained and its access plan was changed.

A statement number in the first batch sampled running the statement.

Sequence order of this operation in the access plan for a statement.

Physical operation in the access plan.

Sequence order of this operation in the whole access plan.

Tree level of this operation in the access plan.

Database name of the object accessed in this operation.

Owner of the object accessed in this operation.

Name of the object accessed in this operation.

Alias name of the object accessed in this operation.

Name of the index accessed in this operation. Otherwise NULL.

Additional Information provided for this Explain step.

The optimizer is estimating how many pages will not be available in cache and will need to be read from disk.

Number of logical reads performed on the specified table.

The optimizer is estimating how many pages are likely to be in cache.

Number of rows from the current table that is estimated to satisfy the join.

Number of times we scan the table.

Number of logical reads of sub-query.

Number of physical reads of sub-query.

Indicates if the operation is performed in parallel.

Indicates that this operation belongs to the last explain of the batch.

Estimated cost for the operator in the execution plan

Estimated average width of row returned by the operator

Estimated CPU cost for the operator in the execution plan

Estimated CPU cost for the sub tree starting from the operator

Estimated number of pages accessed by the operator

Indication if prefetch performed by the operator

Estimated I/O size for the operator

Buffer replacement strategy used in the operator

ID of the Sybase instance.

Name of the database to which the statement belongs.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to statements inserted in the SQL workspace.

Statements loaded into the PMDB have the value 0.

Date and time the batch was explained and its access plan was changed.

A statement number in the first batch sampled running the statement.

Unique identifier (number) assigned to the access.

Estimated cost of this operation.

ID of the Sybase instance.

Database to which the statement belongs.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.

Unique identifier (number) assigned to the batch.

Unique identifier (Number) assigned to statements inserted in the SQL workspace.

Statements loaded into the PW have the value 0.

Date and time the batch was explained and its access plan was changed.

The optimizer is estimating how many pages are not available in cache and must be read from disk.

Number of logical reads performed on the specified table.

The optimizer is estimating how many pages are likely to be in the cache.

Number of times we scan the table.

Indicates that this access plan is the last access plan of the batch.

Estimated number of physical reads for the execution plan.

Estimated number of logical reads for the execution plan.

Estimated number of scans for the execution plan.

Estimated CPU cost for the execution plan.

Estimated cost for the execution plan.

ID of the Sybase instance.

Unique identifier (number) assigned to the statement.

Unique identifier (string) assigned to the statement.

Unique identifier (number) assigned to the statement in its collapsed form.

Unique identifier (string) assigned to the statement in its collapsed form.

Date and time the statement was saved in the database.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SYUN_USE_NAMES_N.

Unique identifier (number) assigned to statements inserted in the SQL workspace.

Indicates how the statement was loaded. Possible values:

• PMDB. Sampled and loaded by the Collector
• Manually. Entered through the statement workshop (SQL workspace).
• Saved automatically. Explained from the Current workspace or Activity workspace.

Last time the statement was explained.

Not in use.

Indicates an error during the explain of the statement (if Y, do not try to re-explain).

Error that occurred during the last explain process.

Last time the access plan of the statement changed.

Unique identifier (number) assigned to the access plan of the statement.

Estimated cost of the statement's execution. A high cost value may indicate a problem in the current implementation of the statement.

To determine which operation may have caused the problem, you can use the Estimated Cost Breakdown graph to drill-down easily and see the most resource-consuming operation.

To determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both), check the Estimated I/O cost and Estimated CPU cost values.

Name of the database to which the statement belongs.

ID of the database, in which the statement belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

Unique identifier (number) assigned to the batch. Only the first batch appears.

Unique identifier (number) assigned to the batch. Only the first batch appears.

The offset of the statement in the first batch sampled, running the statement by the Collector agent.

Length of the statement in the first batch sampled running the statement.

Statement number in the first batch sampled running the statement.

Execution order the statement started with in the access plan of the batch.

ID representing the type of the statement:

Type code = Type name

• 0 = alter
• 1 = begin
• 2 = beginTran
• 3 = break
• 4 = call
• 5 = checkpoint
• 6 = close
• 7 = commit
• 8 = continue
• 9 = create

• 10 = dbcc

• 11 = deallocate

• 12 = declare

• 13 = delete

• 14 = deny

• 15 = disk

• 16 = drop

• 17 = dump

• 18 = else

• 19 = end

• 20 = exec

• 21 = execute

• 22 = fetch

• 23 = go

• 24 = goto

• 25 = grant

• 26 = if

• 27 = insert

• 28 = kill

• 29 = load

• 30 = lock

• 31 = online

• 32 = open

• 33 = print

• 34 = quiesce

• 35 = raiserror

• 36 = readtext

• 37 = reconfigure

• 38 = remove

• 39 = reorg

• 40 = restore

• 41 = return

• 42 = reverse

• 43 = rollback

• 44 = save

• 45 = select

• 46 = set

• 47 = setuser

• 48 = shutdown

• 49 = truncate

• 50 = update

• 51 = updatetext

• 52 = use

• 53 = waitfor

• 54 = while

• 55 = writetext

Internal bit representative of the types of operators in the execution plan.

ID of the Sybase instance

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to the batch in its collapsed form.

One of the Sybase users who executed this batch.

If this batch is a stored procedure, this is the user used as the parsing user when explaining this batch.

One of the Sybase users who executed this batch.

If this batch is a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SYUN_USER_NAMES_N.

Name of the database to which the batch belongs.

The ID of the database, to which the batch belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

Unique identifier (string) assigned to the batch.

Unique identifier (string) assigned to the batch in its collapsed form.

Last time the statement was explained.

Indicates an error during the explain of the statement (if Y, do not try to re-explain).

Error that occurred during the last explain process.

Last time the access plan of the batch changed.

Unique identifier (number) assigned to the access plan.

Estimated cost of the statement's execution. A high cost value may indicate a problem in the current implementation of the statement.

To determine which operation may have caused the problem, you can use the Estimated Cost Breakdown graph to drill-down easily and see the most resource-consuming operation.

To determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both), check the Estimated I/O cost and Estimated CPU cost values.

ID of the database that holds the stored procedure.

ID of the stored procedure.

Internal bit representative of the types of the operators in the execution plan.

Only in the data migration process to update several columns and distinguish between new batches and previous batches.

Used for correlation between all the other products and Precise for Sybase

ID of the Sybase instance.

Used to share text of statements and batches between instances.

Server on which the Collector agent is installed.

Name of the monitored Sybase instance.

Last date the explain process run.

Last date the instance performance was loaded.

Last date the statement text was loaded.

For future use.

For future use.

For future use.

For future use.

For future use.

User defined instance group name. Can be updated by using stored procedure udp_sy_update_instance_type.

The status of the Collect Instance Statistics process for each instance.

For future use.

For future use.

For future use.

Last time the Collect Instance Statistics process was run for each instance.

String representation of the instance's ASE version.

Indicates whether the instance is a replication publisher.

Indicates whether the instance is a replication subscriber.

Name of the Sybase group that includes the counter.

Counter name in Sybase (monitor table).

Name of the table in Precise that stores the overtime counter values.

Name of the column in the Precise table that stores the overtime counter values.

The Sybase version that starts collecting the current counter.

The Sybase version that versions later than it stops collecting the current counter.

Counter name as it appears in the GUI.

Counter value's format (number, byte, and so on).

Precise group that includes the counter (as it appears in the GUI).

Marks if the counter is part of a specific instance (such as engine, data cache, and so on).

Counter's explanation.

Marks if to include a transactions graph in the GUI next to the counter graph.

Unique identifier (number) assigned to the batch.

The text of the batch.

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

Hour group ID.

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

Database to which the statement belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SYUDN_USER_NAMES_N.

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to the statement.

Unique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form).

Unique identifier (number) assigned to the statement in its collapsed form.

Indicates the total amount of time Sybase was actively executing queries. It is also the sum of the columns.

Number of statement executions which ended during the row's timeframe.

Number of statement executions which were still running at the end of the row's timeframe

Total amount of time Sybase spent executing this statement.

Not in use in this table.

Amount of time the process was actively executing a statement.

Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.

Amount of time the process was waiting for I/O operations to terminate.

Amount of time the process was waiting for a remote query to terminate.

Amount of time the process was waiting for an operation on the log file to terminate.

This state is generally encountered during a COMMIT or ROLLBACK operation.

Amount of time the process was waiting to synchronize with another process.

The amount of time the process was waiting for an operation of the log file to terminate.

This state is generally encountered during a transaction log full.

Amount of time the process was waiting for the client process to acknowledge data sent to it.

Amount of time the process was waiting to access a user log cache.

Amount of time the process was waiting for an internal lock to be released.

Amount of time the process was executing the WAITFOR DELAY command.

Amount of time the process was waiting for unknown reasons.

Statistics summing the amount of the process’s read memory usage.

Number of physical disk reads and writes for the process.

Number of pages in the procedure cache allocated to the process.

Number of transactions the process opened.

For future use.

For future use.

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

For future use.

For future use.

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

Hour group ID.

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

ID of the database to which the statement belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SYUN_USER_NAMES_N.

The name used to log in to the database.

In case of Windows Authentication mode, it contains the domain and the Windows user name, normalized in table PW_SYLN_LOGIN_NAMES_N.

The ID of the client workstation, normalized in table PW_SYMN_MACHINE_NAMES_N.

Type of session, such as batch, dialog, queue. Used only in ERP components.

Total amount of time Sybase was actively executing queries. It is also the sum of the columns.

Total amount of time Sybase spent executing this session.

Amount of time the process was waiting for the client to issue a statement.

Amount of time the process was actively executing a statement.

Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.

Amount of time the process was waiting for I/O operations to terminate.

Amount of time the process was waiting for remote query to terminate.

Amount of time the process was waiting on an operation on the log file to terminate.

This state is generally encountered during a COMMIT or ROLLBACK operation.

Amount of time the process was waiting to synchronize with another process.

The amount of time the process was waiting for an operation of the log file to terminate.

This state is generally encountered during a transaction log full.

Amount of time the process was waiting for the client process to acknowledge data sent to it.

Amount of time the process was waiting to access a user log cache.

Amount of time the process was waiting for an internal lock to be released.

Amount of time the process was executing the WAITFOR DELAY command.

Amount of time the process was waiting for unknown reasons.

Number of sessions, which ended during the row's timeframe.

Number of sessions, which were still open at the end of the row's timeframe.

Number of statement executions, which ended during the row's timeframe.

Number of statement executions, which were still running at the end of the row's timeframe.

Statistics summing the amount of the process' read memory usage.

Number of physical disk reads and writes for the process.

Number of pages in the procedure cache allocated to the process.

Number of transactions the process opened.

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

For future use.

For future use.

For future use.

Unique row number.

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

Hour group ID.

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

ID of the database to which the statement belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

One of the Sybase users who executed this statement.

If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table PW_SYUN_USER_NAMES_N.

The name used to log in to the database.

In case of Windows Authentication mode, it contains the domain and the Windows user name, normalized in table PW_SYLN_LOGIN_NAMES_N.

The ID of the client workstation, normalized in table PW_SYMN_MACHINE_NAMES_N.

Type of session, such as batch, dialog, queue. Used only in ERP components.

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to the statement.

Unique identifier (number) assigned to the batch.

Unique identifier (number) assigned to the batch in its collapsed form.

Total amount of time Sybase was actively executing queries. It is also the sum of the columns.

Total amount of time Sybase spent executing this statement.

Amount of time the process was waiting for the client to issue a statement.

Amount of time the process was actively executing a statement.

Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.

Amount of time the process was waiting for I/O operations to terminate.

Amount of time the process was waiting for a remote query to terminate.

Amount of time the process was waiting for an operation on the log file to terminate.

This state is generally encountered during a COMMIT or ROLLBACK operation.

Amount of time the process was waiting to synchronize with another process.

The amount of time the process was waiting for an operation of the log file to terminate.

This state is generally encountered during a transaction log full.

Amount of time the process was waiting for the client process to acknowledge data sent to it.

Amount of time the process was waiting to access a user log cache.

Amount of time the process was waiting for an internal lock to be released.

Amount of time the process was executing the WAITFOR DELAY command.

Amount of time the process was waiting for unknown reasons.

Number of sessions, which ended during the row's timeframe.

Number of statement executions, which ended during the row's timeframe.

Number of statement executions, which ended during the row's timeframe.

Number of statement executions, which were still running at the end of the row's timeframe.

Statistics summing the amount of the process’s read memory usage.

Number of physical disk reads and writes for the process.

Number of pages in the procedure cache allocated to the process.

Number of transactions the process opened.

Minimum number of sessions executing this statement in parallel.

Maximum number of sessions executing this statement in parallel.

For future use.

For future use.

For future use.

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

Unique row number.

For future use.

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

Hour group ID.

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

ID of the database to which the statement belongs, normalized in table PW_SYDN_DATABASE_NAMES_N.

Total amount of time Sybase was actively executing queries. It is also the sum of the columns.

Total amount of time Sybase spent executing this statement.

Amount of time the process was waiting for the client to issue a statement.

Amount of time the process was actively executing a statement.

Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.

Amount of time the process was waiting for I/O operations to terminate.

Amount of time the process was waiting for a remote query to terminate.

Amount of time the process was waiting for an operation on the log file to terminate.

This state is generally encountered during a COMMIT or ROLLBACK operation.

Amount of time the process was waiting to synchronize with another process.

The amount of time the process was waiting for an operation of the log file to terminate.

This state is generally encountered during a transaction log full.

Amount of time the process was waiting for the client process to acknowledge data sent to it.

Amount of time the process was waiting to access a user log cache.

Amount of time the process was waiting for an internal lock to be released.

Amount of time the process was executing the WAITFOR DELAY command.

Amount of time the process was waiting for unknown reasons.

Number of sessions, which ended during the row's timeframe.

Number of statement executions, which ended during the row's timeframe.

Number of statement executions, which ended during the row's timeframe.

Number of statement executions, which were still running at the end of the row's timeframe.

Statistics summing the amount of the process’s read memory usage.

Number of physical disk reads and writes for the process.

Number of pages in the procedure cache allocated to the process.

Number of transactions the process opened.

For future use.

For future use.

For future use.

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

Unique row number.

Type of session, such as batch, dialog, or queue.

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.