PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
Column Name | Column Description |
---|---|
PWII_ID | ID of the instance. Columns of XXXX_PWII_INSTANCE_ID have values from the column. |
PWII_INSTANCE_NAME | Name of the instance. |
PWII_TECHNOLOGY | Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE). |
PWII_SERVER | Name of the server on which the instance is installed. |
PW_SQDL_INST_DB_DEFINITION_LOG
Tracks changes on instance/database definitions. It contains a list of all changes that occur in the instance/database definition.
Column Name | Column Description |
---|---|
SQDL_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDL_DATABASE_NAME | Name of the database in which the change occurred. |
SQDL_OLD_VALUE | Old value, before the change. |
SQDL_NEW_VALUE | New value, after the change. |
SQDL_CHANGE_TYPE | Type of the performed change (Created, Dropped, Updated). |
SQDL_DATA_CHANGED | Property that was changed. |
SQDL_SAMPLE_DATE | Date and time when the schema changes process ran. The actual change date is prior to the sample date and after the previous sample date. |
PW_SQCL_SCHEMA_CHANGES_LOG
Contains a list of all changes that occur in the object’s index, key, and column definitions.
Column Name | Column Description |
---|---|
SQCL_PWII | ID of the SQL Server instance. |
SQCL_DATABASE_ID | Internal ID of the database. |
SQCL_OBJECT_ID | ID of the object, column, or index that was changed, depending on the type of the object that was changed. |
SQCL_OBJECT_TYPE | Type of the object that was changed. |
SQCL_OBJECT_NAME | Name of the object that was changed. |
SQCL_OBJECT_OWNER | Owner of the object that was changed. |
SQCL_PARENT_OBJECT_ID | ID of the parent object that was changed. For example, if an index was changed, the parent object ID is the table ID. |
SQCL_PARENT_OBJECT_NAME | Name of the parent object name that was changed. For example: If an index was changed, the parent object name is the table name. |
SQCL_PARENT_OBJECT_OWNER | Owner of the parent object owner that was changed. For example: If an index was changed, the parent object owner is the table owner. |
SQCL_INDEX_ID | ID of the index that was changed. Relevant only for index key changes. |
SQCL_INDEX_NAME | Name of the index that was changed. Relevant only for index key changes. |
SQCL_OLD_VALUE | Old value (before the change). |
SQCL_NEW_VALUE | New value (after the change). |
SQCL_CHANGE_TYPE | Type of the performed change (Created, Dropped, Updated). |
SQCL_DATA_CHANGED | Name of the property that was changed. |
SQCL_SAMPLE_DATE | Date and time when the schema changes process run. |
PW_SQID_SCHEMA_CHANGES_INST
Stores snapshots of the instances’ properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQID_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQID_CONFIG_OPTION_ID | ID of the instance property, as appearing in sp_configure . |
SQID_CONFIG_OPTION_NAME | Name of the instance property, as appearing in sp_configure . |
SQID_CONFIG_OPTION_VALUE | Value of the instance property. |
PW_SQCO_SCHEMA_CHANGES_OBJECTS
Stores snapshots of the instance objects’ properties. The object can be a table or a stored object such as a view, trigger, user-defined function, or stored procedure. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCO_DATABASE_ID | Internal ID of the database. |
SQCO_OBJECT_ID | ID of the object that was changed. |
SQCO_NAME | Name of the object that was changed. |
SQCO_OWNER | Owner of the object that was changed. |
SQCO_TYPE | Type of the object that was changed. See sysobjects documentation for a list of all available types. |
SQCO_CREATE_DATE | Creation date of the object. |
SQCO_FILE_GROUP | File group in which the object resides. Relevant only for tables. |
SQCO_NUM_OF_COLUMN | Number of columns in the object. |
SQCO_EXEC_IS_ANSI_NULL_ON | Value of the object’s Ansi Null property. Relevant only for stored objects. |
SQCO_TABLE_HAS_INDEX | TRUE if the table has an index, FALSE if the table does not have an indexes. |
SQCO_TABLE_HAS_CLUSTERED_INDEX | TRUE if the table has a clustered index, FALSE if the table does not have a clustered index. |
SQCO_DELETE_TRIGGER_COUNT | Number of delete triggers on the table. |
SQCO_INSERT_TRIGGER_COUNT | Number of insert triggers on the table. |
SQCO_UPDATE_TRIGGER_COUNT | Number of update triggers on the table. |
SQCO_NUM_OF_PARTITIONS | Number of partitions per object. |
PW_SQCK_SCHEMA_CHANGES_INDXKEY
Stores snapshots of the index keys. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCK_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCK_DATABASE_ID | Internal ID of the database. |
SQCK_OBJECT_ID | ID of the object on which the index is defined. |
SQCK_INDEX_ID | ID of the index. |
SQCK_COLUMN_ID | ID of the column. |
SQCK_COLUMN_NAME | Name of the column key. |
SQCK_INDEX_NAME | Name of the index. |
SQCK_OBJECT_NAME | Name of the table. |
SQCK_OBJECT_OWNER | Owner of the table. |
SQCK_POSITION | Position of the key in the index. |
SQCK_ORDER_BY | Sorting of the key in the index. |
PW_SQCI_SCHEMA_CHANGES_INDEXES
Stores snapshots of the indexes. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCI_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCI_DATABASE_ID | Internal ID of the database. |
SQCI_OBJECT_ID | ID of the object on which the index is defined. |
SQCI_INDEX_ID | ID of the index. |
SQCI_INDEX_NAME | Name of the index. |
SQCI_OBJECT_NAME | Name of the table. |
SQCI_OBJECT_OWNER | Owner of the table. |
SQCI_FILE_GROUP | File group in which the index resides. |
SQCI_NUM_OF_KEYS | Number of keys in the index. |
SQCI_FILL_FACTOR | Fill factor of the index. |
SQCI_IS_CLUSTERED_INDEX | Indicates whether the index is clustered. |
SQCI_IS_PAD_INDEX | Indicates whether the index is padded. |
SQCI_IS_UNIQUE | Indicates whether the index is unique. |
SQCI_INDEX_DEPTH | Index tree level. |
SQCI_IS_AUTH_STAT | Indicates if the index has turned on the autostatistics. |
SQCI_IS_PAGE_LOCK_DISALLOWED | Indicates whether an index page can be locked. |
SQCI_IS_ROW_LOCK_DISALLOWED | Indicates whether an index row can be locked. |
PW_SQCD_SCHEMA_CHANGES_DB
Stores snapshots of the database properties. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCD_DATABASE_ID | Internal ID of the database. |
SQCD_DATABASE_NAME | Name of the database in which the change occurred. |
SQCD_RECOVERY | Recovery model of the database. |
SQCD_AUTO_UPDATE_STATISTICS | Auto-update statistics status of the database. |
SQCD_ANSI_NULL | Ansi null status of the database. |
SQCD_AUTO_SHRINK_FILES | Autoshrink files status of the database. |
SQCD_CLOSE_CURSORS_ON_COMMIT | Close cursor on commit status of the database. |
SQCD_STATUS | Availability status of the database. |
SQCD_AUTOCREATES_STATISTICS | Autocreate statistics status of the database. |
SQCD_TRUNCATES_LOG | Truncate log status of the database. |
SQCD_COMPATIBILITY_LEVEL | Compatibility level of the database. |
SQCD_OBJECT_SAMPLE_STATUS | Status of tracking changes on objects in the database. |
SQCD_COLUMN_SAMPLE_STATUS | Status of tracking changes on columns in the database. |
SQCD_INDEX_SAMPLE_STATUS | Status of tracking changes on indexes in the database. |
SQCD_INDEX_K_SAMPLE_STATUS | Status of tracking changes on keys in the database. |
SQCD_DATABASES_SAMPLE_STATUS | Status of tracking changes on database definitions in the database. |
SQCD_PS_SAMPLE_STATUS | To support partition schema collecting. |
SQCD_PS_FG_SAMPLE_STATUS | To support file group collecting pointed by partition schema. |
SQCD_PF_SAMPLE_STATUS | To support partition function collecting. |
SQCD_PF_VALUES_SAMPLE_STATUS | To support partition function values collecting of a particular partition function. |
SQCD_AUTO_UPDATE_STATS | Database option. |
SQCD_PARAMS_FORCED | Database option. |
SQCD_DATE_CORRELATION | Database option. |
PW_SQCC_SCHEMA_CHANGES_COLUMNS
Stores snapshots of the columns. Every time the schema change process runs, the current values are compared to the values in this table. All changes are stored in the log table, and this table is refreshed with the latest snapshots.
Column Name | Column Description |
---|---|
SQCC_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQCC_DATABASE_ID | Internal ID of the database. |
SQCC_OBJECT_ID | ID of the object to which the column belongs. |
SQCC_COLUMN_ID | ID of the column. |
SQCC_COLUMN_NUMBER | Number of the subprocedure when the procedure is grouped (0 for nonprocedure objects). |
SQCC_COLUMN_NAME | Name of the column. |
SQCC_OBJECT_NAME | Name of the object. |
SQCC_OBJECT_OWNER | Owner of the object. |
SQCC_TYPE | Type of the column. |
SQCC_LENGTH | Length of the column. |
SQCC_SCALE | Scale of the column. |
SQCC_PRECISION | Precision of the column. |
SQCC_IS_NULL_ABLE | Nullable property of the column. |
SQCC_IS_TABLE | Indicates whether the object is a table. |
PW_SQRS_REPLIC_SNAP_STATS
Holds information on the object SQL Server: Replication Snapshot Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQRS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRS_INSTANCE_NAME | Name of the snapshot agent. |
SQRS_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQRS_PWHG_ID should be used. |
SQRS_PWHG_ID | Hour group ID. |
SQRS_SNAP_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRS_SNAP_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRS_ROWID | Unique row number. |
PW_SQRM_REPLIC_MERGE_STATS
Holds information on the object SQL Server: Replication Merge Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQRM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRM_INSTANCE_NAME | Name of the merge agent. |
SQRM_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQRM_PWHG_ID should be used. |
SQRM_PWHG_ID | Hour group ID. |
SQRM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQRM_CONFLICTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_DOWNLOADED_CHANGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_UPLOADED_CHANGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRM_ROWID | Unique row number. |
PW_SQRL_REPLIC_LOGREAD_STATS
Holds information on the object SQL Server: Replication Logreader Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQRL_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRL_INSTANCE_NAME | Name of the publisher instance. |
SQRL_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQRL_PWHG_ID should be used. |
SQRL_PWHG_ID | Hour group ID. |
SQRL_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQRL_LOG_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_LOG_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_LOG_DELIVERY_LATENCY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRL_ROWID | Unique row number. |
PW_SQRD_REPLIC_DISTRIB_STATS
Holds information on the object SQL Server: Replication Distribution Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQRD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRD_INSTANCE_NAME | Name of the publisher instance. |
SQRD_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQRD_PWHG_ID should be used. |
SQRD_PWHG_ID | Hour group ID. |
SQRD_DIST_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_DIST_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_DIST_DELIVERY_LATENCY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRD_ROWID | Unique row number. |
PW_SQRA_REPLIC_AGENT_STATS
Holds information on the object SQL Server: Replication Agents Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQRA_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRA_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQRA_PWHG_ID should be used. |
SQRA_PWHG_ID | Hour group ID. |
SQRA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQRA_DISTRIBUTION_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRA__LOGREADER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRA_MERGE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRA_QUEUEREADER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRA_SNAPSHOT_TIMESTAMP | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRA_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRA_ROWID | Unique row number. |
PW_SQBP_BUFFER_PART_STATS
Holds information on the object SQL Server: Buffer Partition Object in Windows performance counters. For more details, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQBP_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQBP_INSTANCE_NAME | Name of the buffer. |
SQBP_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQBP_PWHG_ID should be used. |
SQBP_PWHG_ID | Hour group ID. |
SQBP_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQBP_FREE_LIST_EMPTY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBP_FREE_LIST_REQUESTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBP_FREE_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBP_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQBP_ROWID | Unique row number. |
PW_SQBM_BF_CH_MANAGER_STATS_T
Holds information on the objects SQL Server: Buffer Manager Object and SQL Server: Cache Manager Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQBM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQBM_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQBM_PWHG_ID should be used. |
SQBM_PWHG_ID | Hour group ID. |
SQBM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQBM_AWE_LOOKUP_MAPS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_AWE_STOLEN_MAPS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_AWE_UNMAP_CALL_AWG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_AWE_UNMAP_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_AWE_WRITE_MAPS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_BUFFER_HIT_RATIO_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CHECKPOINT_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_DATABASE_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_FREE_LIST_STALL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_FREE_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_FREE_PAGES_MIN | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_LAZY_WRITES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_PAGE_LIFE_EXPECTANCY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_PAGE_LOOKUPS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_PAGE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_PAGE_WRITES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_PROCEDURES_CACHE_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_READAHEAD_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_RESERVED_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_STOLEN_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_TARGET_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_TOTAL_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_AD_HOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_CURSORS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_CONTEXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_N_TREE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_PREPARE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_RP_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_TRIGGER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_TOTAL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_AD_HOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_CURSORS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_CONTEXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_N_TREE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_PREPARE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_PREPARE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_RP_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_TRIGGER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_TOTAL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_AD_HOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_CURSORS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_CONTEXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_N_TREE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_PREPARE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_RP_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_TRIGGER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_TOTAL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_AD_HOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_CURSORS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_CONTEXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_N_TREE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_PREPARE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_RP_PROC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_TRIGGER_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_TOTAL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQBM_ROWID | Unique row number. |
SQBM_CACHE_HIT_SQL_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_OBJ_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_BND_TRE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_EXT_SP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_HIT_TMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_SQL_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_OBJ_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_BND_TRE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_EXT_SP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_OBJ_CNT_TMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_SQL_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_OBJ_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_BND_TRE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_EXT_SP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_PAGES_TMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_SQL_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_OBJ_PLN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_BND_TRE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_EXT_SP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_USE_TMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQBD_BACKUP_DEVICE_STATS_T
Holds information on the object SQL Server: Backup Device Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQBD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQBD_INSTANCE_NAME | Name of the backup device. |
SQBD_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQBD_PWHG_ID should be used. |
SQBD_PWHG_ID | Hour group ID. |
SQBD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQBD_DEVICE_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQBD_ROWID | Unique row number. |
SQBD_READ_IO_WAIT | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBD_WRITE_IO_WAIT | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBD_FILE_NAME | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQAM_ACCESS_METHODS_STATS_T
Holds information on the object SQL Server: Access Methods Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQAM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQAM_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQAM_PWHG_ID should be used. |
SQAM_PWHG_ID | Hour group ID. |
SQAM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQAM_EXTENT_DEALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_EXTENT_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FORWARDED_RECORDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FREESPACE_PAG_FETCH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FREESPACE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FULL_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_INDEX_SEARCHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MIXED_PAGE_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGE_DEALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGE_SPLITS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGES_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PROBE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_RANGE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_SCAN_POINT_REVALID_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_SKIPP_GHOSTED_RECORD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_TABLE_LOCK_ESCALATION_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_WORKFILES_CREATED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_WORKTABLES_CREATED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_WORKTABLES_CREATED_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_WORKTABLE_CACHE_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_CONNECTION_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_GRANTED_WS_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_BLOCK_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_BLOCK_ALLO_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_MEMORY_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_OWN_BLOCK_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_LOCK_OWN_BLOCK_ALC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_MAX_WS_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_MEMORY_GRANT_OUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_MEMORY_GRANT_PEND_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
| For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_SQL_CACHE_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_TARGET_SRV_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_TOTAL_SRV_MEMORY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MM_TOTAL_SRV_MEMORY_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQAM_ROWID | Unique row number. |
SQAM_AU_CLEANUP_BATCHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_AU_CLEANUP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_COUNT_PULL_IN_ROW_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_COUNT_PUSH_OFF_ROW_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_DEFERRED_DROP_AUS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_DEFERRED_DROP_ROWSETS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_DROP_ROWSET_CLEANUPS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_DROP_ROWSET_SKIPPED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FAIL_AU_CLEANUP_BATCH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FAIL_LEAF_PAGE_COOKIE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FAIL_TREE_PAGE_COOKIE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_USED_LEAF_PAGE_COOKIE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_USED_TREE_PAGE_COOKIE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQDD_DATABASES_STATS_T
Holds information on the object SQL Server: Databases Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQDD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDD_INSTANCE_NAME | Name of the database. |
SQDD_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQDD_PWHG_ID should be used. |
SQDD_PWHG_ID | Hour group ID. |
SQDD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDD_ACTIVE_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BACKUP_RES_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_ROWS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DATA_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DBCC_LOGICAL_SCAN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_BYTES_FLUSHED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAITS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_GROWTHS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_SHRINKS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_TRUNCATIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_PERCENT_LOG_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_PENDING_XACTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_TRANS_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_SHRINK_DATA_MOVEMENT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDD_ROWID | Unique row number. |
PW_SQPS_SQL_STATISTIC_STATS_T
Holds information on the object SQL Server: SQL Statistics Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQPS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPS_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQPS_PWHG_ID should be used. |
SQPS_PWHG_ID | Hour group ID. |
SQPS_MINUTES_COUNT_SUM | The timeframe needed to calculate the row, in minutes. |
SQPS_AUTO_PARAM_ATTEMPTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH-REQUESTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH_REQUESTS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_FAILED_AUTO_PARAMS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_AUTOPARAMS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SQL_COMPILE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SQL_RE_COMPILE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_UNSAFE_AUTO_PARAM_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGINS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGINS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGOUTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_USR_CONN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_USR_CONN_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT1_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT2_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT3_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT4_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT5_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT6_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT7_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT8_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT9_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT10_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPS_ROWID | Unique row number. |
SQPS_GNRL_ACTIVE_TEMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_LOGICAL_CON_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_MARS_DEADLOCKS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_NATOM_YIELD_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_PROC_BLOCK_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TMP_TAB_CRT_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TMP_DSTRUCT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_STAT_E_INPROG_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_FORCED_PARM_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_CLNUP_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_GNRT_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_STORE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQLS_LOCKS_STATS_T
Holds information on the objects SQL Server: Locks Object and SQL Server: Latch Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQLS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQLS_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQLS_PWHG_ID should be used. |
SQLS_PWHG_ID | Hour group ID. |
SQLS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLS_AVG_WAIT_TM_HIT_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_TOTAL_LATCH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLS_ROWID | Unique row number. |
SQLS_AVG_WAIT_TM_HIT_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
PW_SQPR_PROCESS_T
Holds information on the object Process Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQPR_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPR_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQPR_PWHG_ID should be used. |
SQPR_PWHG_ID | Hour group ID. |
SQPR_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPR_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_SQL_SRVR_PAGE_FAULTS_AVG | The overall average rate of faulted pages encountered by the SQL Server process, that are handled by the processor. It is measured in numbers of pages faulted per second. A page fault occurs when a process requires code or data that is not in its working set, i.e. its space in physical memory. This counter includes both hard faults (those that require disk access) and soft faults (where the faulted page is found elsewhere in physical memory). Most processors can handle large numbers of soft faults without consequence. However, hard faults can cause significant delays. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval. |
SQPR_PAGE_FAULTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_WRITES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_AVAILABLE_MB_AVG | The amount of physical memory available to processes running on the computer, in megabytes (Bytes / 1,048,576). It is calculated by summing space on the Zeroed, Free, and Stand by memory lists. Free memory is ready for use; Zeroed memory are pages of memory filled with zeros to prevent later processes from seeing data used by a previous process. Standby memory is memory removed from a process' working set (its physical memory) on route to disk, but is still available to be recalled. This counter displays the last observed value only; it is not an average. |
SQPR_AVAILABLE_MB_MIN | Like the previous counter, but it is the minimum value after doing the summary process. |
SQPR_SERVER_PHYS_MEMORY_MAX | Total physical memory available in the instance machine. |
SQPR_QUEUE_LENGTH_AVG | The number of threads in the processor queue. There is a single queue for processor time, even on computers with multiple processors. Unlike the disk counters, this counter counts ready threads only, not threads that are running. A sustained processor queue of greater than two threads generally indicates processor congestion. This counter displays the last observed value only; it is not an average. |
SQPR_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPR_ROWID | Unique row number. |
PW_SQPO_PROCESSOR_T
Holds information on the object Processor Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQPO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPO_INSTANCE_NAME | Number of the processor. |
SQPO_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQPO_PWHG_ID should be used. |
SQPO_PWHG_ID | Hour group ID. |
SQPO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPO_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPO_ROWID | Unique row number. |
PW_SQPD_PHYSICAL_DISK_T
Holds information on the object PhysicalDisk Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
Column Name | Column Description |
---|---|
SQPD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPD_INSTANCE_NAME | Identifier of the disk. |
SQPD_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQPD_PWHG_ID should be used. |
SQPD_PWHG_ID | Hour group ID. |
SQPD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPD_AVG_DISK_QUEUE_LENGTH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_READS_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_WRITES_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_WRITES_AVG | The average time in seconds it took to write data to the disk. |
SQPD_DISK_SEC_TRANSFER_AVG | The average time in seconds of the average disk transfer. |
SQPD_DISK_TRANSFER_PER_SEC_AVG | The average number of disk transfers per second. |
SQPD_DISK_SPLIT_IO_PER_SEC_AVG | The average rate that I/Os to the disk were split into multiple I/Os. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented. |
SQPD_PRCT_DISK_READ_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing read requests. |
SQPD_PRCT_DISK_WRITE_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing write requests. |
SQPD_PRCT_IDLE_TIME_AVG | The average percentage of time during the sample interval that the disk was idle. |
SQPD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPD_ROWID | Unique row number. |
PW_SQXM_XP_MAPPING
Holds mapping disks of HP or HDS systems.
Column Name | Column Description |
---|---|
SQXM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQXM_PHYSICAL_DISK | Physical disk number. |
SQXM_DEVICE_NAME | Name of the device. |
SQXM_ARRAY_ID | ID of the array. |
SQXM_CONTROL_UNIT | Control unit identifier. |
SQXM_LDEV_ID | ID of the logical device. |
SQXM_RAID_GROUP | Name of the raid group. |
SQXM_CHP_ID | Identification number of the Client Host Interface Processor Port of the logical device. |
SQXM_ACP_PAIR_ID | Identification number of the Array Control Processor Pair of the logical device. |
SQXM_URL | Vendor-specific performance URL. |
PW_SQOU_OBJECTS_SPACE_USAGE_D
Holds statistics on objects space. By default, this process runs every 24 hours.
Column Name | Column Description |
---|---|
SQOU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQOU_DATABASE_ID | Name of the database, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQOU_OBJECT_ID | ID of the table. |
SQOU_FULL_OBJECT_ID | The full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N . |
SQOU_INDEX_ID | ID of the index. |
SQOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQOU_PWHG_ID | Hour group ID. |
SQOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQOU_O_ALL_ALLOC_MAX | Number of pages allocated to the object. |
SQOU_O_ALL_USED_MAX | Number of pages used by the object. |
SQOU_O_TEXT_ALLOC_MAX | Number of text pages allocated to the object. |
SQOU_O_TEXT_USED_MAX | Number of text pages used by the object. |
SQOU_O_DATA_USED_MAX | Number of data pages used by the objects. |
SQOU_O_INDEX_ALLOC_MAX | Number of pages allocated to the indexes of the object. |
SQOU_O_INDEX_USED_MAX | Number of pages used by the indexes of the object. |
SQOU_ROW_COUNT_MAX | Number of rows the object has. |
SQOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQOU_ROWID | Unique row number. |
SQOU_SYSTEM_SEEKS_SUM | Number of system seeks per one object. |
SQOU_SYSTEM_SCANS_SUM | Number of system scans per one object. |
SQOU_SYSTEM_LOOKUPS_SUM | Number of system lookups per one object. |
SQOU_SYSTEM_UPDATES_SUM | Number of system updates per one object. |
SQOU_USER_SEEKS_SUM | Number of user seeks per one object. |
SQOU_USER_SCANS_SUM | Number of user scans per one object. |
SQOU_USER_LOOKUPS_SUM | Number of user lookups per one object. |
SQOU_USER_UPDATES_SUM | Number of user updates per one object. |
PW_SQDU_DBFILES_SPACE_USAGE_D
Holds the space over time of datafiles. By default, this process runs every 24 hours.
Column Name | Column Description |
---|---|
SQDU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDU_DATABASE_NAME | ID of the database, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQDU_FILE_ID | ID of the file in the database. |
SQDU_FILE_NAME_ID | The internal file ID, normalize in table PW_SQDN_FILE_NAMES_N . |
SQDU_FILE_GROUP_ID | ID of the file group in the database. |
SQDU_FILE_GROUP_NAME_ID | The internal file group ID, normalized in table PW_SQDN_FILE_GROUP_NAMES_N . |
SQDU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQDU_PWHG_ID | Hour group ID. |
SQDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDU_FILE_SIZE_MAX | Maximum file size in MB. |
SQDU_SPACE_USED_MAX | Number of MB bytes used in the files. |
SQDU_MAX_SIZE_MAX | Maximum growth of the file. |
SQDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDU_ROWID | Unique row number. |
PW_SQDF_DBFILES_STATISTICS_D
Holds information on I/O performance and load of the SQL Server datafiles.
Column Name | Column Description |
---|---|
SQDF_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDF_DATABASE_NAME | Name of the database. |
SQDF_FILE_ID | ID of the file in the database. |
SQDF_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQDF_PWHG_ID should be used. |
SQDF_PWHG_ID | Hour group ID. |
SQDF_READS_NUMBER_SUM | Number of read requests for the file. |
SQDF_WRITES_NUMBER_SUM | Number of writes requests for the file. |
SQDF_READS_BYTES_SUM | Number of bytes read from the file. |
SQDF_WRITTEN_BYTES_SUM | Number of bytes written to the file. |
SQDF_IO_WAIT_SUM | I/O wait duration of the file. |
SQDF_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDF_ROWID | Unique row number. |
SQDF_READ_IO_WAIT_SUM | Time of read I/O wait on files. |
SQDF_WRITE_IO_WAIT_SUM | Time of write I/O wait on files. |
SQDF_LOGICAL_FILE_ID | ID of the logical file, normalized in table PW_SQFN_FILE_NAMES_N . |
PW_SQDB_DBFILES_SAMPLES
Holds last sample information on I/O performance and load of the SQL Server datafiles.
Column Name | Column Description |
---|---|
SQDB_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDB_DATABASE_NAME | Name of the database. |
SQDB_FILE_ID | ID of the file in the database. |
SQDB_SAMPLE_NUMBER | Sample number. 1 is the previous sample. 2 is the current sample. |
SQDB_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and SQDB_PWHG_ID should be used. |
SQDB_READS_NUMBER | Number of read requests for the file. |
SQDB_WRITES_NUMBER | Number of write requests for the file. |
SQDB_READS_BYTES | Number of bytes read from the file. |
SQDB_WRITTEN_BYTES | Number of bytes writes to the file. |
SQDB_IO_WAIT | I/O wait duration of the file. |
PW_SQAV_AVAILABILITY
Holds information on the status of the databases and the SQL Server instance.
Column Name | Column Description |
---|---|
SQAV_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQAV_DATABASE_NAME | Name of the database. Null in case of an instance record. |
SQAV_STATUS | Status of the database or the instance. |
SQAV_FROM_TIME | Date and time the status was changed to the status field. |
SQAV_TO_TIME | Date and time the status was changed from the status field |
PW_SQSC_STMT_CATALOG
Holds information on statements in the Statement Workshop.
SQSC_PWII_INSTANCE_ID ID of the SQL Server instance.
SQSC_CABINET Name of the cabinet in which the statement is stored.
SQSC_FOLDER Name of the folder within the cabinet.
SQSC_STATEMENT_ID Unique identifier (string) assigned to the statement.
SQSC_WORKSHOP_HV Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
PW_SQEO_EXPLN_OPER Holds information on batch access plans.
SQEO_PWII_INSTANCE_ID ID of the SQL Server instance.
SQEO_DATABASE_NAME Name of the database to which the statement belongs.
SQEO_PARSING_USER One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch.
SQEO_BATCH_HV Unique identifier (number) assigned to the batch.
SQEO_WORKSHOP_HV Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value 0.
SQEO_EXPLAIN_TIME Date and time the batch was explained and its access plan was changed.
SQEO_STATEMENT_ID_IN_BAT CH A statement number in the first batch sampled running the statement.
SQEO_OPERATOR_ID Sequence order of this operation in the access plan for a statement.
SQEO_OPERATOR_TYPE Physical operation in the access plan.
SQEO_OPTIONS Logical operation in the access plan.
SQEO_EXECUTION_ORDER Sequence order of this operation in the whole access plan.
SQEO_TREE_LEVEL Tree level of this operation in the access plan.
SQEO_ARGUMENTS_LIST Not in use.
SQEO_REMOTE_STATEMENT_HV Unique identifier (number) for the remote query used in this operation.
SQEO_OBJ_DATABASE_NAME Database name of the object accessed in this operation.
SQEO_OBJ_OWNER_NAME Owner of the object accessed in this operation.
SQEO_OBJ_NAME Name of the object accessed in this operation.
SQEO_INDEX_NAME Name of the index accessed in this operation. Otherwise NULL.
SQEO_TOTAL_SUBTREE_COST Estimated cost of this operation and its descendants.
SQEO_CONTRIBUTION_RATIO Contribution value of the object in this operation to the statement.
SQEO_ESTIMATE_COST Estimated cost of this operation.
SQEO_ESTIMATE_IO_COST Estimated I/O cost of this operation.
SQEO_ESTIMATE_CPU_COST Estimated CPU cost of this operation.
SQEO_ESTIMATE_ROWS Estimated number of rows returned by this operation.
SQEO_WARNINGS Warnings in this operation.
SQEO_PARALLEL_IND Indicates if the operation is performed in parallel.
SQEO_ESTIMATE_EXECUTION Estimated number of times this operation is performed.
SQEO_LAST_EXPLAIN_IND Indicates that this operation belongs to the last explain of the batch.
SQEO_AVG_ROW_SIZE Average row size this operation handles.