Page History
...
Holds mapping disks of HP or HDS systems.
| Column Name | Column Description |
|---|---|
SQXM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQXM_PHYSICAL_DISK | Physical disk number. |
SQXM_DEVICE_NAME | Name of the device. |
SQXM_ARRAY_ID | ID of the array. |
SQXM_CONTROL_UNIT | Control unit identifier. |
SQXM_LDEV_ID | ID of the logical device. |
SQXM_RAID_GROUP | Name of the raid group. |
SQXM_CHP_ID | Identification number of the Client Host Interface Processor Port of the logical device. |
SQXM_ACP_PAIR_ID | Identification number of the Array Control Processor Pair of the logical device. |
SQXM_URL | Vendor-specific performance URL. |
PW_SQOU_OBJECTS_SPACE_USAGE_D
Holds statistics on objects space. By default, this process runs every 24 hours.
| Column Name | Column Description |
|---|---|
SQOU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQOU_DATABASE_ID | Name of the database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQOU_OBJECT_ID | ID of the table. |
SQOU_FULL_OBJECT_ID | The full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N. |
SQOU_INDEX_ID | ID of the index. |
SQOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQOU_PWHG_ID | Hour group ID. |
SQOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQOU_O_ALL_ALLOC_MAX | Number of pages allocated to the object. |
SQOU_O_ALL_USED_MAX | Number of pages used by the object. |
SQOU_O_TEXT_ALLOC_MAX | Number of text pages allocated to the object. |
SQOU_O_TEXT_USED_MAX | Number of text pages used by the object. |
SQOU_O_DATA_USED_MAX | Number of data pages used by the objects. |
SQOU_O_INDEX_ALLOC_MAX | Number of pages allocated to the indexes of the object. |
SQOU_O_INDEX_USED_MAX | Number of pages used by the indexes of the object. |
SQOU_ROW_COUNT_MAX | Number of rows the object has. |
SQOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQOU_ROWID | Unique row number. |
SQOU_SYSTEM_SEEKS_SUM | Number of system seeks per one object. |
SQOU_SYSTEM_SCANS_SUM | Number of system scans per one object. |
SQOU_SYSTEM_LOOKUPS_SUM | Number of system lookups per one object. |
SQOU_SYSTEM_UPDATES_SUM | Number of system updates per one object. |
SQOU_USER_SEEKS_SUM | Number of user seeks per one object. |
SQOU_USER_SCANS_SUM | Number of user scans per one object. |
SQOU_USER_LOOKUPS_SUM | Number of user lookups per one object. |
SQOU_USER_UPDATES_SUM | Number of user updates per one object. |
PW_SQDU_DBFILES_SPACE_USAGE_D
Holds the space over time of datafiles. By default, this process runs every 24 hours.
| Column Name | Column Description |
|---|---|
SQDU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDU_DATABASE_NAME | ID of the database, normalized in table PW_SQDN_DATABASE_NAMES_N. |
SQDU_FILE_ID | ID of the file in the database. |
SQDU_FILE_NAME_ID | The internal file ID, normalize in table PW_SQDN_FILE_NAMES_N. |
SQDU_FILE_GROUP_ID | ID of the file group in the database. |
SQDU_FILE_GROUP_NAME_ID | The internal file group ID, normalized in table PW_SQDN_FILE_GROUP_NAMES_N. |
SQDU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQDU_PWHG_ID | Hour group ID. |
SQDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDU_FILE_SIZE_MAX | Maximum file size in MB. |
SQDU_SPACE_USED_MAX | Number of MB bytes used in the files. |
SQDU_MAX_SIZE_MAX | Maximum growth of the file. |
SQDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDU_ROWID | Unique row number. |
PW_SQDF_DBFILES_STATISTICS_D
Holds information on I/O performance and load of the SQL Server datafiles.
SQDF_PWII_INSTANCE_ID ID of the SQL Server instance.
SQDF_DATABASE_NAME Name of the database.
SQDF_FILE_ID ID of the file in the database.
SQDF_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 SQDF_PWHG_ID should be used.
SQDF_PWHG_ID Hour group ID.
SQDF_READS_NUMBER_SUM Number of read requests for the file.
SQDF_WRITES_NUMBER_SUM Number of writes requests for the file.
SQDF_READS_BYTES_SUM Number of bytes read from the file.
SQDF_WRITTEN_BYTES_SUM Number of bytes written to the file.
SQDF_IO_WAIT_SUM I/O wait duration of the file.
SQDF_RECIEVED_TIMESTAMP Local date and time the row was loaded into the PMDB.
SQDF_ROWID Unique row number.
SQDF_READ_IO_WAIT_SUM Time of read I/O wait on files.
SQDF_WRITE_IO_WAIT_SUM Time of write I/O wait on files.
SQDF_LOGICAL_FILE_ID ID of the logical file, normalized in table PW_SQFN_FILE_NAMES_N.
PW_SQDB_DBFILES_SAMPLES
Holds last sample information on I/O performance and load of the SQL Server datafiles.
SQDB_PWII_INSTANCE_ID ID of the SQL Server instance.
SQDB_DATABASE_NAME Name of the database.
SQDB_FILE_ID ID of the file in the database.
SQDB_SAMPLE_NUMBER Sample number. 1 is the previous sample. 2 is the current sample.
SQDB_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 SQDB_PWHG_ID should be used.
SQDB_READS_NUMBER Number of read requests for the file.
SQDB_WRITES_NUMBER Number of write requests for the file.
SQDB_READS_BYTES Number of bytes read from the file.
SQDB_WRITTEN_BYTES Number of bytes writes to the file.
SQDB_IO_WAIT I/O wait duration of the file.
PW_SQAV_AVAILABILITY
Holds information on the status of the databases and the SQL Server instance.
SQAV_PWII_INSTANCE_ID ID of the SQL Server instance.
SQAV_DATABASE_NAME Name of the database. Null in case of an instance record.
SQAV_STATUS Status of the database or the instance.
SQAV_FROM_TIME Date and time the status was changed to the status field.
SQAV_TO_TIME Date and time the status was changed from the status field
PW_SQSC_STMT_CATALOG
Holds information on statements in the Statement Workshop.
SQSC_PWII_INSTANCE_ID ID of the SQL Server instance.
SQSC_CABINET Name of the cabinet in which the statement is stored.
SQSC_FOLDER Name of the folder within the cabinet.
SQSC_STATEMENT_ID Unique identifier (string) assigned to the statement.
SQSC_WORKSHOP_HV Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
PW_SQEO_EXPLN_OPER Holds information on batch access plans.
SQEO_PWII_INSTANCE_ID ID of the SQL Server instance.
SQEO_DATABASE_NAME Name of the database to which the statement belongs.
SQEO_PARSING_USER One of the 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.
SQEO_BATCH_HV Unique identifier (number) assigned to the batch.
SQEO_WORKSHOP_HV Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
SQEO_EXPLAIN_TIME Date and time the batch was explained and its access plan was changed.
SQEO_STATEMENT_ID_IN_BAT CH A statement number in the first batch sampled running the statement.
SQEO_OPERATOR_ID Sequence order of this operation in the access plan for a statement.
SQEO_OPERATOR_TYPE Physical operation in the access plan.
SQEO_OPTIONS Logical operation in the access plan.
SQEO_EXECUTION_ORDER Sequence order of this operation in the whole access plan.
SQEO_TREE_LEVEL Tree level of this operation in the access plan.
SQEO_ARGUMENTS_LIST Not in use.
SQEO_REMOTE_STATEMENT_HV Unique identifier (number) for the remote query used in this operation.
SQEO_OBJ_DATABASE_NAME Database name of the object accessed in this operation.
SQEO_OBJ_OWNER_NAME Owner of the object accessed in this operation.
SQEO_OBJ_NAME Name of the object accessed in this operation.
SQEO_INDEX_NAME Name of the index accessed in this operation. Otherwise NULL.
SQEO_TOTAL_SUBTREE_COST Estimated cost of this operation and its descendants.
SQEO_CONTRIBUTION_RATIO Contribution value of the object in this operation to the statement.
SQEO_ESTIMATE_COST Estimated cost of this operation.
SQEO_ESTIMATE_IO_COST Estimated I/O cost of this operation.
SQEO_ESTIMATE_CPU_COST Estimated CPU cost of this operation.
SQEO_ESTIMATE_ROWS Estimated number of rows returned by this operation.
SQEO_WARNINGS Warnings in this operation.
SQEO_PARALLEL_IND Indicates if the operation is performed in parallel.
SQEO_ESTIMATE_EXECUTION Estimated number of times this operation is performed.
SQEO_LAST_EXPLAIN_IND Indicates that this operation belongs to the last explain of the batch.
SQEO_AVG_ROW_SIZE Average row size this operation handles.