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