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