Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

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

...

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

PW_SQBD_BACKUP_DEVICE_STATS_T

Holds information on the object SQL Server: Backup Device Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.

Column Name	Column Description
`SQBD_PWII_INSTANCE_ID`	ID of the SQL Server instance.
`SQBD_INSTANCE_NAME`	Name of the backup device.
`SQBD_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 `SQBD_PWHG_ID` should be used.
`SQBD_PWHG_ID`	Hour group ID.
`SQBD_MINUTES_COUNT_SUM`	The timeframe needed to calculated the row, in minutes.
`SQBD_DEVICE_THROUGHPUT_AVG`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_RECEIVED_TIMESTAMP`	Local date and time the row was loaded into the PMDB.
`SQBD_ROWID`	Unique row number.
`SQBD_READ_IO_WAIT`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_WRITE_IO_WAIT`	For more information, search for "performance counters" on http://msdn.microsoft.com.
`SQBD_FILE_NAME`	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

Versions Compared

Old Version 15

New Version 16

Key

PW_SQBD_BACKUP_DEVICE_STATS_T