Page History
...
| 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. |