Page History
...
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_ | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQBM_CACHE_ | 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_RECIEVED_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.