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