Page History
...
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. |
PW_SQAM_ACCESS_METHODS_STATS_T
Holds information on the object SQL Server: Access Methods Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQAM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQAM_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 SQAM_PWHG_ID should be used. |
SQAM_PWHG_ID | Hour group ID. |
SQAM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQAM_EXTENT_DEALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_EXTENT_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FORWARDED_RECORDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FREESPACE_PAG_FETCH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FREESPACE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_FULL_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_INDEX_SEARCHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_MIXED_PAGE_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGE_DEALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGE_SPLITS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PAGES_ALLOC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_PROBE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_RANGE_SCANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_SCAN_POINT_REVALID_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_SKIPP_GHOSTED_RECORD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQAM_TABLE_LOCK_ESCALATION_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_WORKFILES_CREATED_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_WORKTABLES_CREATED_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_WORKTABLES_CREATED_ MAX For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_WORKTABLE_CACHE_HIT_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_CONNECTION_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_GRANTED_WS_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_BLOCK_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_BLOCK_ALLO_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_MEMORY_MAX For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_OWN_BLOCK_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_LOCK_OWN_BLOCK_ALC_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_MAX_WS_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_MEMORY_GRANT_OUT_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_MEMORY_GRANT_PEND_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_OPTIMIZER_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_SQL_CACHE_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_TARGET_SRV_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_TOTAL_SRV_MEMORY_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_MM_TOTAL_SRV_MEMORY_MAX For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_RECIEVED_TIMESTAMP Local date and time the row was loaded into the PMDB.
SQAM_ROWID Unique row number.
SQAM_AU_CLEANUP_BATCHES_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_AU_CLEANUP_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_COUNT_PULL_IN_ROW_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_COUNT_PUSH_OFF_ROW_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_DEFERRED_DROP_AUS_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_DEFERRED_DROP_ROWSETS_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_DROP_ROWSET_CLEANUPS_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_DROP_ROWSET_SKIPPED_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_FAIL_AU_CLEANUP_BATCH_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_FAIL_LEAF_PAGE_COOKIE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_FAIL_TREE_PAGE_COOKIE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_USED_LEAF_PAGE_COOKIE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.
SQAM_USED_TREE_PAGE_COOKIE_AVG For more information, search for “performance counters” on http://msdn.microsoft.com.