Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools