Page History
...
| 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_RECEIVED_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. |
PW_SQDD_DATABASES_STATS_T
Holds information on the object SQL Server: Databases Object in Windows performance counters. For more information, search for "performance counters" on http://msdn.microsoft.com.
| Column Name | Column Description |
|---|---|
SQDD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDD_INSTANCE_NAME | Name of the database. |
SQDD_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 SQDD_PWHG_ID should be used. |
SQDD_PWHG_ID | Hour group ID. |
SQDD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDD_ACTIVE_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BACKUP_RES_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_ROWS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_BULK_COPY_THROUGHPUT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DATA_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_DBCC_LOGICAL_SCAN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_BYTES_FLUSHED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_CACHE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FILE_SIZE_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAIT_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSH_WAITS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_FLUSHES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_GROWTHS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_SHRINKS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_LOG_TRUNCATIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_PERCENT_LOG_USED_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_PENDING_XACTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_REPL_TRANS_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_SHRINK_DATA_MOVEMENT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_TRANSACTIONS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQDD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDD_ROWID | Unique row number. |