Page History
...
Holds all the object operators per object.
Column Name | Column Description |
---|---|
SQEJ_DATABASE_NAME | Name of the database. |
SQEJ_PARSING_USER | One of the MS-SQL Server 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. |
SQEJ_BATCH_HV | Unique identifier (number) assigned to the batch. Only the first batch appears. |
SQEJ_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB get this the value. |
SQEJ_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEJ_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEJ_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEJ_OPERATOR_TYPE | Physical operation in the access plan. |
SQEJ_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEJ_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEJ_OBJ_NAME | Name of the object accessed in this operation. |
SQEJ_OBJ_NAME_ALIAS | Alias name of the object accessed in this operation. |
SQEJ_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SQEJ_CONTRIBUTION_RATIO | Contribution value of the object in this operation to the statement. |
SQEJ_MISS_INDEXES_IND | Indicator if indexes are missing in this operation. |
PW_SQPU_PARTITION_USAGE_D
Collects space information per partition.
Column Name | Column Description |
---|---|
SQPU_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQPU_OBJECT_ID | ID of the object. |
SQPU_FULL_OBJECT_ID | The full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N . |
SQPU_INDEX_ID | ID of the index. |
SQPU_PARTITION_ID | ID of the partition. |
SQPU_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 SQPU_PWHG_ID should be used. |
SQPU_PWHG_ID | Hour group ID. |
SQPU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SQPU_P_ALL_ALLOC_MAX | Number of allocated pages for a specific partition (in MB). |
SQPU_P_ALL_USED_MAX | Number of used pages for a specific partition (in MB). |
SQPU_ROW_COUNT_MAX | Number of rows on a specific partition |
SQPU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
PW_SQCP_SCHEMA_CHANGES_PS
Collects information about schema changes made to a partition schema.
Column Name | Column Description |
---|---|
SQCP_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQCP_NAME | Name of the partition schema. |
SQCP_ID | Partition schema ID. |
SQCP_NUMBER_FG | Number of file groups of the partition schema. |
PW_SQCF_SCHEMA_CHANGES_PS_FG
Collects information about schema changes made to a partition schema filegroup.
Column Name | Column Description |
---|---|
SQCF_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQCF_PS_NAME | Name of the partition schema. |
SQCF_FP_NAME | Name of the partition function. |
SQCF_PS_TYPE | Type of the partition schema. |
PW_SQCN_SCHEMA_CHANGES_PF
Collects information about schema changes made to a partition function.
Column Name | Column Description |
---|---|
SQCN_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQCN_PF_NAME | Name of the partition function. |
SQCN_NUM_VALUES | Number of values of the partition function. |
SQCN_PF_TYPE | Partition function type. |
PW_SQCV_SCHEMA_CHANGES_PF_VAL
Collects information about schema changes made to a partition function values.
Column Name | Column Description |
---|---|
SQCV_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQCV_PF_NAME | Name of the partition function. |
SQCV_VALUE | Value of the partition function, one row for each value. |
SQCV_POSITION | Position of the value within the partition function. |
SQCV_TYPE | Type of the value, such as int and date. |
PW_SQWI_WAIT_INFO
Contains wait event counters info (MS-SQL).
Column Name | Column Description |
---|---|
SQWI_WAIT_GROUP | Normalized, wait group names. |
SQWI_WAIT_TYPE | Normalized, wait type names. |
SQWI_GROUP_FROM_VERSION | Group from, based on MS-SQL version. |
SQWI_GROUP_TILL_VERSION | Group till, based on MS-SQL version. |
SQWI_COUNTER_FROM_VERSION | Counter from, based on MS-SQL version. |
SQWI_COUNTER_TILL_VERSION | Counter till, based on MS-SQL version. |
SQWI_EXPLANATION | Counter explanation. |
SQWI_IS_LATCH | Wait event - 0. Latch event - 1. |
PW_SQWC_WAIT_COUNTERS_T
Contains wait counter’s data (MS-SQL).
Column Name | Column Description |
---|---|
SQWC_WAIT_TYPE | Wait type ID. |
SQWC_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SQWC_TOTAL_WAIT_TIME_SUM | Summarizes wait event's total wait time. |
SQWC_RESOURCE_WAIT_TIME_SUM | Summarizes wait event's resource wait time. |