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 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_

`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_

...

`RECEIVED_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.

...

Content

Space Tools

Versions Compared

Old Version 13

New Version 14

Key

PW_SQBP_BUFFER_PART_STATS

PW_SQBM_BF_CH_MANAGER_STATS_T