Page History
...
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. | |
| 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.
...