PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | ID of the instance. Columns of |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_SYMP_MONITORS_PREV
Stores the last and current collected Sysmonitor counter values. Serves the Statistics process for the calculation of the delta values of the counters.
Column Name | Column Description |
---|---|
SYMP_PWII_INSTANCE_ID | ID of the counter instance. |
SYMP_GROUP_NAME | Group that includes the counter. |
SYMP_FIELD_NAME | Counter name in the sysmonitor table. |
SYMP_FIELD_ID | Counter ID in the sysmonitor table. |
SYMP_VALUE | Counter value in the sysmonitor table. |
SYMP_TYPE | Marks if this is the last or current counter's value. |
PW_SYOU_OBJECTS_SPACE_USAGE_D
Holds statistics on the objects space. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYOU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYOU_DATABASE_ID | Name of the database, normalized in table |
SYOU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYOU_OBJECT_ID | ID of the table. |
SYOU_FULL_OBJECT_ID | The full object ID, normalized in table |
SYOU_INDEX_ID | ID of the index. |
SYOU_TIMESTAMP | 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. |
SYOU_PWHG_ID | Hour group ID. |
SYOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYOU_O_ALL_ALLOC_MAX | Size in Megabytes allocated to the object. |
SYOU_O_ALL_USED_MAX | Size in Megabytes used by the object. |
SYOU_O_TEXT_ALLOC_MAX | Size in Megabytes allocated to text pages of the object. |
SYOU_O_TEXT_USED_MAX | Size in Megabytes used for text pages of the object. |
SYOU_O_DATA_USED_MAX | Size of data pages in Megabytes used by the objects. |
SYOU_O_INDEX_ALLOC_MAX | Size in Megabytes allocated to the indexes of the object. |
SYOU_O_INDEX_USER_MAX | Size in Megabytes used by the indexes of the object. |
SYOU_ROW_COUNT_MAX | Number of rows the table has. |
SYOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYDU_DEVICES_SPACE_USAGE_D
Holds statistics on the space of devices. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYDU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYDU_DEVICE_ID | ID of the device, normalized in table |
SYDU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYDU_PWHG_ID | Hour group ID. |
SYDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYDU_DEVICE_SIZE_MAX | Maximum device size in Megabytes. |
SYDU_SPACE_USED_MAX | Maximum space used in Megabytes. |
SYDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYSU_SEGMENTS_SPACE_USAGE_D
Holds statistics on the space of segments. By default, this process runs every 24 hours.
- The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYSU_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSU_DATABASE_ID | ID of the database, normalized in table |
SYSU_SEGMENT_ID | ID of the segment, normalized in table PW_SYSN_SEGMENT_NAMES_N . |
SYSU_PRODUCTION_DATABASE_ID | ID of the database in Sybase. |
SYSU_PRODUCTION_SEGMENT_ID | ID of the segment in Sybase. |
SYSU_DEVICE_ID | ID of the device, normalized in table |
SYSU_SEGMENT_TYPE | Segment type:
|
SYSU_TIMESTAMP | Date the statistic was sampled. The time part is zeroed because the data is collected once a day. |
SYSU_PWHG_ID | Hour group ID. |
SYSU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYSU_SEGMENT_SIZE_MAX | Maximum segment size in Megabytes. |
SYSU_SPACE_FREE_MAX | Maximum free space size in Megabytes. |
SYSU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SYSC_STMT_CATALOG
Holds information on statements in the SQL workspace.
Column Name | Column Description |
---|---|
SYSC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSC_CABINET | Name of the cabinet in which the statement is stored. |
SYSC_FOLDER | Name of the folder within the cabinet. |
SYSC_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SYSC_WORKSHOP_ID | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
PW_SYEO_EXPLN_OPER
Holds information on batch access plans.
Column Name | Column Description |
---|---|
SYEO_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYEO_DATABASE_NAME | Name of the database to which the statement belongs. |
SYEO_PARSING_USER | 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. |
SYEO_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYEO_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the SQL workspace. Statements loaded into the PMDB have the value 0. |
SYEO_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SYEO_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SYEO_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SYEO_OPERATOR_TYPE | Physical operation in the access plan. |
SYEO_EXECUTION_ORDER | Sequence order of this operation in the whole access plan. |
SYEO_TREE_LEVEL | Tree level of this operation in the access plan. |
SYEO_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SYEO_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SYEO_OBJ_NAME | Name of the object accessed in this operation. |
SYEO_OBJ_NAME_ALIAS | Alias name of the object accessed in this operation. |
SYEO_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SYEO_ADDITIONAL_INFORMATION | Additional Information provided for this Explain step. |
SYEO_LOGICAL_READS | The optimizer is estimating how many pages will not be available in cache and will need to be read from disk. |
SYEO_PHYSICAL_READS | Number of logical reads performed on the specified table. The optimizer is estimating how many pages are likely to be in cache. |
SYEO_ROWS | Number of rows from the current table that is estimated to satisfy the join. |
SYEO_SCAN_COUNT | Number of times we scan the table. |
SYEO_LOGICAL_READS_SUB | Number of logical reads of sub-query. |
SYEO_PHYSICAL_READS_SUB | Number of physical reads of sub-query. |
SYEO_PARALLEL_IND | Indicates if the operation is performed in parallel. |
SYEO_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SYEO_OPERATOR_COST | Estimated cost for the operator in the execution plan |
SYEO_AVG_WIDTH | Estimated average width of row returned by the operator |
SYEO_CPU | Estimated CPU cost for the operator in the execution plan |
SYEO_CPU_SUB | Estimated CPU cost for the sub tree starting from the operator |
SYEO_PAGES | Estimated number of pages accessed by the operator |
SYEO_PREFETCH | Indication if prefetch performed by the operator |
SYEO_IOSIZE | Estimated I/O size for the operator |
SYEO_BUFREPLACE | Buffer replacement strategy used in the operator |
PW_SYEA_EXPLN_ACCESS_PATH
Holds the history of access plans.
Column Name | Column Description |
---|---|
SYEA_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYEA_DATABASE_NAME | Name of the database to which the statement belongs. |
SYEA_PARSING_USER | 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. |
SYEA_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYEA_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the SQL workspace. Statements loaded into the PMDB have the value 0. |
SYEA_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SYEA_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SYEA_ACCESS_PATH_HV | Unique identifier (number) assigned to the access. |
SYEA_ESTIMATE_COST | Estimated cost of this operation. |
PW_SYEH_EXPLN_HIST
Holds information on batch execution plans. Each batch can have up to three different execution plans.
Column Name | Column Description |
---|---|
SYEH_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYEH_DATABASE_NAME | Database to which the statement belongs. |
SYEH_PARSING_USER | 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. |
SYEH_BATCH_HV | Unique identifier (number) assigned to the batch. |
SYEH_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the SQL workspace. Statements loaded into the PW have the value 0. |
SYEH_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SYEH_PHYSICAL_READS | The optimizer is estimating how many pages are not available in cache and must be read from disk. |
SYEH_LOGICAL_READS | Number of logical reads performed on the specified table. The optimizer is estimating how many pages are likely to be in the cache. |
SYEH_SCAN_COUNT | Number of times we scan the table. |
SYEH_LAST_EXPLAIN_IND | Indicates that this access plan is the last access plan of the batch. |
SYEH_PHYSICAL_READS | Estimated number of physical reads for the execution plan. |
SYEH_LOGICAL_READS | Estimated number of logical reads for the execution plan. |
SYEH_SCAN_COUNT | Estimated number of scans for the execution plan. |
SYEH_CPU | Estimated CPU cost for the execution plan. |
SYEH_COST | Estimated cost for the execution plan. |
PW_SYSM_STATEMENTS
Holds statements collected by the Precise for Sybase Collector agent and statements inserted through the statement workshop (SQL workspace). The table holds one row per statement and connects it to the first batch in which the statement was sampled. You can join the statement with other batches run, but only for statistics tables. (PW_SYST_STATEMENTS_STATS
or PW_SYSE_SESS_STMT_STATS
).
Column Name | Column Description |
---|---|
SYSM_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYSM_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SYSM_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SYSM_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the statement in its collapsed form. |
SYSM_COLLAPSED_STATEMENT_ID | Unique identifier (string) assigned to the statement in its collapsed form. |
SYSM_INSERT_TIME | Date and time the statement was saved in the database. |
SYSM_PARSIN_USER | 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. |
SYSM_PARSING_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 |
SYSM_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the SQL workspace. |
SYSM_SOURCE | Indicates how the statement was loaded. Possible values:
|
SYSM_LAST_EXPLAINED | Last time the statement was explained. |
SYSM_TOTAL_INSYBASE_TIME | Not in use. |
SYSM_DO_NOT_EXPLAIN | Indicates an error during the explain of the statement (if Y, do not try to re-explain). |
SYSM_EXPLAIN_ERROR_MSG | Error that occurred during the last explain process. |
SYSM_LAST_ACC_PATH_CHANGED | Last time the access plan of the statement changed. |
SYSM_ACCESS_PATH_HV | Unique identifier (number) assigned to the access plan of the statement. |
SYSM_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. |
SYSM_DATABASE_NAME | Name of the database to which the statement belongs. |
SYSM_DATABASE_ID | ID of the database, in which the statement belongs, normalized in table |
SYSM_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SYSM_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SYSM_STATEMENT_OFFSET | The offset of the statement in the first batch sampled, running the statement by the Collector agent. |
SYSM_STATEMENT_LENGTH | Length of the statement in the first batch sampled running the statement. |
SYSM_STATEMENT_ID_IN_BATCH | Statement number in the first batch sampled running the statement. |
SYSM_START_EXEC_ORDER_IN_BATCH | Execution order the statement started with in the access plan of the batch. |
SYSM_STATEMENT_TYPE | ID representing the type of the statement: Type code = Type name
|
SYSM_EXPLAIN_USAGE_MAP | Internal bit representative of the types of operators in the execution plan. |
PW_SYBA_BATCHES
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
Stores statistics on statement and batch performance per timeslice.
- The
_T
table summarizes the data per timeslice. - The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
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.
- The
_T
table summarizes the data per timeslice. - The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
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.
- The
_T
table summarizes the data per timeslice. - The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
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 transactions 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. |
PW_SYNS_INSTANCE_STATS_T
Stores application performance statistics per timeslice for every combination of instance and database.
- The
_T
table summarizes the data per timeslice. - The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.
Column Name | Column Description |
---|---|
SYNS_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYNS_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 |
SYNS_PWHG_ID | Hour group ID. |
SYNS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYNS_DATABASE_ID | ID of the database to which the statement belongs, normalized in table |
SYNS_TOTAL_INSYBASE_TIME_SUM | Total amount of time Sybase was actively executing queries. It is also the sum of the columns. |
SYNS_TOTAL_DURATION_SUM | Total amount of time Sybase spent executing this statement. |
SYNS_REQUEST_WAIT_SUM | Amount of time the process was waiting for the client to issue a statement. |
SYNS_CPU_SUM | Amount of time the process was actively executing a statement. |
SYNS_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. |
SYNS_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SYNS_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SYNS_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. |
SYNS_SYNC_SUM | Amount of time the process was waiting to synchronize with another process. |
SYNS_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. |
SYNS_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SYNS_BUFFER_WAIT_SUM | Amount of time the process was waiting to access a user log cache. |
SYNS_INTERNAL_LOCK_SUM | Amount of time the process was waiting for an internal lock to be released. |
SYNS_WAITFOR_COMMAND_SUM | Amount of time the process was executing the WAITFOR DELAY command. |
SYNS_OTHER_WAIT_SUM | Amount of time the process was waiting for unknown reasons. |
SYNS_NUM_OF_ENDED_SESSIONS_SUM | Number of sessions, which ended during the row's timeframe. |
SYNS_NUM_OF_SESSIONS_NOT_ENDED | Number of statement executions, which ended during the row's timeframe. |
SYNS_NUM_OF_ENDED_EXECUTIONS_SUM | Number of statement executions, which ended during the row's timeframe. |
SYNS_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions, which were still running at the end of the row's timeframe. |
SYNS_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SYNS_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SYNS_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SYNS_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SYNS_SLA_RED_SUM | For future use. |
SYNS_SLA_YELLOW_SUM | For future use. |
SYNS_SLA_GREEN_SUM | For future use. |
SYNS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYNS_ROWID | Unique row number. |
SYNS_WORK_TYPE | Type of session, such as batch, dialog, or queue. |
PW_SYPQ_PLL_QUERY_STATS_T
Contains overtime counter values. Includes counters that are relevant to Parallel Queries statistics.
- The
_T
table summarizes the data per timeslice. - The
_D
table summarizes the data per day. - The
_W
table summarizes the data per week. - The
_M
table summarizes the data per month.