Page History
...
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. |
PW_SQOP_OBJECTS_PERFORMENCE_D
A daily table which is being loaded every night by the Collects objects PMDB process. The table summarizes statistic data (such as locks, in_msssql, and using_cpu) per object (such as table and index). The idea behind this table is to accelerate the GUI in the Objects workspace.
| 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: 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. |