Page History
...
Holds information on I/O performance and load of the SQL Server datafiles.
Column Name | Column Description |
---|---|
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_RECEIVED_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.
Column Name | Column Description |
---|---|
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.
Column Name | Column Description |
---|---|
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.
...