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