Page History
...
| 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 | 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. |
...
| Column Name | Column Description |
|---|---|
SQOP_PWII_INSTANCE_ID | ID of the MS-SQL Server instance. |
SQOP_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 |
SQOP_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQOP_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQOP_PWHG_ID | Hour group ID. |
SQOP_OBJECT_FULL_ID | For heavy object finding, the Ignored table ID, Normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
SQOP_DATABASE_ID | The database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N. |
| FULL_TABLE_ID | Full table ID means: It is a normalized field which holds only a numeric hash value of the full table name. The normalization table is: |
SQOP_TOTAL_INMSSQL_SUM | Indicates the total amount of time MS-SQL Server was actively executing queries. It is also the sum of the columns. |
SQOP_USING_CPU_SUM | Total time of CPU use. |
SQOP_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQOP_LOCK_ROW_SUM | Aggregates lock waits of row locks. |
SQOP_LOCK_KEY_SUM | Aggregates lock waits of key locks. |
SQOP_LOCK_PAGE_SUM | Aggregates lock waits of page locks. |
SQOP_LOCK_TABLE_SUM | Aggregates lock waits of table locks. |
SQOP_LOCK_OTHER_SUM | Aggregates lock waits of other locks. |
SQOP_LOCK_MD_STAT_SUM | Aggregates lock waits of MetaData Statistics type. |
SQOP_LOCK_MD_PART_SUM | Aggregates lock waits of MetaData Partition Function type. |
SQOP_LOCK_MD_OTHER_SUM | Aggregates lock waits of other MetaData types. |
PW_SQEE_EXPLN_ESTIMATED_COST
Contains overtime history of statement's estimated cost changes.
| Column Name | Column Description |
|---|---|
SQEE_PWII_INSTANCE_ID | ID of the MS-SQL Server instance. |
SQEE_DATABASE_NAME | Name of the database. |
SQEE_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. |
SQEE_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEE_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
SQEE_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEE_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEE_ESTIMATE_COST | Estimated cost of this operation. |
SQEE_ACTUAL_PLAN_IND | An indicator if the execution plan is actual or estimated PW_SQEA_EXPLN_ACCESS_PATH. |
PW_SQEA_EXPLN_ACCESS_PATH
Contains overtime history of statement's access path changes.
| Column Name | Column Description |
|---|---|
SQEA_PWII_INSTANCE_ID | ID of the MS-SQL Server instance. |
SQEA_DATABASE_NAME | Name of the database. |
SQEA_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. |
SQEA_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEA_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0. |
SQEA_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEA_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEA_ESTIMATE_COST | Estimated cost of this operation. |
SQEA_ACTUAL_PLAN | An indicator if the execution plan is actual or estimated. |
SQEA_ACCESS_PATH_HV | Unique identifier (number) assigned to the access plan of the statement. |
SQEA_MISS_INDEXES_IMPACT | The minimal possible impact of indexes that are missing for effective query execution. |
SQEA_EXPLAIN_OPER_USAGE | This column contains a mask of operations that appeared in the execution plan. |