Page History

Versions Compared

...

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.

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.

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.

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.

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.

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.

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.

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.

Scroll Ignore