Page History
...
Holds information on batches.
Column Name | Column Description |
---|---|
SYBA_PWII_INSTANCE_ID | ID of the Sybase instance |
SYBA_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYBA_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SYBA_PARSING_USER | 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. |
SYBA_PARSING_USER_ID | 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 |
SYBA_DATABASE_NAME | Name of the database to which the batch belongs. |
SYBA_DATABASE_ID | The ID of the database, to which the batch belongs, normalized in table |
SYBA_BATCH_ID | Unique identifier (string) assigned to the batch. |
SYBA_COLLAPSED_BATCH_ID | Unique identifier (string) assigned to the batch in its collapsed form. |
SYBA_LAST_EXPLAINED | Last time the statement was explained. |
SYBA_DO_NOT_EXPLAIN | Indicates an error during the explain of the statement (if Y, do not try to re-explain). |
SYBA_EXPLAIN_ERROR_MSG | Error that occurred during the last explain process. |
SYBA_LAST_ACC_PATH_CHANGED | Last time the access plan of the batch changed. |
SYBA_ACCESS_PATH_HV | Unique identifier (number) assigned to the access plan. |
SYBA_TOTAL_ESTIMATED_COST | 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. |
SYBA_PROC_DB_ID | ID of the database that holds the stored procedure. |
SYBA_PROC_OBJECT_ID | ID of the stored procedure. |
SYBA_EXPLAIN_USAGE_MAP | Internal bit representative of the types of the operators in the execution plan. |
SYBA_MIGRATED | Only in the data migration process to update several columns and distinguish between new batches and previous batches. |
SYBA_CONSISTENT_HV | Used for correlation between all the other products and Precise for Sybase |
PW_SYIN_INSTANCES
Holds information about the Sybase instances monitored by Precise.
Column Name | Column Description |
---|---|
SYIN_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYIN_CLUSTER_ID | Used to share text of statements and batches between instances. |
SYIN_SYSTEM_NAME | Server on which the Collector agent is installed. |
SYIN_INSTANCE_NAME | Name of the monitored Sybase instance. |
SYIN_LAST_PW_EXPLAIN_DATE | Last date the explain process run. |
SYIN_LAST_PERF_LOAD_DATE | Last date the instance performance was loaded. |
SYIN_LAST_STMT_LOAD_DATE | Last date the statement text was loaded. |
SYIN_DB_FILES_LAST_SAMPLE | For future use. |
SYIN_LAST_AVAIL_LOADED | For future use. |
SYIN_LAST_AVAIL_LOADED_DB | For future use. |
SYIN_UNAVAIL_DB_STATUS | For future use. |
SYIN_POINTS_INSTALLED | For future use. |
SYIN_INSTANCE_TYPE | User defined instance group name. Can be updated by using stored procedure |
SYIN_LAST_STATS_STATUS | The status of the Collect Instance Statistics process for each instance. |
SYIN_JOB_SAMPLE_STATUS | For future use. |
SYIN_SCHEDULE_SAMPLE_STATUS | For future use. |
SYIN_STEP_SAMPLE_STATUS | For future use. |
SYIN_LAST_STATS_LOAD | Last time the Collect Instance Statistics process was run for each instance. |
SYIN_INSTANCE_VERSION | String representation of the instance's ASE version. |
SYIN_IS_PUBLISHER | Indicates whether the instance is a replication publisher. |
SYIN_IS_SUBSCRIBER | Indicates whether the instance is a replication subscriber. |
PW_SYPC_PERFORMANCE_COUNTERS
Lists all the counters and information relevant to them. Correlates counters in the Precise environment to counter/counters in Sybase.
Column Name | Column Description |
---|---|
SYPC_OBJECT_NAME | Name of the Sybase group that includes the counter. |
SYPC_COUNTER_NAME | Counter name in Sybase (monitor table). |
SYPC_TABLE_NAME | Name of the table in Precise that stores the overtime counter values. |
SYPC_COLUMN_NAME | Name of the column in the Precise table that stores the overtime counter values. |
SYPC_FROM_VERSION | The Sybase version that starts collecting the current counter. |
SYPC_TILL_VERSION | The Sybase version that versions later than it stops collecting the current counter. |
SYPC_UI_COUNTER_NAME | Counter name as it appears in the GUI. |
SYPC_UI_FORMAT | Counter value's format (number, byte, and so on). |
SYPC_UI_PERFORMANCE_GROUP | Precise group that includes the counter (as it appears in the GUI). |
SYPC_HAS_INSTANCE | Marks if the counter is part of a specific instance (such as engine, data cache, and so on). |
SYPC_EXPLANATION | Counter's explanation. |
SYPC_XACT_PRESENTATION | Marks if to include a transactions graph in the GUI next to the counter graph. |
PW_SYBX_BATCH_TEXT
Holds the text of batches.
Column Name | Column Description |
---|---|
SYBX_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYBX_BATCH_TEXT | The text of the batch. |
PW_SYST_STATEMENTS_STATS_T
...
Info |
---|
|
Column Name | Column Description |
---|---|
SYST_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYST_TIMESTAMP | 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 | Hour group ID. |
SYST_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYST_DATABASE_ID | Database to which the statement belongs, normalized in table |
SYST_USER_ID | 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 |
SYST_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYST_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SYST_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form). |
SYST_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the statement in its collapsed form. |
SYST_TOTAL_INSYBASE_TIME_SUM | Indicates the total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYST_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions which ended during the row's timeframe. |
SYST_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions which were still running at the end of the row's timeframe |
SYST_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this statement. |
SYST_REQUEST_WAIT_SUM | Not in use in this table. |
SYST_CPU_SUM | Amount of time the process was actively executing a statement. |
SYST_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SYST_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYST_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SYST_LOG_WAIT_SUM | 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. |
SYST_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYST_LOG_SUSPEND_SUM | 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. |
SYST_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYST_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYST_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYST_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYST_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYST_STAT_SPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SYST_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYST_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYST_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SYST_PARALLEL_DEGREE_MIN | For future use. |
SYST_PARALLEL_DEGREE_MAX | For future use. |
SYST_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYST_SLA_RED_SUM | For future use. |
SYST_SLA_YELLOW_SUM | For future use. |
SYST_SLA_GREEN_SUM | For future use. |
SYST_ROWID | Unique row number. |
PW_SYSS_SESSIONS_STATS_T
Stores application performance statistics per timeslice for every combination of instance, database, program, user, login, machine, and work type.
Info |
---|
|
Column Name | Column Description |
---|---|
SYSS_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSS_TIMESTAMP | 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 |
SYSS_PWHG_ID | Hour group ID. |
SYSS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSS_PROGRAM_ID | ID of the application program, normalized in table PW_SYPN_PROGRAM_NAMES_N . |
SYSS_DATABASE_ID | ID of the database to which the statement belongs, normalized in table |
SYSS_USER_ID | 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 |
SYSS_LOGIN_ID | 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 |
SYSS_MACHINE_ID | The ID of the client workstation, normalized in table |
SYSS_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SYSS_TOTAL_INSYBASE_TIME_SUM | Total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYSS_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this session. |
SYSS_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SYSS_CPU_SUM | Amount of time the process was actively executing a statement. |
SYSS_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SYSS_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYSS_REMOTE_WAIT_SUM | Amount of time the process was waiting for remote query to terminate. |
SYSS_LOG_WAIT_SUM | 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. |
SYSS_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYSS_LOG_SUSPEND_SUM | 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. |
SYSS_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYSS_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYSS_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYSS_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYSS_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYSS_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SYSS_NUM_OF_SESSIONS_NOT_ENDED | Number of sessions, which were still open at the end of the row's timeframe. |
SYSS_NUM_OF_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SYSS_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SYSS_STAT_CPU_SUM | Statistics summing the amount of the process' read memory usage. |
SYSS_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYSS_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYSS_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SYSS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYSS_SLA_RED_SUM | For future use. |
SYSS_SLA_YELLOW_SUM | For future use. |
SYSS_SLA_GREEN_SUM | For future use. |
SYSS_ROWID | Unique row number. |
PW_SYSE_SESSIONS_STMT_STATS_T
Stores statistics about performance of statements inside applications per timeslice for every combination of instance, database, program, user, login, machine, and work type.
Info |
---|
|
Column Name | Column Description |
---|---|
SYSE_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSE_TIMESTAMP | 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 |
SYSE_PWHG_ID | Hour group ID. |
SYSE_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSE_PROGRAM_ID | ID of the application program, normalized in table PW_SYPN_PROGRAM_NAMES_N . |
SYSE_DATABASE_ID | ID of the database to which the statement belongs, normalized in table |
SYSE_USER_ID | 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 |
SYSE_LOGIN_ID | 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 |
SYSE_MACHINE_ID | The ID of the client workstation, normalized in table |
SYSE_WORK_TYPE | Type of session, such as batch, dialog, queue. Used only in ERP components. |
SYSE_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYSE_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SYSE_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYSE_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the batch in its collapsed form. |
SYSE_TOTAL_INSYBASE_TIME_SUM | Total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYSE_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this statement. |
SYSE_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SYSE_CPU_SUM | Amount of time the process was actively executing a statement. |
SYSE_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SYSE_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYSE_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SYSE_LOG_WAIT_SUM | 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. |
SYSE_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYSE_LOG_SUSPEND_SUM | 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. |
SYSE_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYSE_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYSE_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYSE_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYSE_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYSE_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SYSE_NUM_OF_SESSIONS_NOT_ENDED | Number of statement executions, which ended during the row's timeframe. |
SYSE_NUM_OF_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SYSE_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SYSE_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SYSE_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYSE_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYSE_STAT_OPEN_TRANS_MAX | Number of transaction the process opened. |
SYSE_PARALLEL_DEGREE_MIN | Minimum number of sessions executing this statement in parallel. |
SYSE_PARALLEL_DEGREE_MAX | Maximum number of sessions executing this statement in parallel. |
SYSE_SLA_RED_SUM | For future use. |
SYSE_SLA_YELLOW_SUM | For future use. |
SYSE_SLA_GREEN_SUM | For future use. |
SYSE_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYSE_ROWID | Unique row number. |
SYSE_START_BIT_ID | For future use. |