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