Precise for SQL Server tables

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

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

PW_SQDL_INST_DB_DEFINITION_LOG

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

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

PW_SQCL_SCHEMA_CHANGES_LOG

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

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

PW_SQID_SCHEMA_CHANGES_INST

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

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

PW_SQCO_SCHEMA_CHANGES_OBJECTS

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

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

PW_SQCK_SCHEMA_CHANGES_INDXKEY

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

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

PW_SQCI_SCHEMA_CHANGES_INDEXES

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

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

PW_SQCD_SCHEMA_CHANGES_DB

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

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

PW_SQCC_SCHEMA_CHANGES_COLUMNS

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

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

PW_SQRS_REPLIC_SNAP_STATS

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

Column Name	Column Description
`SQRS_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRS_INSTANCE_NAME`	Name of the snapshot agent.
`SQRS_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQRS_PWHG_ID` should be used.
`SQRS_PWHG_ID`	Hour group ID.
`SQRS_SNAP_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRS_SNAP_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRS_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRS_ROWID`	Unique row number.

PW_SQRM_REPLIC_MERGE_STATS

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

Column Name	Column Description
`SQRM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRM_INSTANCE_NAME`	Name of the merge agent.
`SQRM_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQRM_PWHG_ID` should be used.
`SQRM_PWHG_ID`	Hour group ID.
`SQRM_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRM_CONFLICTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_DOWNLOADED_CHANGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_UPLOADED_CHANGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRM_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRM_ROWID`	Unique row number.

PW_SQRL_REPLIC_LOGREAD_STATS

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

Column Name	Column Description
`SQRL_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRL_INSTANCE_NAME`	Name of the publisher instance.
`SQRL_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQRL_PWHG_ID` should be used.
`SQRL_PWHG_ID`	Hour group ID.
`SQRL_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRL_LOG_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_LOG_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_LOG_DELIVERY_LATENCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRL_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRL_ROWID`	Unique row number.

PW_SQRD_REPLIC_DISTRIB_STATS

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

Column Name	Column Description
`SQRD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRD_INSTANCE_NAME`	Name of the publisher instance.
`SQRD_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQRD_PWHG_ID` should be used.
`SQRD_PWHG_ID`	Hour group ID.
`SQRD_DIST_DELIVERED_CMDS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_DIST_DELIVERED_TRANS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_DIST_DELIVERY_LATENCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRD_ROWID`	Unique row number.

PW_SQRA_REPLIC_AGENT_STATS

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

Column Name	Column Description
`SQRA_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQRA_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQRA_PWHG_ID` should be used.
`SQRA_PWHG_ID`	Hour group ID.
`SQRA_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQRA_DISTRIBUTION_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA__LOGREADER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_MERGE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_QUEUEREADER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_SNAPSHOT_TIMESTAMP`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQRA_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQRA_ROWID`	Unique row number.

PW_SQBP_BUFFER_PART_STATS

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

Column Name	Column Description
`SQBP_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBP_INSTANCE_NAME`	Name of the buffer.
`SQBP_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQBP_PWHG_ID` should be used.
`SQBP_PWHG_ID`	Hour group ID.
`SQBP_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBP_FREE_LIST_EMPTY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_FREE_LIST_REQUESTS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_FREE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBP_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBP_ROWID`	Unique row number.

PW_SQBM_BF_CH_MANAGER_STATS_T

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

Column Name	Column Description
`SQBM_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBM_TIMESTAMP`	Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and `SQBM_PWHG_ID` should be used.
`SQBM_PWHG_ID`	Hour group ID.
`SQBM_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBM_AWE_LOOKUP_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_STOLEN_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_UNMAP_CALL_AWG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_UNMAP_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_AWE_WRITE_MAPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_BUFFER_HIT_RATIO_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CHECKPOINT_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_DATABASE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_LIST_STALL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_FREE_PAGES_MIN`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_LAZY_WRITES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_LIFE_EXPECTANCY_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_LOOKUPS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_READS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PAGE_WRITES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_PROCEDURES_CACHE_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_READAHEAD_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_RESERVED_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_STOLEN_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_TARGET_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_TOTAL_PAGES_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_OBJ_CNT_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_PAGES_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_AD_HOC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_CURSORS_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_CONTEXT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_N_TREE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_PREPARE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_RP_PROC_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_TRIGGER_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_USE_TOTAL_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBM_ROWID`	Unique row number.
`SQBM_CACHE_HIT_SQL_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_OBJ_PLN_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_BND_TRE_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBM_CACHE_HIT_EXT_SP_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.

SQBM_CACHE_HIT_TMP_TAB_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_SQL_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_OBJ_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_BND_TRE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_EXT_SP_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_OBJ_CNT_TMP_TAB_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_SQL_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_OBJ_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_BND_TRE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_EXT_SP_ AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_PAGES_TMP_TAB_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_USE_SQL_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_USE_OBJ_PLN_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_USE_BND_TRE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_USE_EXT_SP_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQBM_CACHE_USE_TMP_TAB_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.

Content

Space Tools