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

Compare with Current View Page History

« Previous Version 35 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_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 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_TIMESTAMPDate 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_TIMESTAMPDate 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_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 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_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 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_HVUnique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.

PW_SQEO_EXPLN_OPER

Holds information on batch access plans.


SQEO_PWII_INSTANCE_ID ID of the SQL Server instance.
SQEO_DATABASE_NAME Name of the database to which the statement belongs.
SQEO_PARSING_USER One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.
SQEO_BATCH_HV Unique identifier (number) assigned to the batch.
SQEO_WORKSHOP_HV Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
SQEO_EXPLAIN_TIME Date and time the batch was explained and its access plan was changed.
SQEO_STATEMENT_ID_IN_BAT CH A statement number in the first batch sampled running the statement.
SQEO_OPERATOR_ID Sequence order of this operation in the access plan for a statement.
SQEO_OPERATOR_TYPE Physical operation in the access plan.
SQEO_OPTIONS Logical operation in the access plan.
SQEO_EXECUTION_ORDER Sequence order of this operation in the whole access plan.
SQEO_TREE_LEVEL Tree level of this operation in the access plan.
SQEO_ARGUMENTS_LIST Not in use.
SQEO_REMOTE_STATEMENT_HV Unique identifier (number) for the remote query used in this operation.
SQEO_OBJ_DATABASE_NAME Database name of the object accessed in this operation.
SQEO_OBJ_OWNER_NAME Owner of the object accessed in this operation.
SQEO_OBJ_NAME Name of the object accessed in this operation.
SQEO_INDEX_NAME Name of the index accessed in this operation. Otherwise NULL.
SQEO_TOTAL_SUBTREE_COST Estimated cost of this operation and its descendants.
SQEO_CONTRIBUTION_RATIO Contribution value of the object in this operation to the statement.
SQEO_ESTIMATE_COST Estimated cost of this operation.
SQEO_ESTIMATE_IO_COST Estimated I/O cost of this operation.
SQEO_ESTIMATE_CPU_COST Estimated CPU cost of this operation.
SQEO_ESTIMATE_ROWS Estimated number of rows returned by this operation.
SQEO_WARNINGS Warnings in this operation.
SQEO_PARALLEL_IND Indicates if the operation is performed in parallel.
SQEO_ESTIMATE_EXECUTION Estimated number of times this operation is performed.
SQEO_LAST_EXPLAIN_IND Indicates that this operation belongs to the last explain of the batch.
SQEO_AVG_ROW_SIZE Average row size this operation handles.









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