Page History
...
Column Name | Column Description |
---|---|
SQRS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRS_INSTANCE_NAME | Name of the snapshot agent. |
SQRS_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 |
SQRS_PWHG_ID | Hour group ID. |
SQRS_SNAP_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRS_SNAP_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRS_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQRM_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRM_INSTANCE_NAME | Name of the merge agent. |
SQRM_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 |
SQRM_PWHG_ID | Hour group ID. |
SQRM_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQRM_CONFLICTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_DOWNLOADED_CHANGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_UPLOADED_CHANGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRM_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRM_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQRL_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRL_INSTANCE_NAME | Name of the publisher instance. |
SQRL_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 |
SQRL_PWHG_ID | Hour group ID. |
SQRL_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQRL_LOG_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_LOG_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_LOG_DELIVERY_LATENCY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRL_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRL_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQRD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQRD_INSTANCE_NAME | Name of the publisher instance. |
SQRD_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 |
SQRD_PWHG_ID | Hour group ID. |
SQRD_DIST_DELIVERED_CMDS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_DIST_DELIVERED_TRANS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_DIST_DELIVERY_LATENCY_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQRD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQRD_ROWID | Unique row number. |
...
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 | 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. |
...
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 | 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. |
...
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 | 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. |
...
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 | 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. |
...
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 | 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. |
...
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 | 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. |
...
Column Name | Column Description |
---|---|
SQPS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPS_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 |
SQPS_PWHG_ID | Hour group ID. |
SQPS_MINUTES_COUNT_SUM | The timeframe needed to calculate the row, in minutes. |
SQPS_AUTO_PARAM_ATTEMPTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH-REQUESTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_BATCH_REQUESTS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_FAILED_AUTO_PARAMS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_AUTOPARAMS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SQL_COMPILE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SQL_RE_COMPILE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_SAFE_UNSAFE_AUTO_PARAM_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGINS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGINS_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_LOGOUTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_USR_CONN_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GENERAL_STAT_USR_CONN_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT1_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT2_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT3_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT4_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT5_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT6_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT7_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT8_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT9_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_USER_SETTABLE_CNT10_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPS_ROWID | Unique row number. |
SQPS_GNRL_ACTIVE_TEMP_TAB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_LOGICAL_CON_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_MARS_DEADLOCKS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_NATOM_YIELD_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_PROC_BLOCK_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TMP_TAB_CRT_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TMP_DSTRUCT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_GNRL_TRANSACTIONS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_ETIME_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_STAT_E_INPROG_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_INPROG_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_DSTR_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_DTC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_EXT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_EX_STAT_E_PERSEC_OLE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_FORCED_PARM_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_CLNUP_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_GNRT_RATE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPS_TRANS_VER_STORE_SIZE_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
...
Column Name | Column Description |
---|---|
SQLS_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQLS_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 |
SQLS_PWHG_ID | Hour group ID. |
SQLS_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQLS_AVG_WAIT_TM_HIT_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_D_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_E_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_K_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_P_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_R_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_T_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_TL_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_HIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_LATCH_WAIT_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_TOTAL_LATCH_WAIT_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQLS_ROWID | Unique row number. |
SQLS_AVG_WAIT_TM_HIT_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_AVG_WAIT_TM_HIT_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_REQUESTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_TIMEOUTS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAIT_TIME_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_LOCK_WAITS_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AU_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_AP_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_FI_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_HB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_MD_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQLS_NUMBER_OF_DEADLOCK_OB_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
...
Column Name | Column Description |
---|---|
SQPR_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPR_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 |
SQPR_PWHG_ID | Hour group ID. |
SQPR_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPR_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_SQL_SRVR_PAGE_FAULTS_AVG | The overall average rate of faulted pages encountered by the SQL Server process, that are handled by the processor. It is measured in numbers of pages faulted per second. A page fault occurs when a process requires code or data that is not in its working set, i.e. its space in physical memory. This counter includes both hard faults (those that require disk access) and soft faults (where the faulted page is found elsewhere in physical memory). Most processors can handle large numbers of soft faults without consequence. However, hard faults can cause significant delays. This counter displays the difference between the values observed in the last two samples, divided by the duration of the sample interval. |
SQPR_PAGE_FAULTS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGE_WRITES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_PAGES_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPR_AVAILABLE_MB_AVG | The amount of physical memory available to processes running on the computer, in megabytes (Bytes / 1,048,576). It is calculated by summing space on the Zeroed, Free, and Stand by memory lists. Free memory is ready for use; Zeroed memory are pages of memory filled with zeros to prevent later processes from seeing data used by a previous process. Standby memory is memory removed from a process' working set (its physical memory) on route to disk, but is still available to be recalled. This counter displays the last observed value only; it is not an average. |
SQPR_AVAILABLE_MB_MIN | Like the previous counter, but it is the minimum value after doing the summary process. |
SQPR_SERVER_PHYS_MEMORY_MAX | Total physical memory available in the instance machine. |
SQPR_QUEUE_LENGTH_AVG | The number of threads in the processor queue. There is a single queue for processor time, even on computers with multiple processors. Unlike the disk counters, this counter counts ready threads only, not threads that are running. A sustained processor queue of greater than two threads generally indicates processor congestion. This counter displays the last observed value only; it is not an average. |
SQPR_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPR_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQPO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPO_INSTANCE_NAME | Number of the processor. |
SQPO_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 |
SQPO_PWHG_ID | Hour group ID. |
SQPO_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPO_PRCT_PROCESSOR_TIME_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_PRCT_PROCESSOR_TIME_MAX | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPO_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPO_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQPD_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQPD_INSTANCE_NAME | Identifier of the disk. |
SQPD_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 |
SQPD_PWHG_ID | Hour group ID. |
SQPD_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQPD_AVG_DISK_QUEUE_LENGTH_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_READS_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_WRITES_PER_SEC_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_READS_AVG | For more information, search for "performance counters" on http://msdn.microsoft.com. |
SQPD_DISK_SEC_WRITES_AVG | The average time in seconds it took to write data to the disk. |
SQPD_DISK_SEC_TRANSFER_AVG | The average time in seconds of the average disk transfer. |
SQPD_DISK_TRANSFER_PER_SEC_AVG | The average number of disk transfers per second. |
SQPD_DISK_SPLIT_IO_PER_SEC_AVG | The average rate that I/Os to the disk were split into multiple I/Os. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented. |
SQPD_PRCT_DISK_READ_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing read requests. |
SQPD_PRCT_DISK_WRITE_TIME_AVG | The average percentage of elapsed time that the selected disk drive is busy servicing write requests. |
SQPD_PRCT_IDLE_TIME_AVG | The average percentage of time during the sample interval that the disk was idle. |
SQPD_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQPD_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQOU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQOU_DATABASE_ID | Name of the database, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQOU_OBJECT_ID | ID of the table. |
SQOU_FULL_OBJECT_ID | The full object ID, normalized in table PW_SQKN_LOCKED_OBJECT_NAMES_N . |
SQOU_INDEX_ID | ID of the index. |
SQOU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQOU_PWHG_ID | Hour group ID. |
SQOU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQOU_O_ALL_ALLOC_MAX | Number of pages allocated to the object. |
SQOU_O_ALL_USED_MAX | Number of pages used by the object. |
SQOU_O_TEXT_ALLOC_MAX | Number of text pages allocated to the object. |
SQOU_O_TEXT_USED_MAX | Number of text pages used by the object. |
SQOU_O_DATA_USED_MAX | Number of data pages used by the objects. |
SQOU_O_INDEX_ALLOC_MAX | Number of pages allocated to the indexes of the object. |
SQOU_O_INDEX_USED_MAX | Number of pages used by the indexes of the object. |
SQOU_ROW_COUNT_MAX | Number of rows the object has. |
SQOU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQOU_ROWID | Unique row number. |
SQOU_SYSTEM_SEEKS_SUM | Number of system seeks per one object. |
SQOU_SYSTEM_SCANS_SUM | Number of system scans per one object. |
SQOU_SYSTEM_LOOKUPS_SUM | Number of system lookups per one object. |
SQOU_SYSTEM_UPDATES_SUM | Number of system updates per one object. |
SQOU_USER_SEEKS_SUM | Number of user seeks per one object. |
SQOU_USER_SCANS_SUM | Number of user scans per one object. |
SQOU_USER_LOOKUPS_SUM | Number of user lookups per one object. |
SQOU_USER_UPDATES_SUM | Number of user updates per one object. |
...
Column Name | Column Description |
---|---|
SQDU_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDU_DATABASE_NAME | ID of the database, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQDU_FILE_ID | ID of the file in the database. |
SQDU_FILE_NAME_ID | The internal file ID, normalize in table PW_SQDN_FILE_NAMES_N . |
SQDU_FILE_GROUP_ID | ID of the file group in the database. |
SQDU_FILE_GROUP_NAME_ID | The internal file group ID, normalized in table PW_SQDN_FILE_GROUP_NAMES_N . |
SQDU_TIMESTAMP | Date and time the statistic was sampled. On a slice summary level, the date and time are in GMT. On all other summary levels, the time part is zeroed. |
SQDU_PWHG_ID | Hour group ID. |
SQDU_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQDU_FILE_SIZE_MAX | Maximum file size in MB. |
SQDU_SPACE_USED_MAX | Number of MB bytes used in the files. |
SQDU_MAX_SIZE_MAX | Maximum growth of the file. |
SQDU_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDU_ROWID | Unique row number. |
...
Column Name | Column Description |
---|---|
SQDF_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDF_DATABASE_NAME | Name of the database. |
SQDF_FILE_ID | ID of the file in the database. |
SQDF_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 |
SQDF_PWHG_ID | Hour group ID. |
SQDF_READS_NUMBER_SUM | Number of read requests for the file. |
SQDF_WRITES_NUMBER_SUM | Number of writes requests for the file. |
SQDF_READS_BYTES_SUM | Number of bytes read from the file. |
SQDF_WRITTEN_BYTES_SUM | Number of bytes written to the file. |
SQDF_IO_WAIT_SUM | I/O wait duration of the file. |
SQDF_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQDF_ROWID | Unique row number. |
SQDF_READ_IO_WAIT_SUM | Time of read I/O wait on files. |
SQDF_WRITE_IO_WAIT_SUM | Time of write I/O wait on files. |
SQDF_LOGICAL_FILE_ID | ID of the logical file, normalized in table PW_SQFN_FILE_NAMES_N . |
...
Column Name | Column Description |
---|---|
SQDB_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQDB_DATABASE_NAME | Name of the database. |
SQDB_FILE_ID | ID of the file in the database. |
SQDB_SAMPLE_NUMBER | Sample number. 1 is the previous sample. 2 is the current sample. |
SQDB_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 |
SQDB_READS_NUMBER | Number of read requests for the file. |
SQDB_WRITES_NUMBER | Number of write requests for the file. |
SQDB_READS_BYTES | Number of bytes read from the file. |
SQDB_WRITTEN_BYTES | Number of bytes writes to the file. |
SQDB_IO_WAIT | I/O wait duration of the file. |
...
Column Name | Column Description |
---|---|
SQSC_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQSC_CABINET | Name of the cabinet in which the statement is stored. |
SQSC_FOLDER | Name of the folder within the cabinet. |
SQSC_STATEMENT_ID | Unique identifier (string) assigned to the statement. |
SQSC_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value |
PW_SQEO_EXPLN_OPER
Holds information on batch access plans.
Column Name | Column Description |
---|---|
SQEO_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEO_DATABASE_NAME | Name of the database to which the statement belongs. |
SQEO_PARSING_USER | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SQEO_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEO_WORKSHOP_HV | Unique identifier (number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PMDB have the value |
SQEO_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEO_STATEMENT_ID_IN_BATCH | A statement number in the first batch sampled running the statement. |
SQEO_OPERATOR_ID | Sequence order of this operation in the access plan for a statement. |
SQEO_OPERATOR_TYPE | Physical operation in the access plan. |
SQEO_OPTIONS | Logical operation in the access plan. |
SQEO_EXECUTION_ORDER | Sequence order of this operation in the whole access plan. |
SQEO_TREE_LEVEL | Tree level of this operation in the access plan. |
SQEO_ARGUMENTS_LIST | Not in use. |
SQEO_REMOTE_STATEMENT_HV | Unique identifier (number) for the remote query used in this operation. |
SQEO_OBJ_DATABASE_NAME | Database name of the object accessed in this operation. |
SQEO_OBJ_OWNER_NAME | Owner of the object accessed in this operation. |
SQEO_OBJ_NAME | Name of the object accessed in this operation. |
SQEO_INDEX_NAME | Name of the index accessed in this operation. Otherwise NULL. |
SQEO_TOTAL_SUBTREE_COST | Estimated cost of this operation and its descendants. |
SQEO_CONTRIBUTION_RATIO | Contribution value of the object in this operation to the statement. |
SQEO_ESTIMATE_COST | Estimated cost of this operation. |
SQEO_ESTIMATE_IO_COST | Estimated I/O cost of this operation. |
SQEO_ESTIMATE_CPU_COST | Estimated CPU cost of this operation. |
SQEO_ESTIMATE_ROWS | Estimated number of rows returned by this operation. |
SQEO_WARNINGS | Warnings in this operation. |
SQEO_PARALLEL_IND | Indicates if the operation is performed in parallel. |
SQEO_ESTIMATE_EXECUTION | Estimated number of times this operation is performed. |
SQEO_LAST_EXPLAIN_IND | Indicates that this operation belongs to the last explain of the batch. |
SQEO_AVG_ROW_SIZE | Average row size this operation handles. |
...
Holds information on batch execution plans. Each batch can have up to three different execution plans.
Column Name | Column Description |
---|---|
SQEH_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQEH_DATABASE_NAME | Database to which the statement belongs. |
SQEH_PARSING_USER | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch. |
SQEH_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQEH_WORKSHOP_HV | Unique identifier (Number) assigned to statements inserted in the statement workshop workspace. Statements loaded into the PW have the value 0. |
SQEH_EXPLAIN_TIME | Date and time the batch was explained and its access plan was changed. |
SQEH_TOTAL_ESTIMATE_COST | Estimated cost of the batch. |
SQEH_TOTAL_ESTIMATE_IO_COST | Estimated I/O cost of the batch. |
SQEH_TOTAL_ESTIMATE_CPU_COST | Estimated CPU cost of the batch. |
SQEH_TOTAL_ESTIMATE_ROWS | Estimated number of rows returned by the batch. Only rows from SELECT statements are calculated. |
SQEH_LAST_EXPLAIN_IND | Indicates that this access plan is the last access plan of the batch. |
SQEH_ACTUAL_PLAN_IND | An indicator if the execution plan is actual or estimated. |
PW_SQST_STATEMENTS_STATS_T
...
Info |
---|
The _T table summarizes the data per timeslice. The _D table summarizes the data per day. The _W table summarizes the data per week. The _M table summarizes the data per month. |
Column Name | Column Description |
---|---|
SQST_PWII_INSTANCE_ID | ID of the SQL Server instance. |
SQST_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 |
SQST_PWHG_ID | Hour group ID. |
SQST_MINUTES_COUNT_SUM | The timeframe needed to calculated the row, in minutes. |
SQST_DATABASE_ID | Database to which the statement belongs, normalized in table PW_SQDN_DATABASE_NAMES_N . |
SQST_USER_ID | One of the SQL Server users who executed this statement. If this statement is not part of a stored procedure, this is the user used as the parsing user when explaining this batch, normalized in table |
SQST_BATCH_HV | Unique identifier (number) assigned to the batch. |
SQST_STATEMENT_HV | Unique identifier (number) assigned to the statement. |
SQST_COLLAPSED_BATCH_HV | Unique identifier (number) assigned to the batch after replacing the literals with a parameters marker (collapsed form). |
SQST_COLLAPSED_STATEMENT_HV | Unique identifier (number) assigned to the statement in its collapsed form. |
SQST_TOTAL_INMSSQL_TIME_SUM | Indicates the total amount of time SQL Server was actively executing queries. It is also the sum of the columns. |
SQST_NUM_ENDED_EXECUTIONS_SUM | Number of statement executions which ended during the row's timeframe. |
SQST_NUM_EXECUTIONS_NOT_ENDED | Number of statement executions which were still running at the end of the row's timeframe |
SQST_TOTAL_DURATION_SUM | Total amount of time SQL Server spent executing this statement. |
SQST_REQUEST_WAIT_SUM | Not in use in this table. |
SQST_CPU_SUM | Amount of time the process was actively executing a statement. |
SQST_LOCK_WAIT_SUM | Amount of time the process was waiting for locks held by other processes to be released. All types of locks are counted. |
SQST_IO_WAIT_SUM | Amount of time the process was waiting for I/O operations to terminate. |
SQST_REMOTE_WAIT_SUM | Amount of time the process was waiting for a remote query to terminate. |
SQST_LOG_WAIT_SUM | Amount of time the process was waiting for an operation on the log file to terminate. This state is generally encountered during a |
SQST_INTERNAL_WAIT_SUM | Amount of time the process was waiting for an internal resource to be freed. |
SQST_NET_IO_SUM | Amount of time the process was waiting for the client process to acknowledge data sent to it. |
SQST_PARALLEL_EXCHANGE_SUM | Amount of time the thread in a parallel session is waiting for data exchange from another thread. |
SQST_STAT_CPU_SUM | Statistics summing the amount of the process’s read memory usage. |
SQST_STAT_PHYSICAL_IO_SUM | Number of physical disk reads and writes for the process. |
SQST_STAT_MEM_USAGE_MAX | Number of pages in the procedure cache allocated to the process. |
SQST_STAT_OPEN_TRANS_MAX | Number of transactions the process opened. |
SQST_PARALLEL_DEGREE_MIN | Minimum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. |
SQST_PARALLEL_DEGREE_MAX | Maximum number of threads used to execute the statement or batch in parallel. This counter is calculated from the ecid column in sysprocesses. This enables you to verify that SQL Server is using the best execution plan for the current statement. |
SQST_LOCK_ROW_SUM | Amount of time the process was waiting to acquire a lock on a row. |
SQST_LOCK_KEY_SUM | Amount of time the process was waiting to acquire a lock on an index key or an index key range. |
SQST_LOCK_PAGE_SUM | Amount of time the process was waiting to acquire a lock on a table or index page. |
SQST_LOCK_TABLE_SUM | Amount of time the process was waiting to acquire a lock on a table. |
SQST_COMPILE_LOCK_SUM | Amount of time the process was waiting to acquire a lock on a compiled plan for a stored procedure. |
SQST_OTHER_LOCK_SUM | Amount of time the process was waiting to acquire a lock on a process that is unrecognized by Precise for SQL Server. |
SQST_ |
...
RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SQST_SLA_RED_SUM | Number of times the average amount of time SQL Server was actively executing the statement, exceeded the breach threshold for the type of program. |
SQST_SLA_YELLOW_SUM | Number of times the average amount of time SQL Server was actively executing the statement, exceeded the near-breach threshold for the type of program. |
SQST_SLA_GREEN_SUM | Number of times the average amount of time SQL Server was actively executing the statement, was below the near-breach threshold for the type of program. |
SQST_ROWID | Unique row number. |
SQST_NET_IO_WAIT_SUM | Groups all I/O related wait types. |
SQST_TEMP_DB_WAIT_SUM | Groups I/O / Latch on TempDB pages. |
SQST_IDLE_WAIT_SUM | This group includes the events indicating that a session is waiting for something other than a user request. |
SQST_INTRNL_BP_WAIT_SUM | This state groups the events, which all mean contention on pages in the buffer pool. |
SQST_INTRNL_LATCH_WAIT_SUM | This group includes all Latch related wait types. |
SQST_INTRNL_PARALLEL_WAIT_SUM | Amount of time the process was waiting for one of its sub-threads to complete its operation. |
SQST_INTRNL_DTC_WAIT_SUM | Aggregates waits that occur when Distributed Transaction Coordinator sessions are waiting for one another. |
SQST_INTRNL_DBMIRROR_WAIT_SUM | Aggregates a couple of new waits that occur when DB Mirroring is used. |
SQST_INTRNL_PROFILER_WAIT_SUM | Aggregates a number of states associated with the Profiler. |
SQST_INTRNL_MEMORY_WAIT_SUM | Includes wait types, all of which mean that a session is waiting for memory to be allocated to it. |
SQST_INTRNL_BACKUP_WAIT_SUM | Includes write-ups commonly occurring when a session is doing |
...
a BACKUP command. | |
SQST_INTRNL_OTHER_WAIT_SUM | This aggregates all the waits that do not match into any of the Precise for MS-SQL Server states. |
SQST_LOCK_MD_STAT_SUM | Aggregates lock waits of the MetaData Statistics type. |
SQST_LOCK_MD_PART_SUM | Aggregates lock waits of the MetaData Partition Function type. |
SQST_LOCK_MD_OTHER_SUM | Aggregates lock waits of other MetaData types. |
SQST_PC_RECOMPILATIONS_SUM | Number of times this plan has been recompiled while it has remained in the cache. |
SQST_PC_CACHE_EVICTIONS_SUM | Number of times the plan has been evicted from the cache. |
SQST_PC_EXECUTION_COUNT_SUM | Number of times that the plan has been executed. |
SQST_PC_TOTAL_WORKER_TIME_SUM | Amount of CPU time that was consumed by executions of this plan. |
SQST_PC_PHYSICAL_READS_SUM | Number of physical reads performed by executions of this plan. |
SQST_PC_LOGICAL_READS_SUM | Number of logical reads performed by executions of this plan. |
SQST_PC_LOGICAL_WRITES_SUM | Number of logical writes performed by executions of this plan. |
SQST_PC_CLR_TIME_SUM | Time consumed inside CLR objects by executions of this plan. |
SQST_PC_ELAPSED_TIME_SUM | Total elapsed time for completed executions of this plan. |