You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 42 Next »

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_ID ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column.
PWII_INSTANCE_NAMEName of the instance.
PWII_TECHNOLOGYTwo characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).
PWII_SERVERName 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 NameColumn Description
SQDL_PWII_INSTANCE_IDID of the SQL Server instance.
SQDL_DATABASE_NAMEName of the database in which the change occurred.
SQDL_OLD_VALUEOld value, before the change.
SQDL_NEW_VALUENew value, after the change.
SQDL_CHANGE_TYPEType of the performed change (Created, Dropped, Updated).
SQDL_DATA_CHANGEDProperty that was changed.
SQDL_SAMPLE_DATEDate 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 NameColumn Description
SQCL_PWIIID of the SQL Server instance.
SQCL_DATABASE_IDInternal ID of the database.
SQCL_OBJECT_IDID of the object, column, or index that was changed, depending on the type of the object that was changed.
SQCL_OBJECT_TYPEType of the object that was changed.
SQCL_OBJECT_NAMEName of the object that was changed.
SQCL_OBJECT_OWNEROwner of the object that was changed.
SQCL_PARENT_OBJECT_IDID 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_NAMEName 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_OWNEROwner 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_IDID of the index that was changed. Relevant only for index key changes.
SQCL_INDEX_NAMEName of the index that was changed. Relevant only for index key changes.
SQCL_OLD_VALUEOld value (before the change).
SQCL_NEW_VALUENew value (after the change).
SQCL_CHANGE_TYPEType of the performed change (Created, Dropped, Updated).
SQCL_DATA_CHANGEDName 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 NameColumn Description
SQID_PWII_INSTANCE_IDID of the SQL Server instance.
SQID_CONFIG_OPTION_IDID of the instance property, as appearing in sp_configure.
SQID_CONFIG_OPTION_NAMEName of the instance property, as appearing in sp_configure.
SQID_CONFIG_OPTION_VALUEValue 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 NameColumn Description
SQCO_PWII_INSTANCE_IDID of the SQL Server instance.
SQCO_DATABASE_IDInternal ID of the database.
SQCO_OBJECT_IDID of the object that was changed.
SQCO_NAMEName of the object that was changed.
SQCO_OWNEROwner of the object that was changed.
SQCO_TYPEType of the object that was changed. See sysobjects documentation for a list of all available types.
SQCO_CREATE_DATECreation date of the object.
SQCO_FILE_GROUPFile group in which the object resides. Relevant only for tables.
SQCO_NUM_OF_COLUMNNumber of columns in the object.
SQCO_EXEC_IS_ANSI_NULL_ONValue of the object’s Ansi Null property. Relevant only for stored objects.
SQCO_TABLE_HAS_INDEXTRUE if the table has an index, FALSE if the table does not have an indexes.
SQCO_TABLE_HAS_CLUSTERED_INDEXTRUE if the table has a clustered index, FALSE if the table does not have a clustered index.
SQCO_DELETE_TRIGGER_COUNTNumber of delete triggers on the table.
SQCO_INSERT_TRIGGER_COUNTNumber of insert triggers on the table.
SQCO_UPDATE_TRIGGER_COUNTNumber of update triggers on the table.
SQCO_NUM_OF_PARTITIONSNumber 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 NameColumn Description
SQCK_PWII_INSTANCE_IDID of the SQL Server instance.
SQCK_DATABASE_IDInternal ID of the database.
SQCK_OBJECT_IDID of the object on which the index is defined.
SQCK_INDEX_IDID of the index.
SQCK_COLUMN_IDID of the column.
SQCK_COLUMN_NAMEName of the column key.
SQCK_INDEX_NAMEName of the index.
SQCK_OBJECT_NAMEName of the table.
SQCK_OBJECT_OWNEROwner of the table.
SQCK_POSITIONPosition of the key in the index.
SQCK_ORDER_BYSorting 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 NameColumn Description
SQCI_PWII_INSTANCE_IDID of the SQL Server instance.
SQCI_DATABASE_IDInternal ID of the database.
SQCI_OBJECT_IDID of the object on which the index is defined.
SQCI_INDEX_IDID of the index.
SQCI_INDEX_NAMEName of the index.
SQCI_OBJECT_NAMEName of the table.
SQCI_OBJECT_OWNEROwner of the table.
SQCI_FILE_GROUPFile group in which the index resides.
SQCI_NUM_OF_KEYSNumber of keys in the index.
SQCI_FILL_FACTORFill factor of the index.
SQCI_IS_CLUSTERED_INDEXIndicates whether the index is clustered.
SQCI_IS_PAD_INDEXIndicates whether the index is padded.
SQCI_IS_UNIQUEIndicates whether the index is unique.
SQCI_INDEX_DEPTHIndex tree level.
SQCI_IS_AUTH_STATIndicates if the index has turned on the autostatistics.
SQCI_IS_PAGE_LOCK_DISALLOWEDIndicates whether an index page can be locked.
SQCI_IS_ROW_LOCK_DISALLOWEDIndicates 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 NameColumn Description
SQCD_PWII_INSTANCE_IDID of the SQL Server instance.
SQCD_DATABASE_IDInternal ID of the database.
SQCD_DATABASE_NAMEName of the database in which the change occurred.
SQCD_RECOVERYRecovery model of the database.
SQCD_AUTO_UPDATE_STATISTICSAuto-update statistics status of the database.
SQCD_ANSI_NULLAnsi null status of the database.
SQCD_AUTO_SHRINK_FILESAutoshrink files status of the database.
SQCD_CLOSE_CURSORS_ON_COMMITClose cursor on commit status of the database.
SQCD_STATUSAvailability status of the database.
SQCD_AUTOCREATES_STATISTICSAutocreate statistics status of the database.
SQCD_TRUNCATES_LOGTruncate log status of the database.
SQCD_COMPATIBILITY_LEVELCompatibility level of the database.
SQCD_OBJECT_SAMPLE_STATUSStatus of tracking changes on objects in the database.
SQCD_COLUMN_SAMPLE_STATUSStatus of tracking changes on columns in the database.
SQCD_INDEX_SAMPLE_STATUSStatus of tracking changes on indexes in the database.
SQCD_INDEX_K_SAMPLE_STATUSStatus of tracking changes on keys in the database.
SQCD_DATABASES_SAMPLE_STATUSStatus of tracking changes on database definitions in the database.
SQCD_PS_SAMPLE_STATUSTo support partition schema collecting.
SQCD_PS_FG_SAMPLE_STATUSTo support file group collecting pointed by partition schema.
SQCD_PF_SAMPLE_STATUSTo support partition function collecting.
SQCD_PF_VALUES_SAMPLE_STATUSTo support partition function values collecting of a particular partition function.
SQCD_AUTO_UPDATE_STATSDatabase option.
SQCD_PARAMS_FORCEDDatabase option.
SQCD_DATE_CORRELATIONDatabase 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 NameColumn Description
SQCC_PWII_INSTANCE_IDID of the SQL Server instance.
SQCC_DATABASE_IDInternal ID of the database.
SQCC_OBJECT_IDID of the object to which the column belongs.
SQCC_COLUMN_IDID of the column.
SQCC_COLUMN_NUMBERNumber of the subprocedure when the procedure is grouped (0 for nonprocedure objects).
SQCC_COLUMN_NAMEName of the column.
SQCC_OBJECT_NAMEName of the object.
SQCC_OBJECT_OWNEROwner of the object.
SQCC_TYPEType of the column.
SQCC_LENGTHLength of the column.
SQCC_SCALEScale of the column.
SQCC_PRECISIONPrecision of the column.
SQCC_IS_NULL_ABLENullable property of the column.
SQCC_IS_TABLEIndicates 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 NameColumn Description
SQRS_PWII_INSTANCE_IDID of the SQL Server instance.
SQRS_INSTANCE_NAMEName 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_IDHour group ID.
SQRS_SNAP_DELIVERED_CMDS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRS_SNAP_DELIVERED_TRANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRS_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQRS_ROWIDUnique 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 NameColumn Description
SQRM_PWII_INSTANCE_IDID of the SQL Server instance.
SQRM_INSTANCE_NAMEName 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_IDHour group ID.
SQRM_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQRM_CONFLICTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRM_DOWNLOADED_CHANGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRM_UPLOADED_CHANGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRM_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQRM_ROWIDUnique 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 NameColumn Description
SQRL_PWII_INSTANCE_IDID of the SQL Server instance.
SQRL_INSTANCE_NAMEName 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_IDHour group ID.
SQRL_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQRL_LOG_DELIVERED_CMDS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRL_LOG_DELIVERED_TRANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRL_LOG_DELIVERY_LATENCY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRL_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQRL_ROWIDUnique 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 NameColumn Description
SQRD_PWII_INSTANCE_IDID of the SQL Server instance.
SQRD_INSTANCE_NAMEName 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_IDHour group ID.
SQRD_DIST_DELIVERED_CMDS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRD_DIST_DELIVERED_TRANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRD_DIST_DELIVERY_LATENCY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRD_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQRD_ROWIDUnique 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 NameColumn Description
SQRA_PWII_INSTANCE_IDID 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_IDHour group ID.
SQRA_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQRA_DISTRIBUTION_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRA__LOGREADER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRA_MERGE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRA_QUEUEREADER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRA_SNAPSHOT_TIMESTAMPFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQRA_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQRA_ROWIDUnique 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 NameColumn Description
SQBP_PWII_INSTANCE_IDID of the SQL Server instance.
SQBP_INSTANCE_NAMEName 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_IDHour group ID.
SQBP_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQBP_FREE_LIST_EMPTY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBP_FREE_LIST_REQUESTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBP_FREE_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBP_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQBP_ROWIDUnique 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 NameColumn Description
SQBM_PWII_INSTANCE_IDID 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_IDHour group ID.
SQBM_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQBM_AWE_LOOKUP_MAPS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_AWE_STOLEN_MAPS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_AWE_UNMAP_CALL_AWGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_AWE_UNMAP_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_AWE_WRITE_MAPS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_BUFFER_HIT_RATIO_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CHECKPOINT_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_DATABASE_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_FREE_LIST_STALL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_FREE_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_FREE_PAGES_MINFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_LAZY_WRITES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_PAGE_LIFE_EXPECTANCY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_PAGE_LOOKUPS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_PAGE_READS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_PAGE_WRITES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_PROCEDURES_CACHE_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_READAHEAD_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_RESERVED_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_STOLEN_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_TARGET_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_TOTAL_PAGES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_AD_HOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_CURSORS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_CONTEXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_N_TREE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_PREPARE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_RP_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_TRIGGER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_TOTAL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_AD_HOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_CURSORS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_CONTEXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_N_TREE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_PREPARE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_PREPARE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_RP_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_TRIGGER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_TOTAL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_AD_HOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_CURSORS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_CONTEXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_N_TREE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_PREPARE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_RP_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_TRIGGER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_TOTAL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_AD_HOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_CURSORS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_CONTEXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_N_TREE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_PREPARE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_RP_PROC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_TRIGGER_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_TOTAL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQBM_ROWIDUnique row number.
SQBM_CACHE_HIT_SQL_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_OBJ_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_BND_TRE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_EXT_SP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_HIT_TMP_TAB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_SQL_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_OBJ_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_BND_TRE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_EXT_SP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_TMP_TAB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_SQL_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_OBJ_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_BND_TRE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_EXT_SP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_TMP_TAB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_SQL_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_OBJ_PLN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_BND_TRE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_EXT_SP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBM_CACHE_USE_TMP_TAB_AVGFor 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 NameColumn Description
SQBD_PWII_INSTANCE_IDID of the SQL Server instance.
SQBD_INSTANCE_NAMEName 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_IDHour group ID.
SQBD_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQBD_DEVICE_THROUGHPUT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBD_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQBD_ROWIDUnique row number.
SQBD_READ_IO_WAITFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBD_WRITE_IO_WAITFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQBD_FILE_NAMEFor 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 NameColumn Description
SQAM_PWII_INSTANCE_IDID 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_IDHour group ID.
SQAM_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQAM_EXTENT_DEALLOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_EXTENT_ALLOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FORWARDED_RECORDS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FREESPACE_PAG_FETCH_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FREESPACE_SCANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FULL_SCANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_INDEX_SEARCHES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MIXED_PAGE_ALLOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_PAGE_DEALLOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_PAGE_SPLITS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_PAGES_ALLOC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_PROBE_SCANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_RANGE_SCANS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_SCAN_POINT_REVALID_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_SKIPP_GHOSTED_RECORD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_TABLE_LOCK_ESCALATION_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_WORKFILES_CREATED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_WORKTABLES_CREATED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_WORKTABLES_CREATED_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_WORKTABLE_CACHE_HIT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_CONNECTION_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_GRANTED_WS_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_BLOCK_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_BLOCK_ALLO_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_MEMORY_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_OWN_BLOCK_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_LOCK_OWN_BLOCK_ALC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_MAX_WS_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_MEMORY_GRANT_OUT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_MEMORY_GRANT_PEND_AVGFor 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_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_TARGET_SRV_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_TOTAL_SRV_MEMORY_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_MM_TOTAL_SRV_MEMORY_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQAM_ROWIDUnique row number.
SQAM_AU_CLEANUP_BATCHES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_AU_CLEANUP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_COUNT_PULL_IN_ROW_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_COUNT_PUSH_OFF_ROW_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_DEFERRED_DROP_AUS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_DEFERRED_DROP_ROWSETS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_DROP_ROWSET_CLEANUPS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_DROP_ROWSET_SKIPPED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FAIL_AU_CLEANUP_BATCH_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FAIL_LEAF_PAGE_COOKIE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_FAIL_TREE_PAGE_COOKIE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_USED_LEAF_PAGE_COOKIE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQAM_USED_TREE_PAGE_COOKIE_AVGFor 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 NameColumn Description
SQDD_PWII_INSTANCE_IDID of the SQL Server instance.
SQDD_INSTANCE_NAMEName 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_IDHour group ID.
SQDD_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQDD_ACTIVE_TRANSACTIONS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_BACKUP_RES_THROUGHPUT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_BULK_COPY_ROWS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_BULK_COPY_THROUGHPUT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_DATA_FILE_SIZE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_DBCC_LOGICAL_SCAN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_BYTES_FLUSHED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_CACHE_HIT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_CACHE_READS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FILE_SIZE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FILE_SIZE_USED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FLUSH_WAIT_TIME_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FLUSH_WAIT_TIME_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FLUSH_WAITS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_FLUSHES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_GROWTHS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_SHRINKS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_LOG_TRUNCATIONS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_PERCENT_LOG_USED_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_REPL_PENDING_XACTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_REPL_TRANS_RATE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_SHRINK_DATA_MOVEMENT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_TRANSACTIONS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_TRANSACTIONS_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQDD_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQDD_ROWIDUnique 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 NameColumn Description
SQPS_PWII_INSTANCE_IDID 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_IDHour group ID.
SQPS_MINUTES_COUNT_SUMThe timeframe needed to calculate the row, in minutes.
SQPS_AUTO_PARAM_ATTEMPTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_BATCH-REQUESTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_BATCH_REQUESTS_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_FAILED_AUTO_PARAMS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_SAFE_AUTOPARAMS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_SQL_COMPILE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_SQL_RE_COMPILE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_SAFE_UNSAFE_AUTO_PARAM_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GENERAL_STAT_LOGINS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GENERAL_STAT_LOGINS_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GENERAL_STAT_LOGOUTS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GENERAL_STAT_USR_CONN_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GENERAL_STAT_USR_CONN_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT1_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT2_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT3_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT4_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT5_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT6_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT7_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT8_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT9_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_USER_SETTABLE_CNT10_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQPS_ROWIDUnique row number.
SQPS_GNRL_ACTIVE_TEMP_TAB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_LOGICAL_CON_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_MARS_DEADLOCKS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_NATOM_YIELD_RATE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_PROC_BLOCK_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_TMP_TAB_CRT_RATE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_TMP_DSTRUCT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_GNRL_TRANSACTIONS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_ETIME_DSTR_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_ETIME_DTC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_ETIME_EXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_ETIME_OLE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_INPROG_DSTR_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_STAT_E_INPROG_DSTR_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_INPROG_DTC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_INPROG_EXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_INPROG_OLE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_PERSEC_DSTR_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_PERSEC_DTC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_PERSEC_EXT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_EX_STAT_E_PERSEC_OLE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_FORCED_PARM_SEC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_TRANS_VER_CLNUP_RATE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_TRANS_VER_GNRT_RATE_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPS_TRANS_VER_STORE_SIZE_AVGFor 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 NameColumn Description
SQLS_PWII_INSTANCE_IDID 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_IDHour group ID.
SQLS_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQLS_AVG_WAIT_TM_HIT_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_TL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_TL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_TL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_TL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_D_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_E_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_K_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_P_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_R_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_T_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_TL_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_LATCH_WAIT_HIT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_LATCH_WAIT_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_TOTAL_LATCH_WAIT_TIME_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQLS_ROWIDUnique row number.
SQLS_AVG_WAIT_TM_HIT_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_AVG_WAIT_TM_HIT_OB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_REQUESTS_OB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_TIMEOUTS_OB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAIT_TIME_OB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_LOCK_WAITS_OB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_AU_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_AP_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_FI_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_HB_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_MD_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQLS_NUMBER_OF_DEADLOCK_OB_AVGFor 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 NameColumn Description
SQPR_PWII_INSTANCE_IDID 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_IDHour group ID.
SQPR_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQPR_PRCT_PROCESSOR_TIME_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPR_PRCT_PROCESSOR_TIME_MAXFor 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_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPR_PAGE_READS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPR_PAGE_WRITES_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPR_PAGES_AVGFor 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_MINLike the previous counter, but it is the minimum value after doing the summary process.
SQPR_SERVER_PHYS_MEMORY_MAXTotal 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_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQPR_ROWIDUnique 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 NameColumn Description
SQPO_PWII_INSTANCE_IDID of the SQL Server instance.
SQPO_INSTANCE_NAMENumber 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_IDHour group ID.
SQPO_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQPO_PRCT_PROCESSOR_TIME_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPO_PRCT_PROCESSOR_TIME_MAXFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPO_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQPO_ROWIDUnique 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 NameColumn Description
SQPD_PWII_INSTANCE_IDID of the SQL Server instance.
SQPD_INSTANCE_NAMEIdentifier 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_IDHour group ID.
SQPD_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQPD_AVG_DISK_QUEUE_LENGTH_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPD_DISK_READS_PER_SEC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPD_DISK_WRITES_PER_SEC_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPD_DISK_SEC_READS_AVGFor more information, search for "performance counters" on http://msdn.microsoft.com.
SQPD_DISK_SEC_WRITES_AVGThe average time in seconds it took to write data to the disk.
SQPD_DISK_SEC_TRANSFER_AVGThe average time in seconds of the average disk transfer.
SQPD_DISK_TRANSFER_PER_SEC_AVGThe average number of disk transfers per second.
SQPD_DISK_SPLIT_IO_PER_SEC_AVGThe 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_AVGThe average percentage of elapsed time that the selected disk drive is busy servicing read requests.
SQPD_PRCT_DISK_WRITE_TIME_AVGThe average percentage of elapsed time that the selected disk drive is busy servicing write requests.
SQPD_PRCT_IDLE_TIME_AVGThe average percentage of time during the sample interval that the disk was idle.
SQPD_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQPD_ROWIDUnique row number.

PW_SQXM_XP_MAPPING

Holds mapping disks of HP or HDS systems.

Column NameColumn Description
SQXM_PWII_INSTANCE_IDID of the SQL Server instance.
SQXM_PHYSICAL_DISKPhysical disk number.
SQXM_DEVICE_NAMEName of the device.
SQXM_ARRAY_IDID of the array.
SQXM_CONTROL_UNITControl unit identifier.
SQXM_LDEV_IDID of the logical device.
SQXM_RAID_GROUPName of the raid group.
SQXM_CHP_IDIdentification number of the Client Host Interface Processor Port of the logical device.
SQXM_ACP_PAIR_IDIdentification number of the Array Control Processor Pair of the logical device.
SQXM_URLVendor-specific performance URL.

PW_SQOU_OBJECTS_SPACE_USAGE_D

Holds statistics on objects space. By default, this process runs every 24 hours.

Column NameColumn Description
SQOU_PWII_INSTANCE_IDID of the SQL Server instance.
SQOU_DATABASE_IDName of the database, normalized in table PW_SQDN_DATABASE_NAMES_N.
SQOU_OBJECT_IDID of the table.
SQOU_FULL_OBJECT_IDThe full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N.
SQOU_INDEX_IDID 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_IDHour group ID.
SQOU_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQOU_O_ALL_ALLOC_MAXNumber of pages allocated to the object.
SQOU_O_ALL_USED_MAXNumber of pages used by the object.
SQOU_O_TEXT_ALLOC_MAXNumber of text pages allocated to the object.
SQOU_O_TEXT_USED_MAXNumber of text pages used by the object.
SQOU_O_DATA_USED_MAXNumber of data pages used by the objects.
SQOU_O_INDEX_ALLOC_MAXNumber of pages allocated to the indexes of the object.
SQOU_O_INDEX_USED_MAXNumber of pages used by the indexes of the object.
SQOU_ROW_COUNT_MAXNumber of rows the object has.
SQOU_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQOU_ROWIDUnique row number.
SQOU_SYSTEM_SEEKS_SUMNumber of system seeks per one object.
SQOU_SYSTEM_SCANS_SUMNumber of system scans per one object.
SQOU_SYSTEM_LOOKUPS_SUMNumber of system lookups per one object.
SQOU_SYSTEM_UPDATES_SUMNumber of system updates per one object.
SQOU_USER_SEEKS_SUMNumber of user seeks per one object.
SQOU_USER_SCANS_SUMNumber of user scans per one object.
SQOU_USER_LOOKUPS_SUMNumber of user lookups per one object.
SQOU_USER_UPDATES_SUMNumber 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 NameColumn Description
SQDU_PWII_INSTANCE_IDID of the SQL Server instance.
SQDU_DATABASE_NAMEID of the database, normalized in table PW_SQDN_DATABASE_NAMES_N.
SQDU_FILE_IDID of the file in the database.
SQDU_FILE_NAME_IDThe internal file ID, normalize in table PW_SQDN_FILE_NAMES_N.
SQDU_FILE_GROUP_IDID of the file group in the database.
SQDU_FILE_GROUP_NAME_IDThe 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_IDHour group ID.
SQDU_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQDU_FILE_SIZE_MAXMaximum file size in MB.
SQDU_SPACE_USED_MAXNumber of MB bytes used in the files.
SQDU_MAX_SIZE_MAXMaximum growth of the file.
SQDU_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQDU_ROWIDUnique row number.

PW_SQDF_DBFILES_STATISTICS_D

Holds information on I/O performance and load of the SQL Server datafiles.

Column NameColumn Description
SQDF_PWII_INSTANCE_IDID of the SQL Server instance.
SQDF_DATABASE_NAMEName of the database.
SQDF_FILE_IDID 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_IDHour group ID.
SQDF_READS_NUMBER_SUMNumber of read requests for the file.
SQDF_WRITES_NUMBER_SUMNumber of writes requests for the file.
SQDF_READS_BYTES_SUMNumber of bytes read from the file.
SQDF_WRITTEN_BYTES_SUMNumber of bytes written to the file.
SQDF_IO_WAIT_SUMI/O wait duration of the file.
SQDF_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQDF_ROWIDUnique row number.
SQDF_READ_IO_WAIT_SUMTime of read I/O wait on files.
SQDF_WRITE_IO_WAIT_SUMTime of write I/O wait on files.
SQDF_LOGICAL_FILE_IDID 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 NameColumn Description
SQDB_PWII_INSTANCE_IDID of the SQL Server instance.
SQDB_DATABASE_NAMEName of the database.
SQDB_FILE_IDID of the file in the database.
SQDB_SAMPLE_NUMBERSample 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_NUMBERNumber of read requests for the file.
SQDB_WRITES_NUMBERNumber of write requests for the file.
SQDB_READS_BYTESNumber of bytes read from the file.
SQDB_WRITTEN_BYTESNumber of bytes writes to the file.
SQDB_IO_WAITI/O wait duration of the file.

PW_SQAV_AVAILABILITY

Holds information on the status of the databases and the SQL Server instance.

Column NameColumn Description
SQAV_PWII_INSTANCE_IDID of the SQL Server instance.
SQAV_DATABASE_NAMEName of the database. Null in case of an instance record.
SQAV_STATUSStatus of the database or the instance.
SQAV_FROM_TIMEDate and time the status was changed to the status field.
SQAV_TO_TIMEDate and time the status was changed from the status field

PW_SQSC_STMT_CATALOG

Holds information on statements in the Statement Workshop.

Column NameColumn Description
SQSC_PWII_INSTANCE_IDID of the SQL Server instance.
SQSC_CABINETName of the cabinet in which the statement is stored.
SQSC_FOLDERName of the folder within the cabinet.
SQSC_STATEMENT_IDUnique 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 NameColumn Description
SQEO_PWII_INSTANCE_IDID of the SQL Server instance.
SQEO_DATABASE_NAMEName 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_HVUnique 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_TIMEDate and time the batch was explained and its access plan was changed.
SQEO_STATEMENT_ID_IN_BATCHA statement number in the first batch sampled running the statement.
SQEO_OPERATOR_IDSequence order of this operation in the access plan for a statement.
SQEO_OPERATOR_TYPEPhysical operation in the access plan.
SQEO_OPTIONSLogical operation in the access plan.
SQEO_EXECUTION_ORDERSequence order of this operation in the whole access plan.
SQEO_TREE_LEVELTree level of this operation in the access plan.
SQEO_ARGUMENTS_LISTNot in use.
SQEO_REMOTE_STATEMENT_HVUnique identifier (number) for the remote query used in this operation.
SQEO_OBJ_DATABASE_NAMEDatabase name of the object accessed in this operation.
SQEO_OBJ_OWNER_NAMEOwner of the object accessed in this operation.
SQEO_OBJ_NAMEName of the object accessed in this operation.
SQEO_INDEX_NAMEName of the index accessed in this operation. Otherwise NULL.
SQEO_TOTAL_SUBTREE_COSTEstimated cost of this operation and its descendants.
SQEO_CONTRIBUTION_RATIOContribution value of the object in this operation to the statement.
SQEO_ESTIMATE_COSTEstimated cost of this operation.
SQEO_ESTIMATE_IO_COSTEstimated I/O cost of this operation.
SQEO_ESTIMATE_CPU_COSTEstimated CPU cost of this operation.
SQEO_ESTIMATE_ROWSEstimated number of rows returned by this operation.
SQEO_WARNINGSWarnings in this operation.
SQEO_PARALLEL_INDIndicates if the operation is performed in parallel.
SQEO_ESTIMATE_EXECUTIONEstimated number of times this operation is performed.
SQEO_LAST_EXPLAIN_INDIndicates that this operation belongs to the last explain of the batch.
SQEO_AVG_ROW_SIZEAverage 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 NameColumn Description
SQEH_PWII_INSTANCE_IDID of the SQL Server instance.
SQEH_DATABASE_NAMEDatabase 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_HVUnique 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_TIMEDate and time the batch was explained and its access plan was changed.
SQEH_TOTAL_ESTIMATE_COSTEstimated cost of the batch.
SQEH_TOTAL_ESTIMATE_IO_COSTEstimated I/O cost of the batch.
SQEH_TOTAL_ESTIMATE_CPU_COSTEstimated CPU cost of the batch.
SQEH_TOTAL_ESTIMATE_ROWSEstimated number of rows returned by the batch. Only rows from SELECT statements are calculated.
SQEH_LAST_EXPLAIN_INDIndicates that this access plan is the last access plan of the batch.
SQEH_ACTUAL_PLAN_INDAn 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 NameColumn Description
SQST_PWII_INSTANCE_IDID 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_IDHour group ID.
SQST_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQST_DATABASE_IDDatabase 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_HVUnique identifier (number) assigned to the batch.
SQST_STATEMENT_HVUnique identifier (number) assigned to the statement.
SQST_COLLAPSED_BATCH_HVUnique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form).
SQST_COLLAPSED_STATEMENT_HVUnique identifier (number) assigned to the statement in its collapsed form.
SQST_TOTAL_INMSSQL_TIME_SUMIndicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
SQST_NUM_ENDED_EXECUTIONS_SUMNumber of statement executions which ended during the row's timeframe.
SQST_NUM_EXECUTIONS_NOT_ENDEDNumber of statement executions which were still running at the end of the row's timeframe
SQST_TOTAL_DURATION_SUMTotal amount of time SQL Server spent executing this statement.
SQST_REQUEST_WAIT_SUMNot in use in this table.
SQST_CPU_SUMAmount of time the process was actively executing a statement.
SQST_LOCK_WAIT_SUMAmount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
SQST_IO_WAIT_SUMAmount of time the process was waiting for I/O operations to terminate.
SQST_REMOTE_WAIT_SUMAmount 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_SUMAmount of time the process was waiting for an internal resource to be freed.
SQST_NET_IO_SUMAmount of time the process was waiting for the client process to acknowledge data sent to it.
SQST_PARALLEL_EXCHANGE_SUMAmount of time the thread in a parallel session is waiting for data exchange from another thread.
SQST_STAT_CPU_SUMStatistics summing the amount of the process’s read memory usage.
SQST_STAT_PHYSICAL_IO_SUMNumber of physical disk reads and writes for the process.
SQST_STAT_MEM_USAGE_MAXNumber of pages in the procedure cache allocated to the process.
SQST_STAT_OPEN_TRANS_MAXNumber 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_SUMAmount of time the process was waiting to acquire a lock on a row.
SQST_LOCK_KEY_SUMAmount of time the process was waiting to acquire a lock on an index key or an index key range.
SQST_LOCK_PAGE_SUMAmount of time the process was waiting to acquire a lock on a table or index page.
SQST_LOCK_TABLE_SUMAmount of time the process was waiting to acquire a lock on a table.
SQST_COMPILE_LOCK_SUMAmount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure.
SQST_OTHER_LOCK_SUMAmount of time the process was waiting to acquire a lock on a process that is unrecognized by Precise for SQL Server.
SQST_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQST_SLA_RED_SUMNumber 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_SUMNumber 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_SUMNumber 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_ROWIDUnique row number.
SQST_NET_IO_WAIT_SUMGroups all I/O related wait types.
SQST_TEMP_DB_WAIT_SUMGroups I/O / Latch on TempDB pages.
SQST_IDLE_WAIT_SUMThis group includes the events indicating that a session is waiting for something other than a user request.
SQST_INTRNL_BP_WAIT_SUMThis state groups the events, which all mean contention on pages in the buffer pool.
SQST_INTRNL_LATCH_WAIT_SUMThis group includes all Latch related wait types.
SQST_INTRNL_PARALLEL_WAIT_SUMAmount of time the process was waiting for one of its sub-threads to complete its operation.
SQST_INTRNL_DTC_WAIT_SUMAggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQST_INTRNL_DBMIRROR_WAIT_SUMAggregates a couple of new waits that occur when DB Mirroring is used.
SQST_INTRNL_PROFILER_WAIT_SUMAggregates a number of states associated with the Profiler.
SQST_INTRNL_MEMORY_WAIT_SUMIncludes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQST_INTRNL_BACKUP_WAIT_SUMIncludes write-ups commonly occurring when a session is doing a BACKUP command.
SQST_INTRNL_OTHER_WAIT_SUMThis aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
SQST_LOCK_MD_STAT_SUMAggregates lock waits of the MetaData Statistics type.
SQST_LOCK_MD_PART_SUMAggregates lock waits of the MetaData Partition Function type.
SQST_LOCK_MD_OTHER_SUMAggregates lock waits of other MetaData types.
SQST_PC_RECOMPILATIONS_SUMNumber of times this plan has been recompiled while it has remained in the cache.
SQST_PC_CACHE_EVICTIONS_SUMNumber of times the plan has been evicted from the cache.
SQST_PC_EXECUTION_COUNT_SUMNumber of times that the plan has been executed.
SQST_PC_TOTAL_WORKER_TIME_SUMAmount of CPU time that was consumed by executions of this plan.
SQST_PC_PHYSICAL_READS_SUMNumber of physical reads performed by executions of this plan.
SQST_PC_LOGICAL_READS_SUMNumber of logical reads performed by executions of this plan.
SQST_PC_LOGICAL_WRITES_SUMNumber of logical writes performed by executions of this plan.
SQST_PC_CLR_TIME_SUMTime consumed inside CLR objects by executions of this plan.
SQST_PC_ELAPSED_TIME_SUMTotal 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 NameColumn Description
SQSS_PWII_INSTANCE_IDID 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_IDHour group ID.
SQSS_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQSS_PROGRAM_IDID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N.
SQSS_DATABASE_IDID 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_IDThe ID of the client workstation, normalized in table PW_SQMN_MACHINE_NAMES_N.
SQSS_WORK_TYPEType of session, such as batch, dialog, queue. Used only in ERP components.
SQSS_ERP_IDENTIFIER1_IDID of the ERP entity, normalized in table PW_SQE1_ERP_IDENTIFIERS1_N.
SQSS_ERP_IDENTIFIER2_IDID of the ERP entity, normalized in table PW_SQE2_ERP_IDENTIFIERS2_N.
SQSS_ERP_IDENTIFIER3_IDID of the ERP entity, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N.
SQSS_ERP_IDENTIFIER4_IDID of the ERP entity, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N.
SQSS_TOTAL_INMSSQL_TIME_SUMTotal amount of time SQL Server was actively executing queries. It is also the sum of the columns.
SQSS_TOTAL_DURATION_SUMTotal amount of time SQL Server spent executing this session.
SQSS_REQUEST_WAIT_SUMAmount of time the process was waiting for the client to issue a statement.
SQSS_CPU_SUMAmount of time the process was actively executing a statement.
SQSS_LOCK_WAIT_SUMAmount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
SQSS_IO_WAIT_SUMAmount of time the process was waiting for I/O operations to terminate.
SQSS_REMOTE_WAIT_SUMAmount 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_SUMAmount of time the process was waiting to synchronize with another process.
SQSS_INTERNAL_WAIT_SUMAmount of time the process was waiting for an internal resource to be freed.
SQSS_NET_IO_SUMAmount of time the process was waiting for the client process to acknowledge data sent to it.
SQSS_PARALLEL_WAIT_SUMAmount of time the process was waiting for one of its sub-threads to complete its operation.
SQSS_INTERNAL_LOCK_SUMAmount of time the process was waiting for an internal lock to be released.
SQSS_WAITFOR_COMMAND_SUMAmount of time the process was executing the WAITFOR DELAY command.
SQSS_PARALLEL_EXCHANGE_SUMAmount of time the thread in a parallel session is waiting for data exchange from another thread.
SQSS_NUM_OF_ENDED_SESSIONSNumber of sessions, which ended during the row's timeframe.
SQSS_NUM_OF_SESSIONS_NOT_ENDEDNumber of sessions, which were still open at the end of the row's timeframe.
SQSS_NUM_ENDED_EXECUTIONS_SUMNumber of statement executions, which ended during the row's timeframe.
SQSS_NUM_EXECUTIONS_NOT_ENDEDNumber of statement executions, which were still running at the end of the row's timeframe.
SQSS_STAT_CPU_SUMStatistics summing the amount of the process's read memory usage.
SQSS_STAT_PHYSICAL_IO_SUMNumber of physical disk reads and writes for the process.
SQSS_STAT_MEM_USAGE_MAXNumber of pages in the procedure cache allocated to the process.
SQSS_STAT_OPEN_TRANS_MAXNumber of transactions the process opened.
SQSS_RECEIVED_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQSS_LOCKED_ROW_SUMAmount of time the process was waiting to acquire a lock on a row.
SQSS_LOCKED_KEY_SUMAmount of time the process was waiting to acquire a lock on an index key or an index key range.
SQSS_LOCKED_PAGE_SUMAmount of time the process was waiting to acquire a lock on a table or index page.
SQSS_LOCKED_TABLE_SUMAmount of time the process was waiting to acquire a lock on a table.
SQSS_OTHER_LOCK_SUMAmount of time the process was waiting to acquire a lock that is unrecognized by Precise for SQL Server.
SQSS_SLA_RED_SUMNumber 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_SUMNumber 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_SUMNumber 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_ROWIDUnique row number.
SQSS_TOTAL_INMSSQL_SUMIndicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns.
SQSS_TOTAL_DURATION_SUMTotal amount of time SQL Server spent executing this statement.
SQSS_REQUEST_WAIT_SUMNot in use in this table.
SQSS_USING_CPU_SUMTotal time of CPU use.
SQSS_LOCK_WAIT_SUMAmount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
SQSS_IO_WAIT_SUMAmount of time the process was waiting for I/O operations to terminate.
SQSS_REMOTE_WAIT_SUMAmount of time the process was waiting for a remote query to terminate.
SQSS_LOCK_MD_OTHER_SUMTotal time that session waited on Meta Data Lock type.
SQSS_SLA_RED_SUMNumber 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_SUMNumber 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_SUMNumber 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_SUMNumber of times this plan has been recompiled while it has remained in the cache.
SQSS_PC_CACHE_EVICTIONS_SUMNumber of times the plan has been evicted from the cache.
SQSS_PC_EVICTION_COUNT_SUMNumber of times that the plan has been executed.
SQSS_PC_TOTAL_WORKER_TIME_SUMAmount of CPU time that was consumed by executions of this plan.
SQSS_PC_PHYSICAL_READS_SUMNumber of physical reads performed by executions of this plan.
SQSS_PC_LOGICAL_READS_SUMNumber of logical reads performed by executions of this plan.
SQSS_PC_LOGICAL_WRITES_SUMNumber of logical writes performed by executions of this plan.
SQSS_PC_CLR_TIME_SUMTime consumed inside CLR objects by executions of this plan.
SQSS_PC_ELAPSED_TIME_SUMTotal 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 NameColumn Description
SQSE_PWII_INSTANCE_IDID of the SQL Server instance.
SQSE_TIMESTAMPDate 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_IDHour group ID.
SQSE_MINUTES_COUNT_SUMThe timeframe needed to calculated the row, in minutes.
SQSE_PROGRAM_IDID of the application program, normalized in table PW_SQPN_PROGRAM_NAMES_N.
SQSE_DATABASE_IDThe 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_IDThe ID of the client workstation, normalized in table PW_SQMN_MACHINE_NAMES_N.
SQSE_WORK_TYPEType of session, such as batch, dialog, queue. Used only in ERP components.
SQSE_ERP_IDENTIFIER1_IDID of the ERP entity, normalized in table PW_SQE1_ERP_IDENTIFIERS1_N.
SQSE_ERP_IDENTIFIER2_IDID of the ERP entity, normalized in table PW_SQE2_ERP_IDENTIFIERS2_N.
SQSE_ERP_IDENTIFIER3_IDID of the ERP entity, normalized in table PW_SQE3_ERP_IDENTIFIERS3_N.
SQSE_ERP_IDENTIFIER4_IDID of the ERP entity, normalized in table PW_SQE4_ERP_IDENTIFIERS4_N.
SQSE_BATCH_HVUnique identifier (number) assigned to the batch.
SQSE_STATEMENT_HVUnique identifier (number) assigned to the statement.
SQSE_COLLAPSED_BATCH_HVUnique identifier (number) assigned to the batch.
SQSE_COLLAPSED_STATEMENT_HVUnique identifier (number) assigned to the batch in its collapsed form.
SQSE_TOTAL_INMSSQL_SUMTotal amount of time SQL Server was actively executing queries. It is also the sum of the columns.
SQSE_TOTAL_DURATION_SUMTotal amount of time SQL Server spent executing this statement.
SQSE_REQUEST_WAIT_SUMAmount of time the process was waiting for the client to issue a statement.
SQSE_CPU_SUMAmount of time the process was actively executing a statement.
SQSE_LOCK_WAIT_SUMAmount of time the process was waiting for locks held by other processes to be released. All types of locks are counted.
SQSE_IO_WAIT_SUMAmount of time the process was waiting for I/O operations to terminate.
SQSE_REMOTE_WAIT_SUMAmount of time the process was waiting for a remote query to terminate.
SQSE_LOG_WAIT_SUMAmount 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_SUMAmount of time the process was waiting for an internal resource to be freed.
SQSE_NET_IO_SUMAmount of time the process was waiting for the client process to acknowledge data sent to it.
SQSE_PARALLEL_EXCHANGE_SUMAmount of time the thread in a parallel session is waiting for data exchange from another thread.
SQSE_NUM_ENDED_EXECUTIONS_SUMNumber of statement executions, which ended during the row's timeframe.
SQSE_NUM_EXECUTIONS_NOT_ENDEDNumber of statement executions, which were still running at the end of the row's timeframe.
SQSE_STAT_CPU_SUMStatistics summing the amount of the process’s read memory usage.
SQSE_STAT_PHYSICAL_IO_SUMNumber of physical disk reads and writes for the process.
SQSE_STAT_MEM_USAGE_MAXNumber of pages in the procedure cache allocated to the process.
SQSE_STAT_OPEN_TRANS_MAXNumber of transaction the process opened.
SQSE_PARALLEL_DEGREE_MINMinimum number of sessions executing this statement in parallel.
SQSE_PARALLEL_DEGREE_MAXMaximum number of sessions executing this statement in parallel.
SQSE_LOCK_ROW_SUMAmount of time the process was waiting to acquire a lock on a row.
SQSE_LOCK_KEY_SUMAmount of time the process was waiting to acquire a lock on an index key or an index key range.
SQSE_LOCK_PAGE_SUMAmount of time the process was waiting to acquire a lock on a table or index page.
SQSE_LOCK_TABLE_SUMAmount of time the process was waiting to acquire a lock on a table.
SQSE_COMPILE_LOCK_SUMAmount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure.
SQSE_SLA_RED_SUMNumber 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_SUMNumber 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_SUMNumber 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_TIMESTAMPLocal date and time the row was loaded into the PMDB.
SQSE_ROWIDUnique row number.
SQSE_START_BIT_IDFor future use.
SQSE_CLR_WAIT_SUMGroups all the CLR-related waits.
SQSE_INTERNAL_WAIT_SUMGroups all the waits from Internal groups.
SQSE_NET_IO_WAIT_SUMGroups all I/O related wait types.
SQSE_TEMP_DB_WAIT_SUMGroups I/O / Latch on TempDB pages.
SQSE_IDLE_WAIT_SUMThis group includes the events indicating that a session is waiting for something other than a user request.
SQSE_INTRNL_BP_WAIT_SUMThis state groups the events, which all mean contention on pages in the buffer pool.
SQSE_INTRNL_LATCH_WAIT_SUMThis group includes all Latch related wait types.
SQSE_INTRNL_PARALLEL_WAIT_SUMAmount of time the process was waiting for one of its sub-threads to complete its operation.
SQSE_INTRNL_DTC_WAIT_SUMAggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another.
SQSE_INTRNL_DBMIRROR_WAIT_SUMAggregates a couple of new waits that occur when DB Mirroring is used.
SQSE_INTRNL_PROFILER_WAIT_SUMAggregates a number of states associated with the Profiler.
SQSE_INTRNL_MEMORY_WAIT_SUMIncludes wait types, all of which mean that a session is waiting for memory to be allocated to it.
SQSE_INTRNL_BACKUP_WAIT_SUMIncludes wait types commonly occurring when a session is doing a BACKUP command.
SQSE_INTRNL_OTHER_WAIT_SUMThis aggregates all the waits that do not match into any of the Precise for MS-SQL Server states.
SQSE_NUM_OF_ENDED_SESSIONS_SUMNumber of sessions, which ended during the row's timeframe.
SQSE_NUM_OF_SESSIONS_NOT_ENDEDNumber of sessions, which were still open at the end of the row's timeframe.
SQSE_LOCK_MD_STAT_SUMAggregates lock waits of the MetaData Statistics type.
SQSE_LOCK_MD_PART_SUMAggregates lock waits of the MetaData Partition Function type.
SQSE_LOCK_MD_OTHER_SUMAggregates lock waits of other MetaData types.
SQSE_PC_RECOMPILATIONS_SUMNumber of times this plan has been recompiled while it has remained in the cache.
SQSE_PC_CACHE_EVICTIONS_SUMNumber of times the plan has been evicted from the cache.
SQSE_PC_EXECUTION_COUNT_SUMNumber of times that the plan has been executed.
SQSE_PC_TOTAL_WORKER_TIME_SUMAmount of CPU time that was consumed by executions of this plan.
SQSE_PC_PHYSICAL_READS_SUMNumber of physical reads performed by executions of this plan.
SQSE_PC_LOGICAL_READS_SUMNumber of logical reads performed by executions of this plan.
SQSE_PC_LOGICAL_WRITES_SUMNumber of logical writes performed by executions of this plan.
SQSE_PC_CLR_TIME_SUMTime consumed inside CLR objects by executions of this plan.
SQSE_PC_ELAPSED_TIME_SUMTotal elapsed time for completed executions of this plan.



IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels