Page History

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.