Precise for SQL Server tables

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column Name	Column Description
`PWII_ID`	ID of the instance. Columns of `XXXX_PWII_INSTANCE_ID` have values from the column.
`PWII_INSTANCE_NAME`	Name of the instance.
`PWII_TECHNOLOGY`	Two characters defining the technology of the instance (such as `OR` for Oracle and `JE` for J2EE).
`PWII_SERVER`	Name of the server on which the instance is installed.

PW_SQDL_INST_DB_DEFINITION_LOG

Tracks changes on instance/database definitions. It contains a list of all changes that occur in the instance/database definition.

Column Name	Column Description
`SQDL_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQDL_DATABASE_NAME`	Name of the database in which the change occurred.
`SQDL_OLD_VALUE`	Old value, before the change.
`SQDL_NEW_VALUE`	New value, after the change.
`SQDL_CHANGE_TYPE`	Type of the performed change (Created, Dropped, Updated).
`SQDL_DATA_CHANGED`	Property that was changed.
`SQDL_SAMPLE_DATE`	Date and time when the schema changes process ran. The actual change date is prior to the sample date and after the previous sample date.

PW_SQCL_SCHEMA_CHANGES_LOG

Contains a list of all changes that occur in the object’s index, key, and column definitions.

Column Name	Column Description
`SQCL_PWII`	ID of the SQL Server instance.
`SQCL_DATABASE_ID`	Internal ID of the database.
`SQCL_OBJECT_ID`	ID of the object, column, or index that was changed, depending on the type of the object that was changed.
`SQCL_OBJECT_TYPE`	Type of the object that was changed.
`SQCL_OBJECT_NAME`	Name of the object that was changed.
`SQCL_OBJECT_OWNER`	Owner of the object that was changed.
`SQCL_PARENT_OBJECT_ID`	ID of the parent object that was changed. For example, if an index was changed, the parent object ID is the table ID.
`SQCL_PARENT_OBJECT_NAME`	Name of the parent object name that was changed. For example: If an index was changed, the parent object name is the table name.
`SQCL_PARENT_OBJECT_OWNER`	Owner of the parent object owner that was changed. For example: If an index was changed, the parent object owner is the table owner.
`SQCL_INDEX_ID`	ID of the index that was changed. Relevant only for index key changes.
`SQCL_INDEX_NAME`	Name of the index that was changed. Relevant only for index key changes.
`SQCL_OLD_VALUE`	Old value (before the change).
`SQCL_NEW_VALUE`	New value (after the change).
`SQCL_CHANGE_TYPE`	Type of the performed change (Created, Dropped, Updated).
`SQCL_DATA_CHANGED`	Name of the property that was changed.
`SQCL_SAMPLE_DATE`	Date and time when the schema changes process run.

PW_SQID_SCHEMA_CHANGES_INST

Stores snapshots of the instances’ properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQID_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQID_CONFIG_OPTION_ID`	ID of the instance property, as appearing in `sp_configure`.
`SQID_CONFIG_OPTION_NAME`	Name of the instance property, as appearing in `sp_configure`.
`SQID_CONFIG_OPTION_VALUE`	Value of the instance property.

PW_SQCO_SCHEMA_CHANGES_OBJECTS

Stores snapshots of the instance objects’ properties. The object can be a table or a stored object such as a view, trigger, user-defined function, or stored procedure. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQCO_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCO_DATABASE_ID`	Internal ID of the database.
`SQCO_OBJECT_ID`	ID of the object that was changed.
`SQCO_NAME`	Name of the object that was changed.
`SQCO_OWNER`	Owner of the object that was changed.
`SQCO_TYPE`	Type of the object that was changed. See sysobjects documentation for a list of all available types.
`SQCO_CREATE_DATE`	Creation date of the object.
`SQCO_FILE_GROUP`	File group in which the object resides. Relevant only for tables.
`SQCO_NUM_OF_COLUMN`	Number of columns in the object.
`SQCO_EXEC_IS_ANSI_NULL_ON`	Value of the object’s Ansi Null property. Relevant only for stored objects.
`SQCO_TABLE_HAS_INDEX`	`TRUE` if the table has an index, `FALSE` if the table does not have an indexes.
`SQCO_TABLE_HAS_CLUSTERED_INDEX`	`TRUE` if the table has a clustered index, `FALSE` if the table does not have a clustered index.
`SQCO_DELETE_TRIGGER_COUNT`	Number of delete triggers on the table.
`SQCO_INSERT_TRIGGER_COUNT`	Number of insert triggers on the table.
`SQCO_UPDATE_TRIGGER_COUNT`	Number of update triggers on the table.
`SQCO_NUM_OF_PARTITIONS`	Number of partitions per object.

PW_SQCK_SCHEMA_CHANGES_INDXKEY

Stores snapshots of the index keys. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQCK_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCK_DATABASE_ID`	Internal ID of the database.
`SQCK_OBJECT_ID`	ID of the object on which the index is defined.
`SQCK_INDEX_ID`	ID of the index.
`SQCK_COLUMN_ID`	ID of the column.
`SQCK_COLUMN_NAME`	Name of the column key.
`SQCK_INDEX_NAME`	Name of the index.
`SQCK_OBJECT_NAME`	Name of the table.
`SQCK_OBJECT_OWNER`	Owner of the table.
`SQCK_POSITION`	Position of the key in the index.
`SQCK_ORDER_BY`	Sorting of the key in the index.

PW_SQCI_SCHEMA_CHANGES_INDEXES

Stores snapshots of the indexes. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQCI_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCI_DATABASE_ID`	Internal ID of the database.
`SQCI_OBJECT_ID`	ID of the object on which the index is defined.
`SQCI_INDEX_ID`	ID of the index.
`SQCI_INDEX_NAME`	Name of the index.
`SQCI_OBJECT_NAME`	Name of the table.
`SQCI_OBJECT_OWNER`	Owner of the table.
`SQCI_FILE_GROUP`	File group in which the index resides.
`SQCI_NUM_OF_KEYS`	Number of keys in the index.
`SQCI_FILL_FACTOR`	Fill factor of the index.
`SQCI_IS_CLUSTERED_INDEX`	Indicates whether the index is clustered.
`SQCI_IS_PAD_INDEX`	Indicates whether the index is padded.
`SQCI_IS_UNIQUE`	Indicates whether the index is unique.
`SQCI_INDEX_DEPTH`	Index tree level.
`SQCI_IS_AUTH_STAT`	Indicates if the index has turned on the autostatistics.
`SQCI_IS_PAGE_LOCK_DISALLOWED`	Indicates whether an index page can be locked.
`SQCI_IS_ROW_LOCK_DISALLOWED`	Indicates whether an index row can be locked.

PW_SQCD_SCHEMA_CHANGES_DB

Stores snapshots of the database properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQCD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCD_DATABASE_ID`	Internal ID of the database.
`SQCD_DATABASE_NAME`	Name of the database in which the change occurred.
`SQCD_RECOVERY`	Recovery model of the database.
`SQCD_AUTO_UPDATE_STATISTICS`	Auto-update statistics status of the database.
`SQCD_ANSI_NULL`	Ansi null status of the database.
`SQCD_AUTO_SHRINK_FILES`	Autoshrink files status of the database.
`SQCD_CLOSE_CURSORS_ON_COMMIT`	Close cursor on commit status of the database.
`SQCD_STATUS`	Availability status of the database.
`SQCD_AUTOCREATES_STATISTICS`	Autocreate statistics status of the database.
`SQCD_TRUNCATES_LOG`	Truncate log status of the database.
`SQCD_COMPATIBILITY_LEVEL`	Compatibility level of the database.
`SQCD_OBJECT_SAMPLE_STATUS`	Status of tracking changes on objects in the database.
`SQCD_COLUMN_SAMPLE_STATUS`	Status of tracking changes on columns in the database.
`SQCD_INDEX_SAMPLE_STATUS`	Status of tracking changes on indexes in the database.
`SQCD_INDEX_K_SAMPLE_STATUS`	Status of tracking changes on keys in the database.
`SQCD_DATABASES_SAMPLE_STATUS`	Status of tracking changes on database definitions in the database.
`SQCD_PS_SAMPLE_STATUS`	To support partition schema collecting.
`SQCD_PS_FG_SAMPLE_STATUS`	To support file group collecting pointed by partition schema.
`SQCD_PF_SAMPLE_STATUS`	To support partition function collecting.
`SQCD_PF_VALUES_SAMPLE_STATUS`	To support partition function values collecting of a particular partition function.
`SQCD_AUTO_UPDATE_STATS`	Database option.
`SQCD_PARAMS_FORCED`	Database option.
`SQCD_DATE_CORRELATION`	Database option.

PW_SQCC_SCHEMA_CHANGES_COLUMNS

Stores snapshots of the columns. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.

Column Name	Column Description
`SQCC_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCC_DATABASE_ID`	Internal ID of the database.
`SQCC_OBJECT_ID`	ID of the object to which the column belongs.
`SQCC_COLUMN_ID`	ID of the column.
`SQCC_COLUMN_NUMBER`	Number of the subprocedure when the procedure is grouped (`0` for nonprocedure objects).
`SQCC_COLUMN_NAME`	Name of the column.
`SQCC_OBJECT_NAME`	Name of the object.
`SQCC_OBJECT_OWNER`	Owner of the object.
`SQCC_TYPE`	Type of the column.
`SQCC_LENGTH`	Length of the column.
`SQCC_SCALE`	Scale of the column.
`SQCC_PRECISION`	Precision of the column.
`SQCC_IS_NULL_ABLE`	Nullable property of the column.
`SQCC_IS_TABLE`	Indicates whether the object is a table.

PW_SQRS_REPLIC_SNAP_STATS

Holds information on the object SQL Server: Replication Snapshot Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQRS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRS_INSTANCE_NAME`	Name of the snapshot agent.
`SQRS_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 `SQRS_PWHG_ID` should be used.
`SQRS_PWHG_ID`	Hour group ID.
`SQRS_SNAP_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRS_SNAP_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRS_ROWID`	Unique row number.

PW_SQRM_REPLIC_MERGE_STATS

Holds information on the object SQL Server: Replication Merge Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQRM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRM_INSTANCE_NAME`	Name of the merge agent.
`SQRM_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 `SQRM_PWHG_ID` should be used.
`SQRM_PWHG_ID`	Hour group ID.
`SQRM_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRM_CONFLICTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_DOWNLOADED_CHANGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_UPLOADED_CHANGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRM_ROWID`	Unique row number.

PW_SQRL_REPLIC_LOGREAD_STATS

Holds information on the object SQL Server: Replication Logreader Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQRL_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRL_INSTANCE_NAME`	Name of the publisher instance.
`SQRL_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 `SQRL_PWHG_ID` should be used.
`SQRL_PWHG_ID`	Hour group ID.
`SQRL_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRL_LOG_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_LOG_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_LOG_DELIVERY_LATENCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRL_ROWID`	Unique row number.

PW_SQRD_REPLIC_DISTRIB_STATS

Holds information on the object SQL Server: Replication Distribution Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQRD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRD_INSTANCE_NAME`	Name of the publisher instance.
`SQRD_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 `SQRD_PWHG_ID` should be used.
`SQRD_PWHG_ID`	Hour group ID.
`SQRD_DIST_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_DIST_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_DIST_DELIVERY_LATENCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRD_ROWID`	Unique row number.

PW_SQRA_REPLIC_AGENT_STATS

Holds information on the object SQL Server: Replication Agents Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQRA_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRA_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 `SQRA_PWHG_ID` should be used.
`SQRA_PWHG_ID`	Hour group ID.
`SQRA_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRA_DISTRIBUTION_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA__LOGREADER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_MERGE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_QUEUEREADER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_SNAPSHOT_TIMESTAMP`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRA_ROWID`	Unique row number.

PW_SQBP_BUFFER_PART_STATS

Holds information on the object SQL Server: Buffer Partition Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQBP_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBP_INSTANCE_NAME`	Name of the buffer.
`SQBP_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 `SQBP_PWHG_ID` should be used.
`SQBP_PWHG_ID`	Hour group ID.
`SQBP_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBP_FREE_LIST_EMPTY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_FREE_LIST_REQUESTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_FREE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBP_ROWID`	Unique row number.

PW_SQBM_BF_CH_MANAGER_STATS_T

Holds information on the objects SQL Server: Buffer Manager Object and SQL Server: Cache Manager Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQBM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBM_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 `SQBM_PWHG_ID` should be used.
`SQBM_PWHG_ID`	Hour group ID.
`SQBM_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBM_AWE_LOOKUP_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_STOLEN_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_UNMAP_CALL_AWG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_UNMAP_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_WRITE_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_BUFFER_HIT_RATIO_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CHECKPOINT_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_DATABASE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_LIST_STALL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_PAGES_MIN`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_LAZY_WRITES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_LIFE_EXPECTANCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_LOOKUPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_READS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_WRITES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PROCEDURES_CACHE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_READAHEAD_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_RESERVED_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_STOLEN_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_TARGET_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_TOTAL_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBM_ROWID`	Unique row number.
`SQBM_CACHE_HIT_SQL_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_OBJ_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_BND_TRE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_EXT_SP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_TMP_TAB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_SQL_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_OBJ_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_BND_TRE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_EXT_SP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_TMP_TAB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_SQL_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_OBJ_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_BND_TRE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_EXT_SP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_TMP_TAB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_SQL_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_OBJ_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_BND_TRE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_EXT_SP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_TMP_TAB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.

PW_SQBD_BACKUP_DEVICE_STATS_T

Holds information on the object SQL Server: Backup Device Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQBD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBD_INSTANCE_NAME`	Name of the backup device.
`SQBD_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 `SQBD_PWHG_ID` should be used.
`SQBD_PWHG_ID`	Hour group ID.
`SQBD_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBD_DEVICE_THROUGHPUT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBD_ROWID`	Unique row number.
`SQBD_READ_IO_WAIT`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_WRITE_IO_WAIT`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_FILE_NAME`	For more information, search for "performance counters" on http://msdn.microsoft.com.

PW_SQAM_ACCESS_METHODS_STATS_T

Holds information on the object SQL Server: Access Methods Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQAM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQAM_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 `SQAM_PWHG_ID` should be used.
`SQAM_PWHG_ID`	Hour group ID.
`SQAM_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQAM_EXTENT_DEALLOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_EXTENT_ALLOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FORWARDED_RECORDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FREESPACE_PAG_FETCH_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FREESPACE_SCANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FULL_SCANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_INDEX_SEARCHES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MIXED_PAGE_ALLOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_PAGE_DEALLOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_PAGE_SPLITS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_PAGES_ALLOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_PROBE_SCANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_RANGE_SCANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_SCAN_POINT_REVALID_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_SKIPP_GHOSTED_RECORD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_TABLE_LOCK_ESCALATION_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_WORKFILES_CREATED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_WORKTABLES_CREATED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_WORKTABLES_CREATED_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_WORKTABLE_CACHE_HIT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_CONNECTION_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_GRANTED_WS_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_BLOCK_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_BLOCK_ALLO_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_MEMORY_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_OWN_BLOCK_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_LOCK_OWN_BLOCK_ALC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_MAX_WS_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_MEMORY_GRANT_OUT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_MEMORY_GRANT_PEND_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_OPTIMIZER_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_SQL_CACHE_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_TARGET_SRV_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_TOTAL_SRV_MEMORY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_MM_TOTAL_SRV_MEMORY_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQAM_ROWID`	Unique row number.
`SQAM_AU_CLEANUP_BATCHES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_AU_CLEANUP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_COUNT_PULL_IN_ROW_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_COUNT_PUSH_OFF_ROW_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_DEFERRED_DROP_AUS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_DEFERRED_DROP_ROWSETS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_DROP_ROWSET_CLEANUPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_DROP_ROWSET_SKIPPED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FAIL_AU_CLEANUP_BATCH_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FAIL_LEAF_PAGE_COOKIE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_FAIL_TREE_PAGE_COOKIE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_USED_LEAF_PAGE_COOKIE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQAM_USED_TREE_PAGE_COOKIE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.

PW_SQDD_DATABASES_STATS_T

Holds information on the object SQL Server: Databases Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQDD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQDD_INSTANCE_NAME`	Name of the database.
`SQDD_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 `SQDD_PWHG_ID` should be used.
`SQDD_PWHG_ID`	Hour group ID.
`SQDD_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQDD_ACTIVE_TRANSACTIONS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_BACKUP_RES_THROUGHPUT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_BULK_COPY_ROWS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_BULK_COPY_THROUGHPUT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_DATA_FILE_SIZE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_DBCC_LOGICAL_SCAN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_BYTES_FLUSHED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_CACHE_HIT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_CACHE_READS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FILE_SIZE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FILE_SIZE_USED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FLUSH_WAIT_TIME_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FLUSH_WAIT_TIME_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FLUSH_WAITS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_FLUSHES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_GROWTHS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_SHRINKS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_LOG_TRUNCATIONS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_PERCENT_LOG_USED_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_REPL_PENDING_XACTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_REPL_TRANS_RATE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_SHRINK_DATA_MOVEMENT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_TRANSACTIONS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_TRANSACTIONS_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQDD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQDD_ROWID`	Unique row number.

PW_SQPS_SQL_STATISTIC_STATS_T

Holds information on the object SQL Server: SQL Statistics Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQPS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQPS_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 `SQPS_PWHG_ID` should be used.
`SQPS_PWHG_ID`	Hour group ID.
`SQPS_MINUTES_COUNT_SUM`	The timeframe needed to calculate the row, in minutes.
`SQPS_AUTO_PARAM_ATTEMPTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_BATCH-REQUESTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_BATCH_REQUESTS_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_FAILED_AUTO_PARAMS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_SAFE_AUTOPARAMS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_SQL_COMPILE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_SQL_RE_COMPILE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_SAFE_UNSAFE_AUTO_PARAM_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GENERAL_STAT_LOGINS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GENERAL_STAT_LOGINS_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GENERAL_STAT_LOGOUTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GENERAL_STAT_USR_CONN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GENERAL_STAT_USR_CONN_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT1_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT2_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT3_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT4_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT5_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT6_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT7_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT8_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT9_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_USER_SETTABLE_CNT10_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQPS_ROWID`	Unique row number.
`SQPS_GNRL_ACTIVE_TEMP_TAB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_LOGICAL_CON_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_MARS_DEADLOCKS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_NATOM_YIELD_RATE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_PROC_BLOCK_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_TMP_TAB_CRT_RATE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_TMP_DSTRUCT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_GNRL_TRANSACTIONS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_ETIME_DSTR_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_ETIME_DTC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_ETIME_EXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_ETIME_OLE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_INPROG_DSTR_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_STAT_E_INPROG_DSTR_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_INPROG_DTC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_INPROG_EXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_INPROG_OLE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_PERSEC_DSTR_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_PERSEC_DTC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_PERSEC_EXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_EX_STAT_E_PERSEC_OLE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_FORCED_PARM_SEC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_TRANS_VER_CLNUP_RATE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_TRANS_VER_GNRT_RATE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPS_TRANS_VER_STORE_SIZE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.

PW_SQLS_LOCKS_STATS_T

Holds information on the objects SQL Server: Locks Object and SQL Server: Latch Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQLS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQLS_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 `SQLS_PWHG_ID` should be used.
`SQLS_PWHG_ID`	Hour group ID.
`SQLS_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQLS_AVG_WAIT_TM_HIT_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_TL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_TL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_TL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_TL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_D_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_E_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_K_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_P_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_R_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_T_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_TL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_LATCH_WAIT_HIT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_LATCH_WAIT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_TOTAL_LATCH_WAIT_TIME_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQLS_ROWID`	Unique row number.
`SQLS_AVG_WAIT_TM_HIT_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_AVG_WAIT_TM_HIT_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_REQUESTS_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_TIMEOUTS_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAIT_TIME_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_LOCK_WAITS_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_AU_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_AP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_FI_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_HB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_MD_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQLS_NUMBER_OF_DEADLOCK_OB_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.

PW_SQPR_PROCESS_T

Holds information on the object Process Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQPR_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQPR_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 `SQPR_PWHG_ID` should be used.
`SQPR_PWHG_ID`	Hour group ID.
`SQPR_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQPR_PRCT_PROCESSOR_TIME_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_PRCT_PROCESSOR_TIME_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_SQL_SRVR_PAGE_FAULTS_AVG`	The overall average rate of faulted pages encountered by the SQL Server process, that are handled by the processor. It is measured in numbers of pages faulted per second. A page fault occurs when a process requires code or data that is not in its working set, i.e. its space in physical memory. This counter includes both hard faults (those that require disk access) and soft faults (where the faulted page is found elsewhere in physical memory). Most processors can handle large numbers of soft faults without consequence. However, hard faults can cause significant delays. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval.
`SQPR_PAGE_FAULTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_PAGE_READS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_PAGE_WRITES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPR_AVAILABLE_MB_AVG`	The amount of physical memory available to processes running on the computer, in megabytes (Bytes / 1,048,576). It is calculated by summing space on the Zeroed, Free, and Stand by memory lists. Free memory is ready for use; Zeroed memory are pages of memory filled with zeros to prevent later processes from seeing data used by a previous process. Standby memory is memory removed from a process' working set (its physical memory) on route to disk, but is still available to be recalled. This counter displays the last observed value only; it is not an average.
`SQPR_AVAILABLE_MB_MIN`	Like the previous counter, but it is the minimum value after doing the summary process.
`SQPR_SERVER_PHYS_MEMORY_MAX`	Total physical memory available in the instance machine.
`SQPR_QUEUE_LENGTH_AVG`	The number of threads in the processor queue. There is a single queue for processor time, even on computers with multiple processors. Unlike the disk counters, this counter counts ready threads only, not threads that are running. A sustained processor queue of greater than two threads generally indicates processor congestion. This counter displays the last observed value only; it is not an average.
`SQPR_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQPR_ROWID`	Unique row number.

PW_SQPO_PROCESSOR_T

Holds information on the object Processor Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQPO_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQPO_INSTANCE_NAME`	Number of the processor.
`SQPO_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 `SQPO_PWHG_ID` should be used.
`SQPO_PWHG_ID`	Hour group ID.
`SQPO_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQPO_PRCT_PROCESSOR_TIME_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPO_PRCT_PROCESSOR_TIME_MAX`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPO_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQPO_ROWID`	Unique row number.

PW_SQPD_PHYSICAL_DISK_T

Holds information on the object PhysicalDisk Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQPD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQPD_INSTANCE_NAME`	Identifier of the disk.
`SQPD_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 `SQPD_PWHG_ID` should be used.
`SQPD_PWHG_ID`	Hour group ID.
`SQPD_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQPD_AVG_DISK_QUEUE_LENGTH_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPD_DISK_READS_PER_SEC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPD_DISK_WRITES_PER_SEC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPD_DISK_SEC_READS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQPD_DISK_SEC_WRITES_AVG`	The average time in seconds it took to write data to the disk.
`SQPD_DISK_SEC_TRANSFER_AVG`	The average time in seconds of the average disk transfer.
`SQPD_DISK_TRANSFER_PER_SEC_AVG`	The average number of disk transfers per second.
`SQPD_DISK_SPLIT_IO_PER_SEC_AVG`	The average rate that I/Os to the disk were split into multiple I/Os. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented.
`SQPD_PRCT_DISK_READ_TIME_AVG`	The average percentage of elapsed time that the selected disk drive is busy servicing read requests.
`SQPD_PRCT_DISK_WRITE_TIME_AVG`	The average percentage of elapsed time that the selected disk drive is busy servicing write requests.
`SQPD_PRCT_IDLE_TIME_AVG`	The average percentage of time during the sample interval that the disk was idle.
`SQPD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQPD_ROWID`	Unique row number.

PW_SQXM_XP_MAPPING

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.

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.

Column Name	Column Description
`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.

Column Name	Column Description
`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_BATCH`	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.

PW_SQEH_EXPLN_HIST

Holds information on batch execution plans. Each batch can have up to three different execution plans.

Column Name	Column Description
`SQEH_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQEH_DATABASE_NAME`	Database to which the statement belongs.
`SQEH_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.
`SQEH_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEH_WORKSHOP_HV`	Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PW have the value 0.
`SQEH_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEH_TOTAL_ESTIMATE_COST`	Estimated cost of the batch.
`SQEH_TOTAL_ESTIMATE_IO_COST`	Estimated I/O cost of the batch.
`SQEH_TOTAL_ESTIMATE_CPU_COST`	Estimated CPU cost of the batch.
`SQEH_TOTAL_ESTIMATE_ROWS`	Estimated number of rows returned by the batch. Only rows from SELECT statements are calculated.
`SQEH_LAST_EXPLAIN_IND`	Indicates that this access plan is the last access plan of the batch.
`SQEH_ACTUAL_PLAN_IND`	An indicator if the execution plan is actual or estimated.

PW_SQST_STATEMENTS_STATS_T

Stores statistics on statement and batch performance per timeslice.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQST_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQST_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 `SQST_PWHG_ID` should be used.
`SQST_PWHG_ID`	Hour group ID.
`SQST_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQST_DATABASE_ID`	Database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQST_USER_ID`	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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQST_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQST_STATEMENT_HV`	Unique identifier (number) assigned to the statement.
`SQST_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form).
`SQST_COLLAPSED_STATEMENT_HV`	Unique identifier (number) assigned to the statement in its collapsed form.
`SQST_TOTAL_INMSSQL_TIME_SUM`	Indicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
`SQST_NUM_ENDED_EXECUTIONS_SUM`	Number of statement executions which ended during the row's timeframe.
`SQST_NUM_EXECUTIONS_NOT_ENDED`	Number of statement executions which were still running at the end of the row's timeframe
`SQST_TOTAL_DURATION_SUM`	Total amount of time SQL Server spent executing this statement.
`SQST_REQUEST_WAIT_SUM`	Not in use in this table.
`SQST_CPU_SUM`	Amount of time the process was actively executing a statement.
`SQST_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQST_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQST_REMOTE_WAIT_SUM`	Amount of time the process was waiting for a remote query to terminate.
`SQST_LOG_WAIT_SUM`	Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a `COMMIT` or `ROLLBACK` operation.
`SQST_INTERNAL_WAIT_SUM`	Amount of time the process was waiting for an internal resource to be freed.
`SQST_NET_IO_SUM`	Amount of time the process was waiting for the client process to acknowledge data sent to it.
`SQST_PARALLEL_EXCHANGE_SUM`	Amount of time the thread in a parallel session is waiting for data exchange from another thread.
`SQST_STAT_CPU_SUM`	Statistics summing the amount of the process’s read memory usage.
`SQST_STAT_PHYSICAL_IO_SUM`	Number of physical disk reads and writes for the process.
`SQST_STAT_MEM_USAGE_MAX`	Number of pages in the procedure cache allocated to the process.
`SQST_STAT_OPEN_TRANS_MAX`	Number of transactions the process opened.
`SQST_PARALLEL_DEGREE_MIN`	Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement.
`SQST_PARALLEL_DEGREE_MAX`	Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement.
`SQST_LOCK_ROW_SUM`	Amount of time the process was waiting to acquire a lock on a row.
`SQST_LOCK_KEY_SUM`	Amount of time the process was waiting to acquire a lock on an index key or an index key range.
`SQST_LOCK_PAGE_SUM`	Amount of time the process was waiting to acquire a lock on a table or index page.
`SQST_LOCK_TABLE_SUM`	Amount of time the process was waiting to acquire a lock on a table.
`SQST_COMPILE_LOCK_SUM`	Amount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure.
`SQST_OTHER_LOCK_SUM`	Amount of time the process was waiting to acquire a lock on a process that is unrecognized by Precise for SQL Server.
`SQST_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQST_SLA_RED_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, exceeded the breach threshold for the type of program.
`SQST_SLA_YELLOW_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, exceeded the near-breach threshold for the type of program.
`SQST_SLA_GREEN_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, was below the near-breach threshold for the type of program.
`SQST_ROWID`	Unique row number.
`SQST_NET_IO_WAIT_SUM`	Groups all I/O related wait types.
`SQST_TEMP_DB_WAIT_SUM`	Groups I/O / Latch on TempDB pages.
`SQST_IDLE_WAIT_SUM`	This group includes the events indicating that a session is waiting for something other than a user request.
`SQST_INTRNL_BP_WAIT_SUM`	This state groups the events, which all mean contention on pages in the buffer pool.
`SQST_INTRNL_LATCH_WAIT_SUM`	This group includes all Latch related wait types.
`SQST_INTRNL_PARALLEL_WAIT_SUM`	Amount of time the process was waiting for one of its sub-threads to complete its operation.
`SQST_INTRNL_DTC_WAIT_SUM`	Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
`SQST_INTRNL_DBMIRROR_WAIT_SUM`	Aggregates a couple of new waits that occur when DB Mirroring is used.
`SQST_INTRNL_PROFILER_WAIT_SUM`	Aggregates a number of states associated with the Profiler.
`SQST_INTRNL_MEMORY_WAIT_SUM`	Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
`SQST_INTRNL_BACKUP_WAIT_SUM`	Includes write-ups commonly occurring when a session is doing a `BACKUP` command.
`SQST_INTRNL_OTHER_WAIT_SUM`	This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
`SQST_LOCK_MD_STAT_SUM`	Aggregates lock waits of the MetaData Statistics type.
`SQST_LOCK_MD_PART_SUM`	Aggregates lock waits of the MetaData Partition Function type.
`SQST_LOCK_MD_OTHER_SUM`	Aggregates lock waits of other MetaData types.
`SQST_PC_RECOMPILATIONS_SUM`	Number of times this plan has been recompiled while it has remained in the cache.
`SQST_PC_CACHE_EVICTIONS_SUM`	Number of times the plan has been evicted from the cache.
`SQST_PC_EXECUTION_COUNT_SUM`	Number of times that the plan has been executed.
`SQST_PC_TOTAL_WORKER_TIME_SUM`	Amount of CPU time that was consumed by executions of this plan.
`SQST_PC_PHYSICAL_READS_SUM`	Number of physical reads performed by executions of this plan.
`SQST_PC_LOGICAL_READS_SUM`	Number of logical reads performed by executions of this plan.
`SQST_PC_LOGICAL_WRITES_SUM`	Number of logical writes performed by executions of this plan.
`SQST_PC_CLR_TIME_SUM`	Time consumed inside CLR objects by executions of this plan.
`SQST_PC_ELAPSED_TIME_SUM`	Total elapsed time for completed executions of this plan.

PW_SQSS_SESSIONS_STATS_T

Stores application performance statistics per timeslice for every combination of instance, database, program, user, logon, machine, and work type.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQSS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQSS_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 `SQSS_PWHG_ID` should be used.
`SQSS_PWHG_ID`	Hour group ID.
`SQSS_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQSS_PROGRAM_ID`	ID of the application program, normalized in table `PW_SQPN_PROGRAM_NAMES_N`.
`SQSS_DATABASE_ID`	ID of the database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQSS_USER_ID`	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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQSS_LOGIN_ID`	The name used to log in to the database. In case of Windows Authentication mode, it contains the domain and the Windows NT user name, normalized in table `PW_SQLN_LOGIN_NAMES_N`.
`SQSS_MACHINE_ID`	The ID of the client workstation, normalized in table `PW_SQMN_MACHINE_NAMES_N`.
`SQSS_WORK_TYPE`	Type of session, such as batch, dialog, queue. Used only in ERP components.
`SQSS_ERP_IDENTIFIER1_ID`	ID of the ERP entity, normalized in table `PW_SQE1_ERP_IDENTIFIERS1_N`.
`SQSS_ERP_IDENTIFIER2_ID`	ID of the ERP entity, normalized in table `PW_SQE2_ERP_IDENTIFIERS2_N`.
`SQSS_ERP_IDENTIFIER3_ID`	ID of the ERP entity, normalized in table `PW_SQE3_ERP_IDENTIFIERS3_N`.
`SQSS_ERP_IDENTIFIER4_ID`	ID of the ERP entity, normalized in table `PW_SQE4_ERP_IDENTIFIERS4_N`.
`SQSS_TOTAL_INMSSQL_TIME_SUM`	Total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
`SQSS_TOTAL_DURATION_SUM`	Total amount of time SQL Server spent executing this session.
`SQSS_REQUEST_WAIT_SUM`	Amount of time the process was waiting for the client to issue a statement.
`SQSS_CPU_SUM`	Amount of time the process was actively executing a statement.
`SQSS_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQSS_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQSS_REMOTE_WAIT_SUM`	Amount of time the process was waiting for remote query to terminate.
`SQSS_LOG_WAIT_SUM`	Amount of time the process was waiting on an operation on the log file to terminate. This state is generally encountered during a COMMIT or ROLLBACK operation.
`SQSS_SYNC_SUM`	Amount of time the process was waiting to synchronize with another process.
`SQSS_INTERNAL_WAIT_SUM`	Amount of time the process was waiting for an internal resource to be freed.
`SQSS_NET_IO_SUM`	Amount of time the process was waiting for the client process to acknowledge data sent to it.
`SQSS_PARALLEL_WAIT_SUM`	Amount of time the process was waiting for one of its sub-threads to complete its operation.
`SQSS_INTERNAL_LOCK_SUM`	Amount of time the process was waiting for an internal lock to be released.
`SQSS_WAITFOR_COMMAND_SUM`	Amount of time the process was executing the `WAITFOR DELAY` command.
`SQSS_PARALLEL_EXCHANGE_SUM`	Amount of time the thread in a parallel session is waiting for data exchange from another thread.
`SQSS_NUM_OF_ENDED_SESSIONS`	Number of sessions, which ended during the row's timeframe.
`SQSS_NUM_OF_SESSIONS_NOT_ENDED`	Number of sessions, which were still open at the end of the row's timeframe.
`SQSS_NUM_ENDED_EXECUTIONS_SUM`	Number of statement executions, which ended during the row's timeframe.
`SQSS_NUM_EXECUTIONS_NOT_ENDED`	Number of statement executions, which were still running at the end of the row's timeframe.
`SQSS_STAT_CPU_SUM`	Statistics summing the amount of the process's read memory usage.
`SQSS_STAT_PHYSICAL_IO_SUM`	Number of physical disk reads and writes for the process.
`SQSS_STAT_MEM_USAGE_MAX`	Number of pages in the procedure cache allocated to the process.
`SQSS_STAT_OPEN_TRANS_MAX`	Number of transactions the process opened.
`SQSS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQSS_LOCKED_ROW_SUM`	Amount of time the process was waiting to acquire a lock on a row.
`SQSS_LOCKED_KEY_SUM`	Amount of time the process was waiting to acquire a lock on an index key or an index key range.
`SQSS_LOCKED_PAGE_SUM`	Amount of time the process was waiting to acquire a lock on a table or index page.
`SQSS_LOCKED_TABLE_SUM`	Amount of time the process was waiting to acquire a lock on a table.
`SQSS_OTHER_LOCK_SUM`	Amount of time the process was waiting to acquire a lock that is unrecognized by Precise for SQL Server.
`SQSS_SLA_RED_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Breach threshold for the type of program.
`SQSS_SLA_YELLOW_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Near-Breach threshold for the type of program.
`SQSS_SLA_GREEN_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, was below Near-Breach threshold for the type of program.
`SQSS_ROWID`	Unique row number.
`SQSS_TOTAL_INMSSQL_SUM`	Indicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
`SQSS_TOTAL_DURATION_SUM`	Total amount of time SQL Server spent executing this statement.
`SQSS_REQUEST_WAIT_SUM`	Not in use in this table.
`SQSS_USING_CPU_SUM`	Total time of CPU use.
`SQSS_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQSS_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQSS_REMOTE_WAIT_SUM`	Amount of time the process was waiting for a remote query to terminate.
`SQSS_LOCK_MD_OTHER_SUM`	Total time that session waited on Meta Data Lock type.
`SQSS_SLA_RED_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, exceeded the breach threshold for the type of program.
`SQSS_SLA_YELLOW_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, exceeded the near-breach threshold for the type of program.
`SQSS_SLA_GREEN_SUM`	Number of times the average amount of time SQL Server was actively executing the statement, was below the near-breach threshold for the type of program.
`SQSS_PC_RECOMPILATIONS_SUM`	Number of times this plan has been recompiled while it has remained in the cache.
`SQSS_PC_CACHE_EVICTIONS_SUM`	Number of times the plan has been evicted from the cache.
`SQSS_PC_EVICTION_COUNT_SUM`	Number of times that the plan has been executed.
`SQSS_PC_TOTAL_WORKER_TIME_SUM`	Amount of CPU time that was consumed by executions of this plan.
`SQSS_PC_PHYSICAL_READS_SUM`	Number of physical reads performed by executions of this plan.
`SQSS_PC_LOGICAL_READS_SUM`	Number of logical reads performed by executions of this plan.
`SQSS_PC_LOGICAL_WRITES_SUM`	Number of logical writes performed by executions of this plan.
`SQSS_PC_CLR_TIME_SUM`	Time consumed inside CLR objects by executions of this plan.
`SQSS_PC_ELAPSED_TIME_SUM`	Total elapsed time for completed executions of this plan.

PW_SQSE_SESSIONS_STMT_STATS_T

Stores statistics about performance on every combination of statements and session identifiers, such as instance, database, program, user, logon, machine, and work type per timeslice.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQSE_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQSE_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 `SQSE_PWHG_ID` should be used.
`SQSE_PWHG_ID`	Hour group ID.
`SQSE_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQSE_PROGRAM_ID`	ID of the application program, normalized in table `PW_SQPN_PROGRAM_NAMES_N`.
`SQSE_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQSE_USER_ID`	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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQSE_LOGIN_ID`	The name used to log in to the database. In case of Windows Authentication mode, it contains the domain and the Windows NT user name, normalized in table `PW_SQLN_LOGIN_NAMES_N`.
`SQSE_MACHINE_ID`	The ID of the client workstation, normalized in table `PW_SQMN_MACHINE_NAMES_N`.
`SQSE_WORK_TYPE`	Type of session, such as batch, dialog, queue. Used only in ERP components.
`SQSE_ERP_IDENTIFIER1_ID`	ID of the ERP entity, normalized in table PW_SQE1_ERP_IDENTIFIERS1_N.
`SQSE_ERP_IDENTIFIER2_ID`	ID of the ERP entity, normalized in table PW_SQE2_ERP_IDENTIFIERS2_N.
`SQSE_ERP_IDENTIFIER3_ID`	ID of the ERP entity, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N.
`SQSE_ERP_IDENTIFIER4_ID`	ID of the ERP entity, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N.
`SQSE_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQSE_STATEMENT_HV`	Unique identifier (number) assigned to the statement.
`SQSE_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQSE_COLLAPSED_STATEMENT_HV`	Unique identifier (number) assigned to the batch in its collapsed form.
`SQSE_TOTAL_INMSSQL_SUM`	Total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
`SQSE_TOTAL_DURATION_SUM`	Total amount of time SQL Server spent executing this statement.
`SQSE_REQUEST_WAIT_SUM`	Amount of time the process was waiting for the client to issue a statement.
`SQSE_CPU_SUM`	Amount of time the process was actively executing a statement.
`SQSE_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQSE_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQSE_REMOTE_WAIT_SUM`	Amount of time the process was waiting for a remote query to terminate.
`SQSE_LOG_WAIT_SUM`	Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a `COMMIT` or `ROLLBACK` operation.
`SQSE_INTERNAL_WAIT_SUM`	Amount of time the process was waiting for an internal resource to be freed.
`SQSE_NET_IO_SUM`	Amount of time the process was waiting for the client process to acknowledge data sent to it.
`SQSE_PARALLEL_EXCHANGE_SUM`	Amount of time the thread in a parallel session is waiting for data exchange from another thread.
`SQSE_NUM_ENDED_EXECUTIONS_SUM`	Number of statement executions, which ended during the row's timeframe.
`SQSE_NUM_EXECUTIONS_NOT_ENDED`	Number of statement executions, which were still running at the end of the row's timeframe.
`SQSE_STAT_CPU_SUM`	Statistics summing the amount of the process’s read memory usage.
`SQSE_STAT_PHYSICAL_IO_SUM`	Number of physical disk reads and writes for the process.
`SQSE_STAT_MEM_USAGE_MAX`	Number of pages in the procedure cache allocated to the process.
`SQSE_STAT_OPEN_TRANS_MAX`	Number of transaction the process opened.
`SQSE_PARALLEL_DEGREE_MIN`	Minimum number of sessions executing this statement in parallel.
`SQSE_PARALLEL_DEGREE_MAX`	Maximum number of sessions executing this statement in parallel.
`SQSE_LOCK_ROW_SUM`	Amount of time the process was waiting to acquire a lock on a row.
`SQSE_LOCK_KEY_SUM`	Amount of time the process was waiting to acquire a lock on an index key or an index key range.
`SQSE_LOCK_PAGE_SUM`	Amount of time the process was waiting to acquire a lock on a table or index page.
`SQSE_LOCK_TABLE_SUM`	Amount of time the process was waiting to acquire a lock on a table.
`SQSE_COMPILE_LOCK_SUM`	Amount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure.
`SQSE_SLA_RED_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Breach threshold for the type of program.
`SQSE_SLA_YELLOW_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Near-Breach threshold for the type of program.
`SQSE_SLA_GREEN_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, was below Near-Breach threshold for the type of program.
`SQSE_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQSE_ROWID`	Unique row number.
`SQSE_START_BIT_ID`	For future use.
`SQSE_CLR_WAIT_SUM`	Groups all the CLR-related waits.
`SQSE_INTERNAL_WAIT_SUM`	Groups all the waits from Internal groups.
`SQSE_NET_IO_WAIT_SUM`	Groups all I/O related wait types.
`SQSE_TEMP_DB_WAIT_SUM`	Groups I/O / Latch on TempDB pages.
`SQSE_IDLE_WAIT_SUM`	This group includes the events indicating that a session is waiting for something other than a user request.
`SQSE_INTRNL_BP_WAIT_SUM`	This state groups the events, which all mean contention on pages in the buffer pool.
`SQSE_INTRNL_LATCH_WAIT_SUM`	This group includes all Latch related wait types.
`SQSE_INTRNL_PARALLEL_WAIT_SUM`	Amount of time the process was waiting for one of its sub-threads to complete its operation.
`SQSE_INTRNL_DTC_WAIT_SUM`	Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
`SQSE_INTRNL_DBMIRROR_WAIT_SUM`	Aggregates a couple of new waits that occur when DB Mirroring is used.
`SQSE_INTRNL_PROFILER_WAIT_SUM`	Aggregates a number of states associated with the Profiler.
`SQSE_INTRNL_MEMORY_WAIT_SUM`	Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
`SQSE_INTRNL_BACKUP_WAIT_SUM`	Includes wait types commonly occurring when a session is doing a BACKUP command.
`SQSE_INTRNL_OTHER_WAIT_SUM`	This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
`SQSE_NUM_OF_ENDED_SESSIONS_SUM`	Number of sessions, which ended during the row's timeframe.
`SQSE_NUM_OF_SESSIONS_NOT_ENDED`	Number of sessions, which were still open at the end of the row's timeframe.
`SQSE_LOCK_MD_STAT_SUM`	Aggregates lock waits of the MetaData Statistics type.
`SQSE_LOCK_MD_PART_SUM`	Aggregates lock waits of the MetaData Partition Function type.
`SQSE_LOCK_MD_OTHER_SUM`	Aggregates lock waits of other MetaData types.
`SQSE_PC_RECOMPILATIONS_SUM`	Number of times this plan has been recompiled while it has remained in the cache.
`SQSE_PC_CACHE_EVICTIONS_SUM`	Number of times the plan has been evicted from the cache.
`SQSE_PC_EXECUTION_COUNT_SUM`	Number of times that the plan has been executed.
`SQSE_PC_TOTAL_WORKER_TIME_SUM`	Amount of CPU time that was consumed by executions of this plan.
`SQSE_PC_PHYSICAL_READS_SUM`	Number of physical reads performed by executions of this plan.
`SQSE_PC_LOGICAL_READS_SUM`	Number of logical reads performed by executions of this plan.
`SQSE_PC_LOGICAL_WRITES_SUM`	Number of logical writes performed by executions of this plan.
`SQSE_PC_CLR_TIME_SUM`	Time consumed inside CLR objects by executions of this plan.
`SQSE_PC_ELAPSED_TIME_SUM`	Total elapsed time for completed executions of this plan.

PW_SQNS_INSTANCE_STATS_T

Stores application performance statistics per timeslice for every combination of instance and database.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQNS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQNS_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 SQNS_PWHG_ID should be used.
`SQNS_PWHG_ID`	Hour group ID.
`SQNS_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQNS_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQNS_TOTAL_INMSSQL_SUM`	Total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
`SQNS_TOTAL_DURATION_SUM`	Total amount of time SQL Server spent executing this statement.
`SQNS_REQUEST_WAIT_SUM`	Amount of time the process was waiting for the client to issue a statement.
`SQNS_CPU_SUM`	Amount of time the process was actively executing a statement.
`SQNS_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQNS_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQNS_REMOTE_WAIT_SUM`	Amount of time the process was waiting for a remote query to terminate.
`SQNS_LOG_WAIT_SUM`	Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a `COMMIT` or `ROLLBACK` operation.
`SQNS_INTERNAL_WAIT_SUM`	Amount of time the process was waiting for an internal resource to be freed.
`SQNS_NET_IO_SUM`	Amount of time the process was waiting for the client process to acknowledge data sent to it.
`SQNS_PARALLEL_EXCHANGE_SUM`	Amount of time the thread in a parallel session is waiting for data exchange from another thread.
`SQNS_NUM_OF_ENDED_SESSIONS_SUM`	Number of sessions, which ended during the row's timeframe.
`SQNS_NUM_OF_SESSIONS_NOT_ENDED`	Number of sessions, which were still open at the end of the row's timeframe.
`SQNS_NUM_ENDED_EXECUTIONS_SUM`	Number of statement executions, which ended during the row's timeframe.
`SQNS_NUM_EXECUTIONS_NOT_ENDED`	Number of statement executions, which were still running at the end of the row's timeframe.
`SQNS_STAT_CPU_SUM`	Statistics summing the amount of the process's read memory usage.
`SQNS_STAT_PHYSICAL_IO_SUM`	Number of physical disk reads and writes for the process.
`SQNS_STAT_MEM_USAGE_MAX`	Number of pages in the procedure cache allocated to the process.
`SQNS_STAT_OPEN_TRANS_MAX`	Number of transaction the process opened.
`SQNS_LOCK_ROW_SUM`	Amount of time the process was waiting to acquire a lock on a row.
`SQNS_LOCK_KEY_SUM`	Amount of time the process was waiting to acquire a lock on an index key or an index key range.
`SQNS_LOCK_PAGE_SUM`	Amount of time the process was waiting to acquire a lock on a table or index page.
`SQNS_LOCK_TABLE_SUM`	Amount of time the process was waiting to acquire a lock on a table.
`SQNS_OTHER_LOCK_SUM`	Amount of time the process was waiting to acquire a lock that is unrecognized by Precise for SQL Server.
`SQNS_SLA_RED_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Breach threshold for the type of program.
`SQNS_SLA_YELLOW_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, exceeded the Near-Breach threshold for the type of program.
`SQNS_SLA_GREEN_SUM`	Number of times the average amount of time SQL Server was actively executing the session's statement, was below Near-Breach threshold for the type of program.
`SQNS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQNS_ROWID`	Unique row number.
`SQNS_INTRNL_BO_WAIT_SUM`	This state groups the events, which all mean contention on pages in the buffer pool.
`SQNS_INTRNL_LATCH_WAIT_SUM`	This group includes all Latch related wait types.
`SQNS_INTRNL_PARALLEL_WAIT_SUM`	Aggregates the waits that indicates that session is waiting for one of its sub-threads to complete its operation.
`SQNS_INTRNL_DTC_WAIT_SUM`	Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
`SQNS_INTRNL_DBMIRROR_WAIT_SUM`	Aggregates a couple of new waits that occur when DB Mirroring is used.
`SQNS_INTRNL_PROFILER_WAIT_SUM`	Aggregates a number of states associated with the Profiler.
`SQNS_INTRNL_MEMORY_WAIT_SUM`	Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
`SQNS_INTRNL_BACKUP_WAIT_SUM`	Includes wait type commonly occurring when a session is doing a BACKUP command.
`SQNS_INTRNL_OTHER_WAIT_SUM`	This aggregates all the waits that do not match any of the Precise for MS-SQL Server states.
`SQNS_PC_RECOMPILATIONS_SUM`	Number of times this plan has been recompiled while it has remained in the cache.
`SQNS_PC_CACHE_EVICTIONS_SUM`	Number of times the plan has been evicted from the cache.
`SQNS_PC_EXECUTION_COUNT_SUM`	Number of times that the plan has been executed
`SQNS_PC_TOTAL_WORKER_TIME_SUM`	Amount of CPU time that was consumed by executions of this plan.
`SQNS_PC_PHYSICAL_READS_SUM`	Number of physical reads performed by executions of this plan.
`SQNS_PC_LOGICAL_READS_SUM`	Number of logical reads performed by executions of this plan.
`SQNS_PC_LOGICAL_WRITES_SUM`	Number of logical writes performed by executions of this plan.
`SQNS_PC_CLR_TIME_SUM`	Time consumed inside CLR objects by executions of this plan.
`SQNS_PC_ELAPSED_TIME_SUM`	Total elapsed time for completed executions of this plan.
`SQNS_LOCK_MD_STAT_SUM`	Aggregates lock waits of MetaData Statistics type.
`SQNS_LOCK_MD_PART_SUM`	Aggregates lock waits of MetaData Partition Function type.
`SQNS_LOCK_MD_OTHER_SUM`	Aggregates lock waits of other MetaData types.
`SQNS_CLR_WAIT_SUM`	Groups all the CLR-related waits.
`SQNS_INTERNAL_WAIT_SUM`	Groups all the waits from Internal groups.
`SQNS_NET_IO_WAIT_SUM`	Groups all I/O related wait types.
`SQNS_TEMP_DB_WAIT_SUM`	Groups I/O / Latch on TempDB pages.
`SQNS_IDLE_WAIT_SUM`	This group will include the events indicating that a session is waiting for something other than a user request.
`SQNS_INTRNL_BP_WAIT_SUM`	This state groups the events, which all mean contention on pages in the buffer pool.
`SQNS_INTRNL_LATCH_WAIT_SUM`	This group includes all Latch related wait types.
`SQNS_INTRNL_PARALLEL_WAIT_SUM`	Aggregates the waits that indicate that a session is waiting for one of its sub-threads to complete its operation.
`SQNS_INTRNL_DTC_WAIT_SUM`	Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
`SQNS_INTRNL_DBMIRROR_WAIT_SUM`	Aggregates a couple of new waits that occur when DB Mirroring is used.
`SQNS_INTRNL_PROFILER_WAIT_SUM`	Aggregates a number of states associated with the Profiler.
`SQNS_INTRNL_MEMORY_WAIT_SUM`	Includes wait types, all of which mean that a session is waiting for memory to be allocated to it.
`SQNS_INTRNL_BACKUP_WAIT_SUM`	Includes wait types commonly occurring when a session is doing a BACKUP command.
`SQNS_INTRNL_OTHER_WAIT_SUM`	This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.

PW_SQFA_FILE_ACTIVITY_STATS_T

Holds performance statistics on datafiles over time. Stores performance statistics on datafiles per timeslice for every combination of instance, database, program, user, batch, statement and locked object.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQFA_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQFA_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 `SQFA_PWHG_ID` should be used.
`SQFA_PWHG_ID`	Hour group ID.
`SQFA_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQFA_PROGRAM_ID`	ID of the application program, normalized in table `PW_SQPN_PROGRAM_NAMES_N`.
`SQFA_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQFA_USER_ID`	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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQFA_WORK_TYPE`	Type of session, such as batch, dialog, queue. Used only in ERP components.
`SQFA_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQFA_STATEMENT_HV`	Unique identifier (number) assigned to the statement.
`SQFA_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQFA_COLLAPSED_STATEMENT_HV`	Unique identifier (number) assigned to the batch in its collapsed form.
`SQFA_PHYSICAL_FILE_ID`	ID of the physical file, normalized in table `PW_SQFN_FILE_NAMES_N`.
`SQFA_LOGICAL_FILE_ID`	ID of the logical file, normalized in table `PW_SQFN_FILE_NAMES_N`.
`SQFA_UNIT_ID`	ID of the storage device.
`SQFA_DEVICE_NAME`	Name of the storage device.
`SQFA_SFW_DISK_NUMBER`	The storage for the Windows disk number as it appears in the Disk Management window in the Computer Management application.
`SQFA_IO_WAIT_SUM`	Amount of time the process was waiting for I/O operations to terminate.
`SQFA_FILE_DATABASE_ID`	ID of the file database, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQFA_FILE_GROUP_ID`	Group to which the file belongs.
`SQFA_DEVICE_TYPE`	Type of the storage device.
`SQFA_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQFA_ROWID`	Unique row number.

PW_SQDS_DBFILES_STATS_T

Holds statistics on datafiles over time.

Column Name	Column Description
`SQDS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQDS_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 `SQDS_PWHG_ID` should be used.
`SQDS_PWHG_ID`	Hour group ID.
`SQDS_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQDS_DATABASE_ID`	ID of the database, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQDS_PHYSICAL_FILE_ID`	ID of the physical file, normalized in table `PW_SQFN_FILE_NAMES_N`.
`SQDS_LOGICAL_FILE_ID`	ID of the logical file, normalized in table `PW_SQFN_FILE_NAMES_N`.
`SQDS_UNIT_ID`	ID of the storage device.
`SQDS_DEVICE_NAME`	Name of the storage device.
`SQDS_SFW_DISK_NUMBER`	The storage for Windows disk number as appears in the Disk Management window in the Computer Management application.
`SQDS_IO_WAIT_SUM`	Sum of the I/O wait spent on the device.
`SQDS_FILE_DATABASE_ID`	ID of the file database, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQDS_FILE_GROUP_ID`	Group to which the file belongs.
`SQDS_DEVICE_TYPE`	Type of the storage device.
`SQDS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQDS_ROWID`	Unique row number.

PW_SQLA_LOCK_ACTIVITY_STATS_T

Stores statement lock statistics per timeslice for every combination of instance, database, program, user, batch, statement and locked object.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQLA_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQLA_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 `SQLA_PWHG_ID` should be used.
`SQLA_PWHG_ID`	Hour group ID.
`SQLA_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQLA_PROGRAM_ID`	ID of the application program, normalized in table `PW_SQPN_PROGRAM_NAMES_N`.
`SQLA_DATABASE_ID`	The database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQLA_USER_ID`	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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQLA_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQLA_STATEMENT_HV`	Unique identifier (number) assigned to the statement.
`SQLA_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQLA_COLLAPSED_STATEMENT_HV`	Unique identifier (number) assigned to the batch in its collapsed form.
`SQLA_WORK_TYPE`	Type of session, such as batch, dialog, queue. Used only in ERP components.
`SQLA_LOCKED_OBJECT_TYPE`	Type of object being locked (such as table and file).
`SQLA_LOCKED_OBJECT_ID`	The ID of the locked object, normalized in table `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQLA_SQL_OBJECT_ID1` `SQLA_SQL_OBJECT_ID2` `SQLA_SQL_OBJECT_ID3`	These three columns combine together the locked object's identifier in SQL Server. For example: a locked index is represented by: Database id Table object id Index id
`SQLA_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQLA_ROWID`	Unique row number.
`SQLA_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.

PW_SQLO_LOCK_OBJECT_STATS_T

Stores application lock statistics per timeslice for every combination of Instance, database and locked objects.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQLO_PWII_INSTANCE`	ID of the SQL Server instance.
`SQLO_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 `SQLO_PWHG_ID` should be used.
`SQLO_PWHG_ID`	Hour group ID.
`SQLO_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQLO_DATABASE_ID`	ID of the database to which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQLO_LOCK_WAIT_SUM`	Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
`SQLO_LOCKED_OBJECT_TYPE`	Type of object being locked, such as table and file.
`SQLO_LOCKED_OBJECT_ID`	The ID of the locked object, normalized in table `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQLO_SQL_OBJECT_ID1` `SQLO_SQL_OBJECT_ID2` `SQLO_SQL_OBJECT_ID3`	These three columns combine together the locked object's identifier in SQL Server. For example: a locked index is represented by: Database id Table object id Index id
`SQLO_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQLO_ROWID`	Unique row number.

PW_SQSM_STATEMENTS

Holds statements collected by the Precise for SQL Server collector and statements inserted through the statement workshop (SQL workspace). The table holds one row per statement and connects it to the first batch in which the statement was sampled. You can join the statement with other batches run, but only for statistics tables. (PW_SQST_STATEMENTS_STATS or PW_STSE_SESS_STATEMENTS_STATS).

Column Name	Column Description
`SQSM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQSM_STATEMENT_HV`	Unique identifier (number) assigned to the statement.
`SQSM_STATEMENT_ID`	Unique identifier (string) assigned to the statement.
`SQSM_COLLAPSED_STATEMENT_HV`	Unique identifier (number) assigned to the statement in its collapsed form.
`SQSM_COLLAPSED_STATEMENT_ID`	Unique identifier (string) assigned to the statement in its collapsed form.
`SQSM_INSERT_TIME`	Date and time the statement was saved in the database.
`SQSM_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.
`SQSM_PARSING_USER_ID`	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, normalized in table `PW_SQUN_USE_NAMES_N`.
`SQSM_WORKSHOP_HV`	Unique identifier (Number) assigned to statements inserted in the SQL workspace.
`SQSM_SOURCE`	Indicates how the statement was loaded. Possible values: PMDB. Sampled and loaded by the Collector. Manually. Entered through the statement workshop (SQL workspace). Saved automatically. Explained from the Current workspace or Activity workspace.
`SQSM_LAST_EXPLAINED`	Last time the statement was explained.
`SQSM_TOTAL_MSSQL_TIME`	Not in use.
`SQSM_DO_NOT_EXPLAIN`	Indicates an error during the explain of the statement. If `Y`, do not try to re-explain.
`SQSM_EXPLAIN_ERROR_MSG`	Error that occurred during the last explain process.
`SQSM_LAST_ACC_PATH_CHANGED`	Last time the access plan of the statement changed.
`SQSM_ACCESS_PATH_HV`	Unique identifier (number) assigned to the access plan of the statement.
`SQSM_TOTAL_ESTIMATED_COST`	Estimated cost of the statement’s execution. A high cost value may indicate a problem in the current implementation of the statement. To determine which operation may have caused the problem, you can use the Estimated Cost Breakdown graph to drill down easily and see the most resource consuming operation. To determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both), check the Estimated I/O cost and Estimated CPU cost values.
`SQSM_DATABASE_NAME`	Name of the database to which the statement belongs.
`SQSM_DATABASE_ID`	ID of the database, in which the statement belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQSM_BATCH_HV`	Unique identifier (number) assigned to the batch. Only the first batch appears.
`SQSM_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch. Only the first batch appears.
`SQSM_STATEMENT_OFFSET`	The offset of the statement in the first batch sampled, running the statement by the Collector agent.
`SQSM_STATEMENT_LENGTH`	Length of the statement in the first batch sampled running the statement.
`SQSM_STATEMENT_ID_IN_BATCH`	Statement number in the first batch sampled running the statement.
`SQSM_START_EXEC_ORDER_IN_BATCH`	Execution order the statement started with in the access plan of the batch.
`SQSM_START_TREE_LEVEL`	Start level of the statement in the access plan of the batch.
`SQSM_EXPLAIN_USAGE_MAP`	Internal bit representative of the types of the operators in the execution plan.
`SQSM_ACTUAL_PLAN_IND`	MS-SQL 2005 only. Indication if the last execution plan of the statement is Actual or estimate.
`SQSM_MISS_INDEXES_IMPACT`	MS-SQL 2005 only. Indication if the last execution plan of the statement has missing indexes indication.
`SQSM_STATEMENT_TYPE`	Representing the type of the statement. Such as `INSERT` and `SELECT`.

PW_SQBA_BATCHES

Holds information on batches.

Column Name	Column Description
`SQBA_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBA_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQBA_COLLAPSED_BATCH_HV`	Unique identifier (number) assigned to the batch in its collapsed form.
`SQBA_PARSING_USER`	One of the SQL Server users who executed this batch. If this batch is a stored procedure, this is the user used as the parsing user when explaining this batch.
`SQBA_PARSING_USER_ID`	One of the SQL Server users who executed this batch. If this batch is a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQBA_DATABASE_NAME`	Name of the database to which the batch belongs.
`SQBA_DATABASE_ID`	The ID of the database, to which the batch belongs, normalized in table `PW_SQDN_DATABASE_NAMES_N`.
`SQBA_BATCH_ID`	Unique identifier (string) assigned to the batch.
`SQBA_COLLAPSED_BATCH_ID`	Unique identifier (string) assigned to the batch in its collapsed form.
`SQBA_LAST_EXPLAINED`	Last time the statement was explained.
`SQBA_DO_NOT_EXPLAIN`	Indicates an error during the explain of the statement. If `Y`, do not try to re-explain.
`SQBA_EXPLAIN_ERROR_MSG`	Error that occurred during the last explain process.
`SQBA_LAST_ACC_PATH_CHANGED`	Last time the access plan of the batch changed.
`SQBA_ACCESS_PATH_HV`	Unique identifier (number) assigned to the access plan.
`SQBA_TOTAL_ESTIMATED_COST`	Estimated cost of the statement’s execution. A high cost value may indicate a problem in the current implementation of the statement. To determine which operation may have caused the problem, you can use the Estimated Cost Breakdown graph to drill down easily and see the most resource consuming operation. To determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both), check the Estimated I/O cost and Estimated CPU cost values.
`SQBA_PROC_DB_ID`	ID of the database that holds the stored procedure.
`SQBA_PROC_OBJECT_ID`	ID of the stored procedure.
`SQBA_EXPLAIN_USAGE_MAP`	Internal bit representative of the types of the operators in the execution plan.
`SQBA_ACTUAL_PLAN_IND`	MS-SQL 2005 only. Indication if the last execution plan of the batch is Actual or estimate.
`SQBA_MISS_INDEXES_IMPACT`	MS-SQL 2005 only. Indication if the last execution plan of the batch has missing indexes indication.
`SQBA_DOTNET_HV`	Used for correlation between Precise for Microsoft .NET and Precise for MS SQL Server.
`SQBA_MIGRATED`	Data migration process only. Used to update several columns and distinguish between new batches and previous batches.
`SQBA_CONSISTENT_HV`	Used for correlation between all the other products and Precise for MS SQL Server.

PW_SQIN_INSTANCES

Holds information on the SQL Server instances monitored by Precise.

Column Name	Column Description
`SQIN_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQIN_CLUSTER_ID`	Used to share text of statements and batches between instances.
`SQIN_SYSTEM_NAME`	Server on which the Collector agent is installed.
`SQIN_INSTANCE_NAME`	Name of the monitored SQL Server instance.
`SQIN_LAST_PW_EXPLAIN_DATE`	Last date the explain process run.
`SQIN_LAST_PERF_LOAD_DATE`	Last date the instance performance was loaded.
`SQIN_LAST_STMT_LOAD_DATE`	Last date the statement text was loaded.
`SQIN_DB_FILES_LAST_SAMPLE`	Last date the process Collect DB Files Statistics ran.
`SQIN_LAST_AVAIL_LOADED`	Last date the instance availability was loaded.
`SQIN_LAST_AVAIL_LOADED_DB`	Last date the database availability was loaded.
`SQIN_UNAVAIL_DB_STATUS`	Combination of database statuses to classify a database as unavailable.
`SQIN_POINTS_INSTALLED`	Array of bits indicating which Interpoints and Precise for Storage are installed.
`SQIN_INSTANCE_TYPE`	User defined instance group name. And be updated by using stored procedure `SQ_UPDATE_INSTANCE_TYPE`.
`SQIN_JOB_SAMPLE_STATUS`	The status of job changes load (part of Collect Schema changes).
`SQIN_SCHEDULE_SAMPLE_STATUS`	The status of job schedule changes load (part of Collect Schema changes).
`SQIN_STEP_SAMPLE_STATUS`	The status of job step changes load (part of Collect Schema changes).
`SQIN_INSTANCE_VERSION`	The version of the MS-SQL Server instance.
`SQIN_COSTS_PURGED_TO_DATE`	A date until which historical data in the execution plan costs table was cleaned by Purge Internal Data process.

PW_SQCG_SCHEMA_CHANGES_GROUPS

Holds information on grouping the changes, on which we track to groups. For example groups that contained schema changes and groups that contained instance/database definitions.

Column Name	Column Description
`SQCG_GROUP_ID`	ID of group1 for schema changes and of group 2 for instance/database definitions.
`SQCG_DATA_CHANGED`	Name of the property that was changed.

PW_SQPC_PERFORMANCE_COUNTERS

Maps SQL Server performance counter names to the Precise PMDB tables and columns.

Column Name	Column Description
`SQPC_OBJECT_NAME`	Name of the performance Group as it appears in Microsoft SQL Server.
`SQPC_COUNTER_NAME`	Name of the performance Counter as it appears in Microsoft SQL Server.
`SQPC_INSTANCE_NAME`	Name of the performance Instance as it appears in Microsoft SQL Server.
`SQPC_TABLE_NAME`	Name of the table in the Precise PMDB, which holds the value.
`SQPC_COLUMN_NAME`	Name of the column in the Precise PMDB, which holds the value.
`SQPC_SCALE`	The scale of the value, in case it shows with other statistics.
`SQPC_FROM_VERSION`	Counter from based on MS-SQL version.
`SQPC_TILL_VERSION`	Counter till based on MS-SQL version.

PW_SQNK_NETWORK_T

Holds information on network activities of the SQL Server instance.

Column Name	Column Description
`SQNK_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQNK_PWII_INSTANCE_NAME`	Name of the network interface card.
`SQNK_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 `SQNK_PWHG_ID` should be used.
`SQNK_PWHG_ID`	Hour group ID.
`SQNK_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQNK_OUTPUT_QUEUE_LENGTH_AVG`	The average length of the output packet queue, in packets. If this is longer than 2, delays are being experienced and the bottleneck should be found and eliminated if possible. Because the requests are queued by NDIS in this implementation, this will always be 0.
`SQNK_OUTPUT_QUEUE_LENGTH_MAX`	The maximum length of the output packet queue, in packets. If this is longer than 2, delays are being experienced and the bottleneck should be found and eliminated if possible. Because the requests are queued by NDIS in this implementation, this will always be 0.
`SQNK_PACKETS_SENT_AVG`	The average rate at which packets are sent on the network interface.
`SQNK_PACKETS_SENT_MAX`	The highest rate at which packets are sent on the network interface.
`SQNK_PACKETS_RECEIVED_AVG`	The average rate at which packets are received on the network interface.
`SQNK_PACKETS_RECEIVED_MAX`	The highest rate at which packets are received on the network interface.
`SQNK_BYTES_SENT_AVG`	The average rate at which bytes are sent on the interface, including framing characters.
`SQNK_BYTES_SENT_MAX`	The highest rate at which bytes are sent on the interface, including framing characters.
`SQNK_BYTES_RECEIVED_AVG`	The average rate at which bytes are received on the interface, including framing characters.
`SQNK_BYTES_RECEIVED_MAX`	The highest rate at which bytes are received on the interface, including framing characters.
`SQNK_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQNK_ROWID`	Unique row number.

PW_SQJS_JOBS_STATS_D

Holds information on the SQL Server instance jobs.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQJS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQJS_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 `SQJS_PWHG_ID` should be used.
`SQJS_PWHG_ID`	Hour group ID.
`SQJS_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQJS_JOB_NAME`	Name of the job.
`SQJS_JOB_ID`	ID of the job, normalized in table `PW_SQE3_ERP_IDENTIFIERS3_N`.
`SQJS_DURATION_SUM`	Total elapsed time. This counter is reported by the SQL Server and not by the I4SQL collector.
`SQJS_EXECUTION_SUM`	Total number of job executions.
`SQJS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQJS_ROWID`	Unique row number.

PW_SQJT_JOBS_STEPS_STATS_D

Holds information on the SQL Server instance job steps.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

Column Name	Column Description
`SQJT_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQJT_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 `SQJT_PWHG_ID` should be used.
`SQJT_PWHG_ID`	Hour group ID.
`SQJT_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQJT_JOB_NAME`	Name of the job.
`SQJT_JOB_ID`	ID of the job, normalized in table `PW_SQE3_ERP_IDENTIFIERS3_N`.
`SQJT_STEP_ID`	ID of the step, normalized in table `PW_SQE4_ERP_IDENTIFIERS4_N`.
`SQJT_DURATION_SUM`	Total elapsed time. This counter is reported by the SQL Server and not by the Precise for SQL Server Collector agent.
`SQJT_EXECUTION_SUM`	Total number of job executions.
`SQJT_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQJT_ROWID`	Unique row number.

PW_SQCJ_MTNC_CHANGE_JOB

Holds information on the SQL Server instance MTNC job changes.

Column Name	Column Description
`SQCJ_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCJ_JOB_NAME`	Number of the job that was changed.
`SQCJ_ENABLED`	Job status.
`SQCJ_START_STEP_NAME`	Name of the first step that should run.
`SQCJ_CATEGORY_NAME`	The job's category name.
`SQCJ_OWNER_NAME`	The job's owner.
`SQCJ_EVENT_LOG_NOTIFY_LEVEL`	When to write to log.
`SQCJ_EMAIL_NOTIFY_LEVEL`	When to E-mail.
`SQCJ_NET_SEND_NOTIFY_LEVEL`	When to send net.
`SQCJ_PAGE_NOTIFY_LEVEL`	When to page.
`SQCJ_EMAIL_OPERATOR_NAME`	To whom to send E-mail.
`SQCJ_NET_SEND_OPERATOR_NAME`	To whom to send net.
`SQCJ_PAGE_OPERATOR_NAME`	To whom to page.
`SQCJ_DELETE_LEVEL`	When to do automatic delete.

PW_SQCT_MTNC_CHANGE_STEP

Holds information on the SQL Server instance MTNC job step changes.

Column Name	Column Description
`SQCT_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCT_JOB_NAME`	Number of the job that was changed.
`SQCT_STEP_NAME`	Job step name.
`SQCT_SUB_SYSTEM_NAME`	Name of the subsystem used by the SQL Server Agent to execute the job step.
`SQCT_COMMAND_TEXT`	Command to be executed.
`SQCT_ON_SUCCESS_ACTION`	Action to be performed when a step is executed successfully.
`SQCT_ON_SUCCESS_NEXT_STEP_NAME`	The name of the next step to execute when a step name executed successfully.
`SQCT_ON_FAIL_ACTION`	Action to be performed when a step is not executed successfully.
`SQCT_ON_FAIL_NEXT_STEP_NAME`	The name of the next step to to execute when a step is not executed successfully.
`SQCT_DATABASE_NAME`	Name of the database in which the command is executed.
`SQCT_DATABASE_USER_NAME`	Name of the database user whose account will be used when executing the step.
`SQCT_RETRY_ATTEMPTS`	Number of retry attempts made if the step fails.
`SQCT_RETRY_INTERVAL`	Amount of time to wait between retry attempts.

PW_SQCH_MTNC_CHANGE_LOG

Holds information on the SQL Server instance MTNC change log.

Column Name	Column Description
`SQCH_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQCH_ENTITY_TYPE`	Type of the entity that was changed.
`SQCH_ENTITY_NAME`	Name of the entity that was changed.
`SQCH_PARENT_ENTITY_NAME`	The name of the parent entity that was changed.
`SQCH_CHANGE_TYPE`	Type of the performed change (Created, Dropped, Updated).
`SQCH_DATA_CHANGED`	Name of the property that was changed.
`SQCH_OLD_VALUE`	Old value, before the change.
`SQCH_NEW_VALUE`	New value, after the change.
`SQCH_SAMPLE_DATE`	Sample time.

PW_SQEC_EXPLN_COLUMN

Holds information on the statement execution plan.

Column Name	Column Description
`SQEC_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQEC_DATABASE_NAME`	Name of the database in which the change occurred.
`SQEC_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.
`SQEC_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEC_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PW have the value.
`SQEC_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEC_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEC_OPERATOR_ID`	Sequence order of this operation in the access plan for a statement.
`SQEC_PREDICATE_ID`	Sequent of the predicate.
`SQEC_OBJ_DATABASE_NAME`	Database name of the object accessed in this operation.
`SQEC_OBJ_OWNER_NAME`	Owner of the object accessed in this operation.
`SQEC_OBJ_NAME`	Name of the object accessed in this operation.
`SQEC_OBJ_NAME_ALIAS`	Alias of the object accessed in this operation.
`SQEC_COLUMN_NAME`	Name of the column of the object that was changed.
`SQEC_USED_IN_SEEK`	Indicates whether the column in the specified operator is used in a seek action. The value can be `Y`/`N`.
`SQEC_LAST_EXPLAIN_IND`	Indicates that this operation belongs to the last explain of the batch.
`SQEC_UNION_ID`	The Union ID to which the column belongs (starting from 0) when the statement contains union.

PW_SQBX_BATCH_TEXT

Holds the text of batches.

Column Name	Column Description
`SQBX_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQBX_BATCH_TEXT`	The text of the batch.

PW_SQIF_IGNORE_FINDINGS

Holds the list of SmarTune findings that will not be displayed in the SmarTune workspace if the user marked them to be ignored.

Column Name	Column Description
`SQIF_STATEMENT_HV`	For the heavy collapsed statement, it contains the collapsed hash value.
`SQIF_DATABASE_ID`	For the heavy statement and heavy collapsed statement types, this is the database ID at which the statement was running, normalized at `PW_SQDN_DATABASE_NAMES_N`.
`SQIF_DATABASE_NAME`	For the heavy statement and heavy collapsed statement types, this is the database name on which the statement was running. For the heavy object finding type, it is the table's database name.
`SQIF_USER_ID`	One of the MS-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, normalized in table `PW_SQUN_USER_NAMES_N`.
`SQIF_USER_NAME`	For the heavy statement and heavy collapsed statements, this is the user that runs the statement. For the heavy object finding, this is the owner of the table.
`SQIF_FULL_OBJECT_ID`	For the heavy object finding, this is the Ignored table ID, normalized in table `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`SQIF_FINDING_TYPE`	The type of the finding: 1: Heavy Statement 2: Heavy Object 3: Heavy Collapsed Statement 4: Instance event
`SQIF_UI_USER_NAME`	This is the user (login) that asked the finding to be ignored.
`SQIF_INSTANCE_PROBLEM_ID`	For the Instance event finding, it contains the instance event ID.

PW_SQEJ_EXPLN_OPER_OBJECTS

Holds all the object operators per object.

Column Name	Column Description
`SQEJ_DATABASE_NAME`	Name of the database.
`SQEJ_PARSING_USER`	One of the MS-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.
`SQEJ_BATCH_HV`	Unique identifier (number) assigned to the batch. Only the first batch appears.
`SQEJ_WORKSHOP_HV`	Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB get this the value.
`SQEJ_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEJ_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEJ_OPERATOR_ID`	Sequence order of this operation in the access plan for a statement.
`SQEJ_OPERATOR_TYPE`	Physical operation in the access plan.
`SQEJ_OBJ_DATABASE_NAME`	Database name of the object accessed in this operation.
`SQEJ_OBJ_OWNER_NAME`	Owner of the object accessed in this operation.
`SQEJ_OBJ_NAME`	Name of the object accessed in this operation.
`SQEJ_OBJ_NAME_ALIAS`	Alias name of the object accessed in this operation.
`SQEJ_INDEX_NAME`	Name of the index accessed in this operation. Otherwise NULL.
`SQEJ_CONTRIBUTION_RATIO`	Contribution value of the object in this operation to the statement.
`SQEJ_MISS_INDEXES_IND`	Indicator if indexes are missing in this operation.

PW_SQPU_PARTITION_USAGE_D

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 `SQAM_PWHG_ID` should be used.
`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: `<db_name>,<table_owner>,<table_name>`. It is a normalized field which holds only a numeric hash value of the full table name. The normalization table is: `PW_SQKN_LOCKED_OBJECT_NAMES_N`.
`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.

PW_SQEE_EXPLN_ESTIMATED_COST

Contains overtime history of statement's estimated cost changes.

Column Name	Column Description
`SQEE_PWII_INSTANCE_ID`	ID of the MS-SQL Server instance.
`SQEE_DATABASE_NAME`	Name of the database.
`SQEE_PARSING_USER`	One of the MS-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.
`SQEE_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEE_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
`SQEE_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEE_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEE_ESTIMATE_COST`	Estimated cost of this operation.
`SQEE_ACTUAL_PLAN_IND`	An indicator if the execution plan is actual or estimated `PW_SQEA_EXPLN_ACCESS_PATH`.

PW_SQEA_EXPLN_ACCESS_PATH

Contains overtime history of statement's access path changes.

Column Name	Column Description
`SQEA_PWII_INSTANCE_ID`	ID of the MS-SQL Server instance.
`SQEA_DATABASE_NAME`	Name of the database.
`SQEA_PARSING_USER`	One of the MS-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.
`SQEA_BATCH_HV`	Unique identifier (number) assigned to the batch.
`SQEA_WORKSHOP_HV`	Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
`SQEA_STATEMENT_ID_IN_BATCH`	A statement number in the first batch sampled running the statement.
`SQEA_EXPLAIN_TIME`	Date and time the batch was explained and its access plan was changed.
`SQEA_ESTIMATE_COST`	Estimated cost of this operation.
`SQEA_ACTUAL_PLAN`	An indicator if the execution plan is actual or estimated.
`SQEA_ACCESS_PATH_HV`	Unique identifier (number) assigned to the access plan of the statement.
`SQEA_MISS_INDEXES_IMPACT`	The minimal possible impact of indexes that are missing for effective query execution.
`SQEA_EXPLAIN_OPER_USAGE`	This column contains a mask of operations that appeared in the execution plan.

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal

Content

Space Tools

Precise for SQL Server tables

PW_PWII_INSTANCE_ID

PW_SQDL_INST_DB_DEFINITION_LOG

PW_SQCL_SCHEMA_CHANGES_LOG

PW_SQID_SCHEMA_CHANGES_INST

PW_SQCO_SCHEMA_CHANGES_OBJECTS

PW_SQCK_SCHEMA_CHANGES_INDXKEY

PW_SQCI_SCHEMA_CHANGES_INDEXES

PW_SQCD_SCHEMA_CHANGES_DB

PW_SQCC_SCHEMA_CHANGES_COLUMNS

PW_SQRS_REPLIC_SNAP_STATS

PW_SQRM_REPLIC_MERGE_STATS

PW_SQRL_REPLIC_LOGREAD_STATS

PW_SQRD_REPLIC_DISTRIB_STATS

PW_SQRA_REPLIC_AGENT_STATS

PW_SQBP_BUFFER_PART_STATS

PW_SQBM_BF_CH_MANAGER_STATS_T

PW_SQBD_BACKUP_DEVICE_STATS_T

PW_SQAM_ACCESS_METHODS_STATS_T

PW_SQDD_DATABASES_STATS_T

PW_SQPS_SQL_STATISTIC_STATS_T

PW_SQLS_LOCKS_STATS_T

PW_SQPR_PROCESS_T

PW_SQPO_PROCESSOR_T

PW_SQPD_PHYSICAL_DISK_T

PW_SQXM_XP_MAPPING

PW_SQOU_OBJECTS_SPACE_USAGE_D

PW_SQDU_DBFILES_SPACE_USAGE_D

PW_SQDF_DBFILES_STATISTICS_D

PW_SQDB_DBFILES_SAMPLES

PW_SQAV_AVAILABILITY

PW_SQSC_STMT_CATALOG

PW_SQEO_EXPLN_OPER

PW_SQEH_EXPLN_HIST

PW_SQST_STATEMENTS_STATS_T

PW_SQSS_SESSIONS_STATS_T

PW_SQSE_SESSIONS_STMT_STATS_T

PW_SQNS_INSTANCE_STATS_T

PW_SQFA_FILE_ACTIVITY_STATS_T

PW_SQDS_DBFILES_STATS_T

PW_SQLA_LOCK_ACTIVITY_STATS_T

PW_SQLO_LOCK_OBJECT_STATS_T

PW_SQSM_STATEMENTS

PW_SQBA_BATCHES

PW_SQIN_INSTANCES

PW_SQCG_SCHEMA_CHANGES_GROUPS

PW_SQPC_PERFORMANCE_COUNTERS

PW_SQNK_NETWORK_T

PW_SQJS_JOBS_STATS_D

PW_SQJT_JOBS_STEPS_STATS_D

PW_SQCJ_MTNC_CHANGE_JOB

PW_SQCT_MTNC_CHANGE_STEP

PW_SQCH_MTNC_CHANGE_LOG

PW_SQEC_EXPLN_COLUMN

PW_SQBX_BATCH_TEXT

PW_SQIF_IGNORE_FINDINGS

PW_SQEJ_EXPLN_OPER_OBJECTS

PW_SQPU_PARTITION_USAGE_D

PW_SQCP_SCHEMA_CHANGES_PS

PW_SQCF_SCHEMA_CHANGES_PS_FG

PW_SQCN_SCHEMA_CHANGES_PF

PW_SQCV_SCHEMA_CHANGES_PF_VAL

PW_SQWI_WAIT_INFO

PW_SQWC_WAIT_COUNTERS_T

PW_SQOP_OBJECTS_PERFORMENCE_D

PW_SQEE_EXPLN_ESTIMATED_COST

PW_SQEA_EXPLN_ACCESS_PATH

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal