Properties are grouped below by topic.
| Name |
Description |
Typical values |
| active_session_count |
The number of active sessions on the instance |
|
| activity_active_sessions |
The current active session count |
|
| activity_active_sessions_score |
A score derived from the active session count |
|
| activity_cpu_count |
The number of CPUs on the instance |
|
| activity_cpu_idle_usage |
Average CPU idle usage percentage |
|
| activity_cpu_other_usage |
Average CPU usage by other processes |
|
| activity_cpu_sql_usage |
Average CPU usage by SQL Server |
|
| activity_disk_reads |
Disk reads per second |
|
| activity_disk_reads_counter |
The current disk read counter |
|
| activity_disk_reads_lasttime |
The last disk read sample time in milliseconds since 1970 |
|
| activity_disk_reads_score |
A score derived from the disk read rate |
|
| activity_disk_writes |
Disk writes per second |
|
| activity_disk_writes_counter |
The current disk write counter |
|
| activity_disk_writes_lasttime |
The last disk write sample time in milliseconds since 1970 |
|
| activity_disk_writes_score |
A score derived from the disk write rate |
|
| activity_dtu_test |
|
|
| activity_log_bytes_flushed |
Log bytes flushed per second |
|
| activity_log_bytes_flushed_counter |
The current log bytes flushed counter |
|
| activity_log_bytes_flushed_dif_counter |
The delta in log bytes flushed since the last sample |
|
| activity_log_bytes_flushed_last_counter |
The previous log bytes flushed counter |
|
| activity_log_bytes_flushed_lasttime |
The last log bytes flushed sample time in milliseconds since 1970 |
|
| activity_log_bytes_flushed_score |
A score derived from the log bytes flushed rate |
|
| activity_logical_reads |
Logical reads per second |
|
| activity_logical_reads_counter |
The current logical reads counter |
|
| activity_logical_reads_dif_counter |
The delta in logical reads since the last sample |
|
| activity_logical_reads_last_counter |
The previous logical reads counter |
|
| activity_logical_reads_lasttime |
The last logical reads sample time in milliseconds since 1970 |
|
| activity_logical_reads_score |
A score derived from the logical reads rate |
|
| activity_physical_reads |
|
|
| activity_total_sessions |
The total number of sessions on the instance |
|
| activity_transaction_writes |
|
|
| activity_transaction_writes_counter |
|
|
| activity_waits |
Wait statistics for the instance |
|
| cpu_load_histr_sec |
CPU load history in seconds since 1970 |
|
| cpu_load_histr_sec/date_val |
The history date |
|
| cpu_load_histr_sec/Other_CPU |
Other CPU usage |
|
| cpu_load_histr_sec/SQL_Server_CPU |
SQL Server CPU usage |
|
| cpu_physical |
The number of physical CPUs |
|
| cpu_usage_before_pnd |
|
|
| cpu_usage_before_py |
|
|
| cpu_usage_eh_before_pnd |
|
|
| cpu_usage_eh_before_py |
|
|
| cpu_usage_eh_now_pnd |
|
|
| cpu_usage_eh_now_py |
|
|
| cpu_usage_eh_variation_pnd |
|
|
| cpu_usage_eh_variation_py |
|
|
| cpu_usage_nh_before_pnd |
|
|
| cpu_usage_nh_before_py |
|
|
| cpu_usage_nh_now_pnd |
|
|
| cpu_usage_nh_now_py |
|
|
| cpu_usage_nh_variation_pnd |
|
|
| cpu_usage_nh_variation_py |
|
|
| cpu_usage_now_pnd |
|
|
| cpu_usage_now_py |
|
|
| cpu_usage_variation_d_pnd |
|
|
| cpu_usage_variation_d_py |
|
|
| cpu_usage_variation_pnd |
|
|
| cpu_usage_variation_py |
|
|
| cpu_usage_wh_before_pnd |
|
|
| cpu_usage_wh_before_py |
|
|
| cpu_usage_wh_now_pnd |
|
|
| cpu_usage_wh_now_py |
|
|
| cpu_usage_wh_variation_pnd |
|
|
| cpu_usage_wh_variation_py |
|
|
| current_month_seconds_down |
Seconds down during the current month |
|
| current_month_uptime_pct |
Uptime percentage for the current month |
|
| current_month_value |
The uptime value for the current month |
|
| current_uptime |
Current uptime |
|
| current_uptime_days |
Current uptime in days |
|
| current_uptime_hours |
Current uptime in hours |
|
| current_uptime_minutes |
Current uptime in minutes |
|
| down_period |
Uptime gap information |
|
| down_period/day_of_week |
Day of week when the instance started |
|
| down_period/days_down |
Days the instance was down |
|
| down_period/last_conn_sec_1970 |
Last dbWatch connection time in seconds since 1970 |
|
| down_period/last_dbwatch_connection |
Last dbWatch connection |
|
| down_period/minutes_down |
Minutes the instance was down |
|
| down_period/period_txt |
Text representation of the down period |
|
| down_period/seconds_down |
Seconds the instance was down |
|
| down_period/started |
Instance startup time |
|
| down_period/started_sec_1970 |
Instance startup time in seconds since 1970 |
|
| dtu_limit |
DTU limit details |
|
| dtu_limit/dtu_cpu_pct_usage |
DTU CPU usage percentage |
|
| dtu_limit/dtu_data_io_pct_usage |
DTU data I/O usage percentage |
|
| dtu_limit/dtu_db_name |
Database name |
|
| dtu_limit/dtu_idle_pct_usage |
DTU idle percentage |
|
| dtu_limit/dtu_log_write_pct_usage |
DTU log write usage percentage |
|
| dtu_limit/dtu_memory_pct_usage |
DTU memory usage percentage |
|
| dtu_limit/dtu_session_pct_usage |
DTU session usage percentage |
|
| dtu_limit/dtu_storage_pct_usage |
DTU storage usage percentage |
|
| dtu_limit/dtu_time |
Sample time |
|
| dtu_limit/dtu_worker_pct_usage |
DTU worker usage percentage |
|
| inst_data_cache |
Current data cache usage |
|
| inst_data_cache_avg |
Average data cache usage |
|
| inst_data_cache_avg_var |
Variation in average data cache usage |
|
| inst_data_cache_pct |
Data cache usage as a percentage of total instance memory |
|
| inst_mem_avg |
Average instance memory usage |
|
| inst_mem_avg_var |
Variation in average instance memory usage |
|
| inst_mem_curr |
Current instance memory usage |
|
| inst_mem_limit |
Maximum instance memory limit |
|
| inst_mem_limit_char |
Maximum allowed instance memory limit |
|
| inst_mem_param_bcu_thr |
Buffer cache usage threshold |
|
| inst_mem_param_max_mem |
Maximum memory usage setting |
|
| inst_mem_param_mem_reduction |
Whether memory reduction is enabled |
|
| inst_mem_param_min_mem |
Minimum memory usage setting |
|
| inst_mem_phys_pct |
Physical memory usage percentage |
|
| inst_mem_reduction_candidate |
Whether the instance is a candidate for memory reduction |
|
| inst_mem_reduction_last_period_init_max_mem |
Initial max memory from the last reduction period |
|
| inst_mem_reduction_last_period_init_mem |
Initial memory usage from the last reduction period |
|
| inst_mem_reduction_period_count |
Number of memory reduction periods |
|
| inst_mem_reduction_used |
Whether memory reduction is used |
|
| inst_mem_targ_avg |
Average target memory |
|
| inst_mem_targ_avg_var |
Variation in average target memory |
|
| inst_mem_usage_variation_d_pnd |
Number of days used for the 90-day memory variation check |
|
| inst_mem_usage_variation_d_py |
Number of days used for the 365-day memory variation check |
|
| inst_mem_usage_variation_GB_pnd |
Memory usage variation over 90 days in GB |
|
| inst_mem_usage_variation_GB_py |
Memory usage variation over 365 days in GB |
|
| inst_mem_usage_variation_MB_pnd |
Memory usage variation over 90 days in MB |
|
| inst_mem_usage_variation_MB_py |
Memory usage variation over 365 days in MB |
|
| last_month_seconds_down |
Seconds down during the last month |
|
| last_month_uptime_pct |
Uptime percentage for the last month |
|
| last_month_value |
The uptime value for the last month |
|
| memory_usage |
The approximate memory usage (in MB) for the instance |
2450 |
| operations_uptime_pct |
Operational uptime percentage |
|
| operations_uptime_sec_down |
Operational downtime in seconds |
|
| operations_uptime_sql |
SQL used to calculate operational uptime |
|
| physical_memory_mb |
Physical memory in MB |
|
| ratio_avg |
Average data hit ratio |
|
| ratio_avg_eh |
Average data hit ratio for EH |
|
| ratio_avg_nh |
Average data hit ratio for NH |
|
| ratio_avg_wh |
Average data hit ratio for WH |
|
| session_load_histr_sec |
Session load history in seconds since 1970 |
|
| session_load_histr_sec/active |
Active sessions |
|
| session_load_histr_sec/date_val |
The history date |
|
| session_load_histr_sec/total |
Total sessions |
|
| strength_cpu |
CPU strength score |
|
| strength_disk_io |
Disk I/O strength score |
|
| strength_disk_space |
Disk space strength score |
|
| strength_memory |
Memory strength score |
|
| total_logical_reads |
Total logical reads |
|
| Name |
Description |
Typical values |
| alerts_history_sec |
|
|
| alerts_history_sec/job_name |
Job name |
|
| alerts_history_sec/status |
|
|
| alerts_history_sec/time_stamp_txt |
|
|
| alerts_per_day_histr_sec |
|
|
| alerts_per_day_histr_sec/alarm_count |
|
|
| alerts_per_day_histr_sec/alert_count |
|
|
| alerts_per_day_histr_sec/last_alert_txt |
|
|
| alerts_per_day_histr_sec/warning_count |
|
|
| db_centric_alert_id |
|
|
| db_centric_alert_id/alert_name |
|
|
| db_centric_alert_id/db_name |
|
|
| db_centric_alert_id/db_status |
|
|
| db_centric_alert_id/details |
|
|
| db_centric_alert_id/last_run |
|
|
| db_centric_alert_id/status |
|
|
| inst_err_log_alerting_status |
|
|
| inst_err_log_avg_max_records_read_aggr_last_7d |
|
|
| inst_err_log_avg_records_read_last_24h |
|
|
| inst_err_log_avg_time_read_last_24h |
|
|
| inst_err_log_avg_tot_records_read_aggr_last_7d |
|
|
| inst_err_log_avg_tot_time_read_aggr_last_7d |
|
|
| inst_err_log_details_count |
|
|
| inst_err_log_error_count_last_24h |
|
|
| inst_err_log_error_count_last_7d |
|
|
| inst_err_log_error_file_count |
|
|
| inst_err_log_error_file_tot_size_MB |
|
|
| inst_err_log_file_count_var24 |
|
|
| inst_err_log_file_max_size_MB |
|
|
| inst_err_log_file_name |
|
|
| inst_err_log_file_name/inst_err_log_file_cr_date_char |
|
|
| inst_err_log_file_name/inst_err_log_file_size_KB |
|
|
| inst_err_log_file_name_max_size |
|
|
| inst_err_log_file_size_var24 |
|
|
| inst_err_log_last_error_date |
|
|
| inst_err_log_last_executed |
|
|
| inst_err_log_max_max_records_read_aggr_last_7d |
|
|
| inst_err_log_max_records_read_last_24h |
|
|
| inst_err_log_max_time_read_last_24h |
|
|
| inst_err_log_max_tot_records_read_aggr_last_7d |
|
|
| inst_err_log_max_tot_time_read_aggr_last_7d |
|
|
| issues_date |
|
|
| issues_date/issues_count |
|
|
| issues_per_day_histr_sec |
|
|
| issues_per_day_histr_sec/histr_date |
|
|
| issues_per_day_histr_sec/job_count |
|
|
| issues_per_day_histr_sec/job_warnings |
|
|
| issues_per_day_histr_sec/sc_warnings |
|
|
| sc_alert_job_count |
|
|
| sc_disable_job_count |
|
|
| sc_issues_count_current |
|
|
| sc_job_count |
|
|
| sc_task_id |
|
|
| sc_task_id/sc_details |
|
|
| sc_task_id/sc_last_run |
|
|
| sc_task_id/sc_name |
|
|
| sc_task_id/sc_status |
|
|
| sc_task_id/sc_status_job |
|
|
| Name |
Description |
Typical values |
| alwayson_active |
Whether Always On is enabled |
|
| alwayson_cluster_name |
|
|
| cluster |
|
|
| cluster_instances |
|
|
| cluster_instances/host_name |
|
|
| cluster_instances/instance_name_port |
|
|
| cluster_member_name |
|
|
| cluster_member_name/member_state_desc |
|
|
| cluster_member_name/member_type_desc |
|
|
| cluster_member_name/number_of_quorum_votes |
|
|
| primary_ag_count |
|
|
| primary_ag_present |
|
|
| replica_server_group_db_id |
|
|
| replica_server_group_db_id/availability_group_name |
|
|
| replica_server_group_db_id/database_name |
|
|
| replica_server_group_db_id/estimated_redo_lag_seconds |
|
|
| replica_server_group_db_id/estimated_send_lag_seconds |
|
|
| replica_server_group_db_id/is_primary_replica |
Whether this is the primary replica |
|
| replica_server_group_db_id/last_commit_time |
|
|
| replica_server_group_db_id/last_hardened_time |
|
|
| replica_server_group_db_id/last_received_time |
|
|
| replica_server_group_db_id/last_redone_time |
|
|
| replica_server_group_db_id/last_sent_time |
|
|
| replica_server_group_db_id/log_send_queue_size |
|
|
| replica_server_group_db_id/log_send_rate |
|
|
| replica_server_group_db_id/redo_queue_size |
|
|
| replica_server_group_db_id/redo_rate |
|
|
| replica_server_group_db_id/replica_server_name |
|
|
| replica_server_group_db_id/synchronization_health_desc |
|
|
| replica_server_group_db_id/synchronization_state_desc |
|
|
| secondary_ag_count |
|
|
| secondary_ag_present |
|
|
| synch_database |
|
|
| synch_database/synch_database_org |
|
|
| synch_database/synch_database_par |
|
|
| synch_database/synch_db_create_date |
|
|
| synch_database/synch_first_dbw_update_org |
|
|
| synch_database/synch_first_dbw_update_par |
|
|
| synch_database/synch_last_dbw_update_org |
|
|
| synch_database/synch_last_dbw_update_org_char |
|
|
| synch_database/synch_last_dbw_update_par |
|
|
| synch_database/synch_last_dbw_update_par_char |
|
|
| synch_database/synch_multi_count |
|
|
| synch_database/synch_server |
|
|
| synch_database/synch_server_org |
|
|
| synch_database/synch_server_par |
|
|
| synch_db_count |
|
|
| synch_db_count_current_ints |
|
|
| synch_db_count_multi |
|
|
| synch_db_count_remote_inst |
|
|
| Name |
Description |
Typical values |
| backup |
|
|
| backup/backup_pref |
Backup preference |
|
| backup/compress_ratio |
|
|
| backup/compressed_size_mb |
|
|
| backup/curr_inst |
|
|
| backup/db_name_plus_inst_name |
|
|
| backup/elaps_time |
|
|
| backup/finish |
|
|
| backup/finish_mi |
|
|
| backup/gr_name |
|
|
| backup/is_copy_only |
|
|
| backup/pri_inst |
|
|
| backup/size_mb |
|
|
| backup/start |
|
|
| backup/status |
|
|
| backup/type |
|
|
| backup_day_no |
|
|
| backup_day_no/backup_count_per_day |
|
|
| backup_day_no/day |
|
|
| backup_day_no/first_backup |
|
|
| backup_day_no/last_backup |
|
|
| backup_day_no/max_size_compr_mb |
|
|
| backup_day_no/min_size_compr_mb |
|
|
| backup_day_no/stdev_size_compr_mb |
|
|
| backup_day_no/sum_size_compr_mb |
|
|
| backup_excl_copy_only |
|
|
| backup_excl_copy_only/backup_pref |
|
|
| backup_excl_copy_only/compress_ratio |
|
|
| backup_excl_copy_only/compressed_size_mb |
|
|
| backup_excl_copy_only/curr_inst |
|
|
| backup_excl_copy_only/db_name_plus_inst_name |
|
|
| backup_excl_copy_only/elaps_time |
|
|
| backup_excl_copy_only/finish |
|
|
| backup_excl_copy_only/finish_mi |
|
|
| backup_excl_copy_only/gr_name |
|
|
| backup_excl_copy_only/is_copy_only |
|
|
| backup_excl_copy_only/pri_inst |
|
|
| backup_excl_copy_only/size_mb |
|
|
| backup_excl_copy_only/start |
|
|
| backup_excl_copy_only/status |
|
|
| backup_excl_copy_only/type |
|
|
| backup_histr |
|
|
| backup_histr/avg_backup_count_per_day |
|
|
| backup_histr/avg_compr_backup_size_mb_per_day |
|
|
| backup_histr/backup_days_per_week |
|
|
| backup_histr/backup_days_per_week_bar |
|
|
| backup_histr/backup_days_per_week_check |
|
|
| backup_histr/first_backup_time |
|
|
| backup_histr/last_backup_time |
|
|
| backup_histr/stdev_backup_count_per_day |
|
|
| backup_histr/sum_compr_backup_size_mb_per_week |
|
|
| differential_backup |
|
|
| differential_backup/backup_pref |
|
|
| differential_backup/compress_ratio |
|
|
| differential_backup/compressed_size_mb |
|
|
| differential_backup/curr_inst |
|
|
| differential_backup/db_name_plus_inst_name |
|
|
| differential_backup/elaps_time |
|
|
| differential_backup/finish |
|
|
| differential_backup/finish_mi |
|
|
| differential_backup/gr_name |
|
|
| differential_backup/is_copy_only |
|
|
| differential_backup/pri_inst |
|
|
| differential_backup/size_mb |
|
|
| differential_backup/start |
|
|
| differential_backup/status |
|
|
| differential_backup/type |
|
|
| differential_backup_excl_copy_only |
|
|
| differential_backup_excl_copy_only/backup_pref |
|
|
| differential_backup_excl_copy_only/compress_ratio |
|
|
| differential_backup_excl_copy_only/compressed_size_mb |
|
|
| differential_backup_excl_copy_only/curr_inst |
|
|
| differential_backup_excl_copy_only/db_name_plus_inst_name |
|
|
| differential_backup_excl_copy_only/elaps_time |
|
|
| differential_backup_excl_copy_only/finish |
|
|
| differential_backup_excl_copy_only/finish_mi |
|
|
| differential_backup_excl_copy_only/gr_name |
|
|
| differential_backup_excl_copy_only/is_copy_only |
|
|
| differential_backup_excl_copy_only/pri_inst |
|
|
| differential_backup_excl_copy_only/size_mb |
|
|
| differential_backup_excl_copy_only/start |
|
|
| differential_backup_excl_copy_only/status |
|
|
| differential_backup_excl_copy_only/type |
|
|
| pull_backup_error_id |
|
|
| pull_backup_error_id/db_name |
|
|
| pull_backup_error_id/dbw_message |
|
|
| pull_backup_error_id/DDL_cmd |
|
|
| pull_backup_error_id/error_message |
|
|
| pull_backup_error_id/source_instance |
|
|
| pull_backup_from_devices_restore_date |
|
|
| pull_backup_from_devices_status |
|
|
| pull_backup_from_devices_trace_info |
|
|
| pull_backup_id |
|
|
| pull_backup_id/db_count |
|
|
| pull_backup_id/elap_time_sec |
|
|
| pull_backup_id/errors |
|
|
| pull_backup_id/exec_end_1970 |
|
|
| pull_backup_id/exec_end_txt |
|
|
| pull_backup_id/exec_start_1970 |
|
|
| pull_backup_id/exec_start_txt |
|
|
| pull_backup_id/last_db |
|
|
| pull_backup_id/login_info |
|
|
| pull_backup_id/returned_status_id |
|
|
| pull_backup_id/returned_status_txt |
|
|
| push_backup_error_db |
|
|
| push_backup_error_db/dbw_message |
|
|
| push_backup_error_db/DDL_cmd |
|
|
| push_backup_error_db/error_message |
|
|
| push_backup_id |
|
|
| push_backup_id/db_count |
|
|
| push_backup_id/elap_time_sec |
|
|
| push_backup_id/errors |
|
|
| push_backup_id/exec_end_1970 |
|
|
| push_backup_id/exec_end_txt |
|
|
| push_backup_id/exec_start_1970 |
|
|
| push_backup_id/exec_start_txt |
|
|
| push_backup_id/last_db |
|
|
| push_backup_id/login_info |
|
|
| push_backup_id/returned_status_id |
|
|
| push_backup_id/returned_status_txt |
|
|
| tr_backup_comp_ratio_all_last_day |
|
|
| tr_backup_comp_ratio_all_last_week |
|
|
| tr_backup_comp_size_GB_all_last_day |
|
|
| tr_backup_comp_size_GB_all_last_week |
|
|
| tr_backup_comp_size_MB_all_avg_per_day_last_week |
|
|
| tr_backup_comp_size_MB_all_last_day |
|
|
| tr_backup_comp_size_MB_all_last_week |
|
|
| tr_backup_db_count_last_day |
|
|
| tr_backup_db_count_last_week |
|
|
| tr_backup_file_count_avg_last_day |
|
|
| tr_backup_file_count_avg_last_week |
|
|
| tr_backup_file_count_last_day |
|
|
| tr_backup_file_count_last_week |
|
|
| tr_backup_file_count_max_last_day |
|
|
| tr_backup_file_count_max_last_week |
|
|
| tr_backup_file_count_min_last_day |
|
|
| tr_backup_file_count_min_last_week |
|
|
| tr_backup_size_GB_all_last_day |
|
|
| tr_backup_size_GB_all_last_week |
|
|
| tr_backup_size_MB_all_avg_per_day_last_week |
|
|
| tr_backup_size_MB_all_last_day |
|
|
| tr_backup_size_MB_all_last_week |
|
|
| Name |
Description |
Typical values |
| curr_dbname |
|
|
| data_cache_rank |
|
|
| data_cache_rank/dc_db_name |
|
|
| data_cache_rank/dc_mb_usage |
|
|
| data_cache_rank/dc_pct_usage |
|
|
| database |
|
|
| database/compatibility |
|
|
| database/compatibility_diff_value |
|
|
| database/compatibility_status |
|
|
| database/compatibility_value |
|
|
| database/created |
|
|
| database/db_id |
|
|
| database/recovery_model |
|
|
| database/replicated |
|
|
| database/same_compatibility |
|
|
| database/server_compatibility |
|
|
| database/server_version |
|
|
| database/short_name |
|
|
| database/status |
|
|
| database_growth_histr_sec |
|
|
| database_growth_histr_sec/data_file_size |
|
|
| database_growth_histr_sec/date_val |
|
|
| database_growth_histr_sec/db_name |
|
|
| database_growth_histr_sec/total_size |
|
|
| database_growth_histr_sec/tr_log_file_size |
|
|
| database_growth_rate_ID |
|
|
| database_growth_rate_ID/dbname |
|
|
| database_growth_rate_ID/histr_date_sec_1970 |
|
|
| database_growth_rate_ID/histr_date_txt |
|
|
| database_growth_rate_ID/size |
|
|
| db_count |
The number of databases on the instance |
23 |
| db_count_full_recovery_mode |
|
|
| db_full_backup_comp_ratio_all |
|
|
| db_full_backup_comp_size_GB_all |
|
|
| db_full_backup_comp_size_MB_all |
|
|
| db_full_backup_count_all |
|
|
| db_full_backup_duration_hours_all |
|
|
| db_full_backup_duration_minutes_all |
|
|
| db_full_backup_end_last_all |
|
|
| db_full_backup_size_GB_all |
|
|
| db_full_backup_size_MB_all |
|
|
| db_full_backup_start_first_all |
|
|
| db_name_growth |
|
|
| db_name_growth/data_size_MB |
|
|
| db_name_growth/file_count |
|
|
| db_name_growth/log_size_MB |
|
|
| db_name_growth/tot_size_MB |
|
|
| db_NOT_IN_USE_collector_days_monitored |
|
|
| db_NOT_IN_USE_collector_db_count |
|
|
| db_NOT_IN_USE_collector_last_date |
|
|
| db_NOT_IN_USE_collector_start_date |
|
|
| db_NOT_IN_USE_id |
|
|
| db_NOT_IN_USE_id/avg_activity_minutes |
|
|
| db_NOT_IN_USE_id/avg_activity_pct |
|
|
| db_NOT_IN_USE_id/avg_connections |
|
|
| db_NOT_IN_USE_id/avg_KB_flushed |
|
|
| db_NOT_IN_USE_id/db_name |
|
|
| db_NOT_IN_USE_id/last_date |
|
|
| db_NOT_IN_USE_id/last_date_s_1970 |
|
|
| db_NOT_IN_USE_id/monitored_days |
|
|
| db_NOT_IN_USE_id/monitoring_start |
|
|
| db_NOT_IN_USE_id/monitoring_start_s_1970 |
|
|
| dbfile_id |
|
|
| dbfile_id/db_name |
|
|
| dbfile_id/file_id |
|
|
| dbfile_id/file_location |
|
|
| dbfile_id/file_type |
|
|
| dbfile_id/host_name |
|
|
| dbfile_id/instance_name |
|
|
| dbfile_id/logical_name |
|
|
| dbfile_id/space_used_mb |
|
|
| default_data_path |
|
|
| default_log_path |
|
|
| default_windows_domain |
|
|
| device_id |
|
|
| device_id/compatibility_level |
|
|
| device_id/db_name |
|
|
| device_id/dev_location |
|
|
| device_id/dev_name |
|
|
| device_id/host_name |
|
|
| device_id/instance_name |
|
|
| device_id/last_backup_1970 |
|
|
| device_id/last_backup_1970_UTR |
|
|
| device_id/last_backup_txt |
|
|
| device_pull_test |
|
|
| disk_usage |
The approximate disk usage (in GB) for the instance |
45.3 |
| disk_usage_mb |
|
|
| fg_count_all |
|
|
| fg_growth_GB_all |
|
|
| fg_growth_MB_all |
|
|
| fg_size_GB_all |
|
|
| fg_size_MB_all |
|
|
| fg_space_used_GB_all |
|
|
| fg_space_used_MB_all |
|
|
| filegr_dbw_id |
|
|
| filegr_dbw_id/fg_db_name |
|
|
| filegr_dbw_id/fg_growth_GB |
|
|
| filegr_dbw_id/fg_growth_MB |
|
|
| filegr_dbw_id/fg_name |
|
|
| filegr_dbw_id/fg_size_GB |
|
|
| filegr_dbw_id/fg_size_MB |
|
|
| filegr_dbw_id/fg_space_used_GB |
|
|
| filegr_dbw_id/fg_space_used_MB |
|
|
| target_memory_mb |
|
|
| tempdb_file_rank |
|
|
| tempdb_file_rank/drive |
|
|
| tempdb_file_rank/free_MB |
|
|
| tempdb_file_rank/name |
|
|
| tempdb_file_rank/pct_usage |
|
|
| tempdb_file_rank/size_MB |
|
|
| tempdb_files_count |
|
|
| tempdb_files_size_MB |
|
|
| tempdb_space_usage_MB |
|
|
| tempdb_stdev_size |
|
|
| tempdb_stdev_usage |
|
|
| volume_count |
|
|
| volume_drive_name |
|
|
| volume_drive_name/data_file_count |
|
|
| volume_drive_name/free_GB |
|
|
| volume_drive_name/size_GB |
|
|
| volume_drive_name/tr_log_file_count |
|
|
| volume_drive_name/used_by_data_files_GB |
|
|
| volume_drive_name/used_by_external_files_GB |
|
|
| volume_drive_name/used_by_tr_log_files_GB |
|
|
| volume_drive_name/used_GB |
|
|
| volume_growth_rank_nd |
|
|
| volume_growth_rank_nd/days_data_basis |
|
|
| volume_growth_rank_nd/free_GB |
|
|
| volume_growth_rank_nd/growth_GB |
|
|
| volume_growth_rank_nd/name |
|
|
| volume_growth_rank_nd/pct_usage_within_nd |
|
|
| volume_growth_rank_nd/pct_usage_within_year |
|
|
| volume_growth_rank_y |
|
|
| volume_growth_rank_y/days_data_basis |
|
|
| volume_growth_rank_y/free_GB |
|
|
| volume_growth_rank_y/growth_GB |
|
|
| volume_growth_rank_y/name |
|
|
| volume_growth_rank_y/pct_usage_within_year |
|
|
| volume_rank |
|
|
| volume_rank/volume_free_GB |
|
|
| volume_rank/volume_name |
|
|
| volume_rank/volume_pct_usage |
|
|
| volume_rank/volume_size_GB |
|
|
| Name |
Description |
Typical values |
| blitz_kit_in_use |
|
|
| blitz_kit_index_avg_exec_time |
|
|
| blitz_kit_index_blobs_size_kb |
|
|
| blitz_kit_index_last_exec_time |
|
|
| blitz_kit_index_max_exec_time |
|
|
| blitz_kit_index_min_exec_time |
|
|
| blitz_kit_index_new_histr_records |
|
|
| blitz_kit_index_table_size_kb |
|
|
| blitz_kit_index_total_histr_records |
|
|
| blitz_kit_lock_avg_exec_time |
|
|
| blitz_kit_lock_blobs_size_kb |
|
|
| blitz_kit_lock_last_exec_time |
|
|
| blitz_kit_lock_max_exec_time |
|
|
| blitz_kit_lock_min_exec_time |
|
|
| blitz_kit_lock_new_histr_records |
|
|
| blitz_kit_lock_table_size_kb |
|
|
| blitz_kit_lock_total_histr_records |
|
|
| blitz_kit_who_avg_exec_time |
|
|
| blitz_kit_who_blobs_size_kb |
|
|
| blitz_kit_who_last_exec_time |
|
|
| blitz_kit_who_max_exec_time |
|
|
| blitz_kit_who_min_exec_time |
|
|
| blitz_kit_who_new_histr_records |
|
|
| blitz_kit_who_table_size_kb |
|
|
| blitz_kit_who_total_histr_records |
|
|
| blitz_obj_duplicates |
|
|
| blitz_obj_duplicates/duplicates_count |
|
|
| blitz_obj_id |
|
|
| blitz_obj_id/created |
|
|
| blitz_obj_id/db_name |
|
|
| blitz_obj_id/obj_name |
|
|
| blitz_obj_id/obj_type |
|
|
| blitz_obj_id/sch_name |
|
|
| blitz_obj_id/version |
|
|
| blitz_obj_id/version_date |
|
|
| cleanup_msdb_back_enabled |
|
|
| cleanup_msdb_back_rec |
|
|
| cleanup_msdb_cur_back_rec |
|
|
| cleanup_msdb_cur_del_thr |
|
|
| cleanup_msdb_cur_job_rec |
|
|
| cleanup_msdb_cur_maint_pl_det_rec |
|
|
| cleanup_msdb_cur_maint_pl_rec |
|
|
| cleanup_msdb_cur_oldest_back_dd |
|
|
| cleanup_msdb_cur_oldest_back_rec |
|
|
| cleanup_msdb_cur_oldest_job_dd |
|
|
| cleanup_msdb_cur_oldest_job_rec |
|
|
| cleanup_msdb_cur_oldest_maint_pl_dd |
|
|
| cleanup_msdb_cur_oldest_maint_pl_det_dd |
|
|
| cleanup_msdb_cur_oldest_maint_pl_det_rec |
|
|
| cleanup_msdb_cur_oldest_maint_pl_rec |
|
|
| cleanup_msdb_data_size_MB |
|
|
| cleanup_msdb_del_back_rec |
|
|
| cleanup_msdb_del_job_rec |
|
|
| cleanup_msdb_del_mait_pl_rec |
|
|
| cleanup_msdb_del_thr |
|
|
| cleanup_msdb_job_enabled |
|
|
| cleanup_msdb_job_rec |
|
|
| cleanup_msdb_last_deleted |
|
|
| cleanup_msdb_log_size_MB |
|
|
| cleanup_msdb_maint_pl_enabled |
|
|
| cleanup_msdb_mait_pl_rec |
|
|
| cleanup_msdb_severity |
|
|
| cleanup_msdb_severity_desc |
|
|
| cleanup_msdb_severity_desc_list |
|
|
| dbcc_avg_elap_mi |
|
|
| dbcc_db_count |
|
|
| dbcc_elap_char |
|
|
| dbcc_elap_mi |
|
|
| dbcc_end |
|
|
| dbcc_end_dd_ago |
|
|
| dbcc_err_count |
|
|
| dbcc_err_date |
|
|
| dbcc_err_date/days_ago |
|
|
| dbcc_err_date/db_name |
|
|
| dbcc_err_date/elaps_time |
|
|
| dbcc_err_date/error_no |
|
|
| dbcc_err_date/massage |
|
|
| dbcc_err_date/phys_only |
|
|
| dbcc_last_db |
|
|
| dbcc_last_db_nice |
|
|
| dbcc_max_elap_mi |
|
|
| dbcc_min_elap_mi |
|
|
| dbcc_severity |
|
|
| dbcc_severity_desc |
|
|
| dbcc_severity_desc_list |
|
|
| dbcc_start |
|
|
| dbcc_variation |
|
|
| dbw_db_maintenance_period_count |
|
|
| dbw_db_maintenance_period_id |
|
|
| dbw_db_maintenance_period_id/comment |
|
|
| dbw_db_maintenance_period_id/created_char |
|
|
| dbw_db_maintenance_period_id/created_sec_1970 |
|
|
| dbw_db_maintenance_period_id/end_char |
|
|
| dbw_db_maintenance_period_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_id/name |
|
|
| dbw_db_maintenance_period_id/start_char |
|
|
| dbw_db_maintenance_period_id/start_sec_1970 |
|
|
| dbw_db_maintenance_period_last_id |
|
|
| dbw_db_maintenance_period_last_id/duration_hours |
|
|
| dbw_db_maintenance_period_last_id/end_char |
|
|
| dbw_db_maintenance_period_last_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_last_id/name |
|
|
| dbw_db_maintenance_period_last_id/start_char |
|
|
| dbw_db_maintenance_period_last_id/start_sec_1970 |
|
|
| dbw_db_maintenance_period_next_id |
|
|
| dbw_db_maintenance_period_next_id/duration_hours |
|
|
| dbw_db_maintenance_period_next_id/end_char |
|
|
| dbw_db_maintenance_period_next_id/end_sec_1970 |
|
|
| dbw_db_maintenance_period_next_id/name |
|
|
| dbw_db_maintenance_period_next_id/start_char |
|
|
| dbw_db_maintenance_period_next_id/start_sec_1970 |
|
|
| dbw_engine_alert |
|
|
| dbw_engine_alert/alert_count |
|
|
| dbw_engine_alert/frequency |
|
|
| dbw_engine_alert/frequency_days |
|
|
| dbw_engine_alert/frequency_hours |
|
|
| dbw_engine_alert/frequency_minutes |
|
|
| dbw_engine_alert/frequency_months |
|
|
| dbw_engine_alert/frequency_weeks |
|
|
| dbw_engine_alert/last_date |
|
|
| dbw_engine_alert/last_date_in_days |
|
|
| dbw_engine_alert/oldes_date |
|
|
| dbw_engine_tables |
|
|
| dbw_engine_tables/analyzed |
|
|
| dbw_engine_tables/created |
|
|
| dbw_engine_tables/db_id |
|
|
| dbw_engine_tables/location |
|
|
| dbw_engine_tables/modified |
|
|
| dbw_engine_tables/obj_id |
|
|
| dbw_engine_tables/rows |
|
|
| dbw_engine_tables/size_mb |
|
|
| dbw_engine_tables/table_type |
|
|
| dbw_engine_tables_with_lobs |
|
|
| dbw_engine_tables_with_lobs/db_id |
|
|
| dbw_engine_tables_with_lobs/lob_size_mb |
|
|
| dbw_engine_tables_with_lobs/obj_id |
|
|
| dbw_ms_agent_jobs_count |
|
|
| dbw_ms_agent_jobs_installed |
|
|
| dbw_ms_agent_jobs_last_executed |
|
|
| full_scans |
|
|
| idx_stat_db_count |
|
|
| idx_stat_elap_avg_mi |
|
|
| idx_stat_elap_max_mi |
|
|
| idx_stat_elap_mi |
|
|
| idx_stat_elap_min_mi |
|
|
| idx_stat_end_anlz |
|
|
| idx_stat_end_anlz_dd |
|
|
| idx_stat_error |
|
|
| idx_stat_idx_anlz |
|
|
| idx_stat_idx_count |
|
|
| idx_stat_last_db |
|
|
| idx_stat_last_db_nice |
|
|
| idx_stat_severity |
|
|
| idx_stat_severity_desc |
|
|
| idx_stat_severity_desc_list |
|
|
| idx_stat_start_anlz |
|
|
| idx_stat_stdev_mi |
|
|
| idx_stat_stdev_pct |
|
|
| index_scans |
|
|
| index_usage_stat_db_checked |
|
|
| index_usage_stat_db_count |
|
|
| index_usage_stat_db_skiped |
|
|
| index_usage_stat_elap_char |
|
|
| index_usage_stat_elap_sec |
|
|
| index_usage_stat_end |
|
|
| index_usage_stat_last_db |
|
|
| index_usage_stat_max_obj |
|
|
| index_usage_stat_min_size |
|
|
| index_usage_stat_obj_checked |
|
|
| index_usage_stat_obj_collected |
|
|
| index_usage_stat_obj_collected_and_deleted |
|
|
| index_usage_stat_start |
|
|
| instaled_job_missing_object |
|
|
| instaled_job_missing_object/obj_count |
|
|
| instaled_job_object |
|
|
| instaled_job_object/created |
|
|
| instaled_job_object/job |
|
|
| instaled_job_object/modified |
|
|
| instaled_job_object/obj_in_db |
|
|
| instaled_job_object/obj_type |
|
|
| instaled_job_object/obj_type_id |
|
|
| internal_fragmentation_check_db_checked |
|
|
| internal_fragmentation_check_db_count |
|
|
| internal_fragmentation_check_elap_time_m |
|
|
| internal_fragmentation_check_elap_time_s |
|
|
| internal_fragmentation_check_end |
|
|
| internal_fragmentation_check_heap_count |
|
|
| internal_fragmentation_check_idx_count |
|
|
| internal_fragmentation_check_last_db |
|
|
| internal_fragmentation_check_last_db_nice |
|
|
| internal_fragmentation_check_last_run_days |
|
|
| internal_fragmentation_check_max_thr_MB |
|
|
| internal_fragmentation_check_min_thr_MB |
|
|
| internal_fragmentation_check_obj_checked |
|
|
| internal_fragmentation_check_obj_checked_size_MB |
|
|
| internal_fragmentation_check_severity |
|
|
| internal_fragmentation_check_severity_desc |
|
|
| internal_fragmentation_check_severity_desc_list |
|
|
| internal_fragmentation_check_start |
|
|
| maintenance_check_all |
|
|
| maintenance_severity |
|
|
| maintenance_severity_desc |
|
|
| maintenance_severity_desc_list |
|
|
| ms_agent_jobs_errors_48h |
|
|
| ms_agent_jobs_errors_48h/desc |
|
|
| ms_agent_jobs_errors_48h/end_time |
|
|
| ms_agent_jobs_errors_48h/job_name |
|
|
| ms_agent_jobs_errors_48h/state |
|
|
| ms_agent_jobs_errors_48h/step_id |
|
|
| ms_agent_jobs_errors_48h/step_status |
|
|
| ms_agent_jobs_faild_id |
|
|
| ms_agent_jobs_faild_id/end_time_s_1970 |
|
|
| ms_agent_jobs_faild_id/end_time_txt |
|
|
| ms_agent_jobs_faild_id/job_name |
|
|
| ms_agent_jobs_faild_id/message |
|
|
| ms_agent_jobs_faild_id/step_id |
|
|
| ms_param_show_advanced_options |
|
|
| ms_param_xp_cmdshell |
|
|
| ola_h_dbw_alter_index |
|
|
| ola_h_dbw_created |
|
|
| ola_h_dbw_dbcc |
|
|
| ola_h_dbw_installed |
|
|
| ola_h_dbw_last_error |
|
|
| ola_h_dbw_modify |
|
|
| ola_h_dbw_row_count |
|
|
| ola_h_dbw_update_stat |
|
|
| ola_hallengren_alter_index |
|
|
| ola_hallengren_created |
|
|
| ola_hallengren_dbcc |
|
|
| ola_hallengren_installed |
|
|
| ola_hallengren_last_error |
|
|
| ola_hallengren_modify |
|
|
| ola_hallengren_row_count |
|
|
| ola_hallengren_update_stat |
|
|
| probe_scans |
|
|
| range_scans |
|
|
| rebuild_idx_avg_elap_mi |
|
|
| rebuild_idx_count |
|
|
| rebuild_idx_db_checked |
|
|
| rebuild_idx_db_count |
|
|
| rebuild_idx_elap_char |
|
|
| rebuild_idx_elap_mi |
|
|
| rebuild_idx_end |
|
|
| rebuild_idx_end_dd_ago |
|
|
| rebuild_idx_error |
|
|
| rebuild_idx_last_db |
|
|
| rebuild_idx_last_db_nice |
|
|
| rebuild_idx_max_elap_mi |
|
|
| rebuild_idx_min_elap_mi |
|
|
| rebuild_idx_reduction_MB |
|
|
| rebuild_idx_severity |
|
|
| rebuild_idx_severity_desc |
|
|
| rebuild_idx_severity_desc_list |
|
|
| rebuild_idx_size_after_MB |
|
|
| rebuild_idx_size_before_MB |
|
|
| rebuild_idx_start |
|
|
| rebuild_idx_too_large |
|
|
| rebuild_idx_variation |
|
|
| reorg_idx_avg_elap_mi |
|
|
| reorg_idx_count |
|
|
| reorg_idx_db_checked |
|
|
| reorg_idx_db_count |
|
|
| reorg_idx_elap_char |
|
|
| reorg_idx_elap_mi |
|
|
| reorg_idx_end |
|
|
| reorg_idx_end_dd_ago |
|
|
| reorg_idx_error |
|
|
| reorg_idx_last_db |
|
|
| reorg_idx_last_db_nice |
|
|
| reorg_idx_max_elap_mi |
|
|
| reorg_idx_min_elap_mi |
|
|
| reorg_idx_reduction_MB |
|
|
| reorg_idx_severity |
|
|
| reorg_idx_severity_desc |
|
|
| reorg_idx_severity_desc_list |
|
|
| reorg_idx_size_after_MB |
|
|
| reorg_idx_size_before_MB |
|
|
| reorg_idx_start |
|
|
| reorg_idx_too_large |
|
|
| reorg_idx_variation |
|
|
| Name |
Description |
Typical values |
| delete_avg |
Average delete performance |
|
| dml_perf_avg |
Average DML performance |
|
| dml_perf_var |
DML performance variation |
|
| dml_platform_comp |
DML platform comparison |
|
| dml_test_count |
Number of DML tests |
|
| insert_avg |
Average insert performance |
|
| int_sql_exec_histr_sec |
Internal SQL execution history in seconds since 1970 |
|
| int_sql_exec_histr_sec/histr_date |
History date |
|
| int_sql_exec_histr_sec/main_proc |
Main procedure time |
|
| int_sql_exec_histr_sec/sim_calc |
Sim calculation time |
|
| int_sql_exec_histr_sec/space_calc |
Space calculation time |
|
| logical_reads_avg |
Average logical reads |
|
| logical_reads_avg_eh |
Average logical reads for EH |
|
| logical_reads_avg_increase_days_last |
Days in the last logical read increase period |
|
| logical_reads_avg_increase_end_last |
End of the last logical read increase period |
|
| logical_reads_avg_increase_last |
Last logical read increase |
|
| logical_reads_avg_increase_max |
Maximum logical read increase |
|
| logical_reads_avg_increase_max_period |
Maximum logical read increase period |
|
| logical_reads_avg_increase_pct_last |
Last logical read increase percentage |
|
| logical_reads_avg_increase_periods |
Number of logical read increase periods |
|
| logical_reads_avg_increase_start_last |
Start of the last logical read increase period |
|
| logical_reads_avg_increase_status |
Logical read increase status |
|
| logical_reads_avg_nh |
Average logical reads for NH |
|
| logical_reads_avg_wh |
Average logical reads for WH |
|
| logical_reads_current |
Current logical reads |
|
| logical_reads_max |
Maximum logical reads |
|
| logical_reads_max_eh |
Maximum logical reads for EH |
|
| logical_reads_max_nh |
Maximum logical reads for NH |
|
| logical_reads_max_wh |
Maximum logical reads for WH |
|
| query_store_db_count |
Query Store database count |
|
| query_store_in_use |
Whether Query Store is in use |
|
| select_avg |
Average select performance |
|
| sql_missing_index_count |
Missing index count |
|
| sql_missing_index_last |
Last missing index check |
|
| sql_repository_obj_id |
SQL repository object |
|
| sql_repository_obj_id/name |
SQL repository object name |
|
| sql_repository_obj_id/size_mb |
SQL repository object size in MB |
|
| sql_repository_size_mb |
SQL repository size in MB |
|
| sql_statistics_avg_exec_time_ms |
Average SQL execution time in ms |
|
| sql_statistics_exec_time_ms |
SQL execution time in ms |
|
| sql_statistics_max_exec_time_ms |
Maximum SQL execution time in ms |
|
| sql_statistics_missing_sql_text |
Missing SQL text count |
|
| sql_statistics_missing_sql_text_pct |
Missing SQL text percentage |
|
| sql_statistics_sql_text_count |
SQL text count |
|
| update_avg |
Average update performance |
|
| user_scans_rank |
User scans ranking |
|
| user_scans_rank/avg_kb_per_m |
Average KB per minute |
|
| user_scans_rank/avg_scans_per_m |
Average scans per minute |
|
| user_scans_rank/db_name |
Database name |
|
| user_scans_rank/max_kb_per_m |
Maximum KB per minute |
|
| user_scans_rank/max_scans_per_m |
Maximum scans per minute |
|
| user_scans_rank/obj_name |
Object name |
|
| user_scans_rank/obj_type |
Object type |
|
| user_scans_rank/size_kb |
Size in KB |
|
| Name |
Description |
Typical values |
| blocked_histr_count |
Blocked sessions history count |
|
| blocked_histr_last_occured |
Last blocked session occurrence |
|
| blocked_histr_last_occured_txt |
Last blocked session occurrence as text |
|
| blocked_ses_id |
Blocked session |
|
| blocked_ses_id/blocked_by |
Blocking session |
|
| blocked_ses_id/command |
Session command |
|
| blocked_ses_id/database |
Database name |
|
| blocked_ses_id/hostname |
Host name |
|
| blocked_ses_id/last_batch |
Last batch time |
|
| blocked_ses_id/last_batch_txt |
Last batch time as text |
|
| blocked_ses_id/logged_on |
Login time |
|
| blocked_ses_id/logged_on_txt |
Login time as text |
|
| blocked_ses_id/login |
Login name |
|
| blocked_ses_id/program |
Program name |
|
| blocked_ses_id/ses_id |
Session ID |
|
| blocked_ses_id/status |
Session status |
|
| blocked_ses_id/transactions |
Transaction count |
|
| blocked_ses_id/wait_time_sec |
Wait time in seconds |
|
| blocked_session_count |
Number of blocked sessions |
|
| blocking_events_avg_exec_time_ms |
Average blocking event execution time in ms |
|
| blocking_events_count |
Blocking event count |
|
| blocking_events_exec_time_ms |
Blocking event execution time in ms |
|
| blocking_events_last |
Last blocking event |
|
| blocking_events_max_exec_time_ms |
Maximum blocking event execution time in ms |
|
| blocking_events_repository_size_mb |
Blocking events repository size in MB |
|
| blocking_histr_count |
Blocking history count |
|
| blocking_histr_last_occured |
Last blocking history occurrence |
|
| blocking_histr_last_occured_txt |
Last blocking history occurrence as text |
|
| blocking_ses_id |
Blocking session |
|
| blocking_ses_id/command |
Session command |
|
| blocking_ses_id/database |
Database name |
|
| blocking_ses_id/hostname |
Host name |
|
| blocking_ses_id/last_batch |
Last batch time |
|
| blocking_ses_id/last_batch_txt |
Last batch time as text |
|
| blocking_ses_id/logged_on |
Login time |
|
| blocking_ses_id/logged_on_txt |
Login time as text |
|
| blocking_ses_id/login |
Login name |
|
| blocking_ses_id/program |
Program name |
|
| blocking_ses_id/ses_id |
Session ID |
|
| blocking_ses_id/status |
Session status |
|
| blocking_ses_id/transactions |
Transaction count |
|
| inactive_session_count |
Number of inactive sessions |
|
| monitoring_gap_inst_down |
Monitoring gap while the instance was down |
|
| monitoring_gap_inst_down/gap_id |
Gap ID |
|
| monitoring_gap_inst_down/minutes_down |
Minutes down |
|
| monitoring_gap_inst_down/monitoring_gap_inst_up |
Monitoring gap while the instance was up |
|
| monitoring_gap_start |
Monitoring gap start |
|
| monitoring_gap_start/gap_id |
Gap ID |
|
| monitoring_gap_start/minutes_missing |
Minutes missing |
|
| monitoring_gap_start/monitoring_gap_end |
Monitoring gap end |
|
| session_histr_date_id |
Session history by date |
|
| session_histr_date_id/database |
Database name |
|
| session_histr_date_id/histr_date_char |
History date as text |
|
| session_histr_date_id/histr_date_sec_1970 |
History date in seconds since 1970 |
|
| session_histr_date_id/host |
Host |
|
| session_histr_date_id/last_batch |
Last batch time |
|
| session_histr_date_id/login |
Login |
|
| session_histr_date_id/program |
Program |
|
| session_histr_date_id/status |
Status |
|
| session_last_seen_id |
Last seen session |
|
| session_last_seen_id/last_seen_char |
Last seen time as text |
|
| session_last_seen_id/last_seen_sec_1970 |
Last seen time in seconds since 1970 |
|
| session_monitoring_gap_start |
Session monitoring gap start |
|
| session_monitoring_gap_start/gap_id |
Gap ID |
|
| session_monitoring_gap_start/minutes_missing |
Minutes missing |
|
| session_monitoring_gap_start/monitoring_gap_end |
Monitoring gap end |
|
| session_repository_size_mb |
Session repository size in MB |
|
| session_statistics_avg_exec_time_ms |
Average session execution time in ms |
|
| session_statistics_exec_time_ms |
Session execution time in ms |
|
| session_statistics_last_histr |
Last session statistics history |
|
| session_statistics_max_exec_time_ms |
Maximum session execution time in ms |
|
| total_session_count |
The total number of sessions on the instance |
12, 432 |
| wait_rank |
Wait ranking |
|
| wait_rank/wait_name |
Wait name |
|
| wait_rank/wait_time_pct |
Wait time percentage |
|
| waits_aggr_eh |
Aggregated waits for EH |
|
| waits_aggr_nh |
Aggregated waits for NH |
|
| waits_aggr_wh |
Aggregated waits for WH |
|
| waits_current |
Current waits |
|
| waits_deviation_eh |
Wait deviation for EH |
|
| waits_deviation_nh |
Wait deviation for NH |
|
| waits_deviation_wh |
Wait deviation for WH |
|
| waits_param_ignore_types |
Wait types to ignore |
|
| Name |
Description |
Typical values |
| bios_instance_id |
BIOS instance information |
|
| bios_instance_id/bios_name |
BIOS name |
|
| bios_instance_id/listener_ip |
Listener IP address |
|
| bios_instance_id/listener_name |
Listener name |
|
| bios_instance_id/listener_port |
Listener port |
|
| bios_instance_id/sql_inst_name |
SQL instance name |
|
| cmd_net_start |
Network start command |
|
| dbhost |
Database host name |
|
| edition |
The edition of the instance |
Standard Edition, Enterprise Edition |
| framework_exists |
Whether the dbWatch framework exists |
|
| hosttype |
Host type |
|
| instance_agent_job |
Instance agent job |
|
| instance_agent_job/date_modified |
Job modification time |
|
| instance_agent_job/description |
Job description |
|
| instance_agent_job/last_executed |
Job last executed time |
|
| instance_agent_job/name |
Job name |
|
| instance_agent_job/state |
Job state |
|
| instance_agent_job/status |
Job status |
|
| instance_agent_job_count_dbw |
Number of dbWatch agent jobs |
|
| instance_agent_job_disabled_count |
Number of disabled agent jobs |
|
| instance_agent_job_enabled_count |
Number of enabled agent jobs |
|
| instance_class |
Instance class |
|
| instance_information_table_id |
Instance information entry |
|
| instance_information_table_id/value |
Instance information value |
|
| instance_name |
Instance name |
|
| instance_started_sec_1970 |
Instance start time in seconds since 1970 |
|
| is_azure |
Whether the instance is Azure |
|
| is_managed_instance |
Whether the instance is a managed instance |
|
| login_exists |
Whether the login exists |
|
| login_id |
Login entry |
|
| login_id/db_name |
Database name |
|
| login_id/DDL |
DDL statement |
|
| login_id/host_name |
Host name |
|
| login_id/instance_name |
Instance name |
|
| login_id/login_name |
Login name |
|
| login_id/user_name |
User name |
|
| maj_min_version |
Major version and update level |
|
| maj_version |
Major SQL Server version |
|
| on_linux |
Whether SQL Server runs on Linux |
|
| one |
Constant value one |
|
| patch_branch |
Patch branch |
|
| patch_count_available |
Number of available patches |
|
| patch_count_status |
Patch status count |
|
| patch_count_status_char |
Patch status text |
|
| patch_first_check |
First patch check time |
|
| patch_history_id |
Patch history entry |
|
| patch_history_id/patch_branch |
Patch branch |
|
| patch_history_id/patch_first_check |
First patch check |
|
| patch_history_id/patch_last_in_use |
Last patch in use |
|
| patch_history_id/patch_maj_version |
Major patch version |
|
| patch_history_id/patch_min_version |
Minor patch version |
|
| patch_history_id/patch_release |
Patch release |
|
| patch_last_branch |
Last patch branch |
|
| patch_last_in_use |
Last patch in use |
|
| patch_last_min_version |
Last patch minor version |
|
| patch_last_release |
Last patch release |
|
| patch_last_url |
Last patch URL |
|
| patch_maj_version |
Patch major version |
|
| patch_min_version |
Patch minor version |
|
| patch_release |
Patch release |
|
| platform_info |
Platform and version info |
SQL Server 2016 (SP3) |
| program_name |
Program name |
|
| prop_user |
Property user |
|
| rdsadmin_db_exists |
Whether the RDS admin database exists |
|
| sec_after_1970 |
Seconds after 1970 |
|
| started |
A text representation of the start time for the instance |
21.10.2020 11:39:16, 11.10.2023 11:47:08 |
| time |
Current time |
|
| utc_diff_h |
UTC difference in hours |
|
| utc_diff_s |
UTC difference in seconds |
|
| utc_sec_diff |
UTC offset in seconds |
|
| version |
SQL Server product version |
|
| Name |
Description |
Typical values |
| activity |
|
|
| agresso_module |
|
|
| agresso_module/db_name |
|
|
| agresso_module/schema_id |
|
|
| agresso_module/schema_name |
|
|
| auto_update_stat_off_db_count |
|
|
| auto_update_stat_on_db_count |
|
|
| azure_dml_test_1k_avg |
|
|
| azure_dml_test_del_1k_avg |
|
|
| azure_dml_test_del_pct_var |
|
|
| azure_dml_test_ins_1k_avg |
|
|
| azure_dml_test_ins_pct_var |
|
|
| azure_dml_test_sel_1k_avg |
|
|
| azure_dml_test_sel_pct_var |
|
|
| azure_dml_test_tot_pct_var |
|
|
| azure_dml_test_upd_1k_avg |
|
|
| azure_dml_test_upd_pct_var |
|
|
| azure_dml_tests_count |
|
|
| checkpoint_avg_eh |
|
|
| checkpoint_avg_nh |
|
|
| checkpoint_avg_wh |
|
|
| complexity |
|
|
| complexity_AlwaysOn |
|
|
| complexity_cluster |
|
|
| complexity_verion |
|
|
| cpu |
|
|
| dc_pct_var |
|
|
| dm_db_missing_index_count |
|
|
| dm_db_missing_index_count/idx_count |
|
|
| endgine_cc_count |
|
|
| endgine_data_file_size_MB |
|
|
| engine_data_file_name |
|
|
| engine_data_file_name/file_type |
|
|
| engine_data_file_name/free_mb |
|
|
| engine_data_file_name/lname |
|
|
| engine_data_file_name/max_size_mb |
|
|
| engine_data_file_name/size_mb |
|
|
| engine_data_file_name/used_mb |
|
|
| engine_data_file_name/used_pct |
|
|
| engine_edition |
SQL Server engine edition |
|
| engine_exists |
|
|
| engine_log_file_size_MB |
|
|
| file_io_write_latency_aggr_wh |
|
|
| file_io_write_max_latency |
|
|
| file_io_write_max_latency_drive |
|
|
| file_io_write_param_ignore_db |
|
|
| file_io_write_rank |
|
|
| file_io_write_rank/file_io_write_db |
|
|
| file_io_write_rank/file_io_write_drive |
|
|
| file_io_write_rank/file_io_write_kb_sec |
|
|
| file_io_write_rank/file_io_write_last period |
|
|
| file_io_write_rank/file_io_write_last_date |
|
|
| file_io_write_rank/file_io_write_latency |
|
|
| file_io_write_rank/file_io_write_ph_name |
|
|
| high_activity_monitor_histr_sec |
|
|
| high_activity_monitor_histr_sec/date_val |
|
|
| high_activity_monitor_histr_sec/idle_cpu |
|
|
| high_activity_monitor_histr_sec/logical_reads |
|
|
| high_activity_monitor_histr_sec/other_cpu |
|
|
| high_activity_monitor_histr_sec/physical_reads |
|
|
| high_activity_monitor_histr_sec/sql_cpu |
|
|
| inst_phys_mem |
|
|
| inst_targ_mem |
|
|
| inst_targ_mem_pct |
|
|
| lazy_writer_avg_eh |
|
|
| lazy_writer_avg_nh |
|
|
| lazy_writer_avg_wh |
|
|
| life_exp_current |
|
|
| life_exp_current_pct |
|
|
| life_exp_current_status |
|
|
| life_exp_interval_a |
|
|
| life_exp_interval_b |
|
|
| life_exp_interval_c |
|
|
| life_exp_interval_d |
|
|
| life_exp_interval_e |
|
|
| life_exp_interval_f |
|
|
| listener_port |
|
|
| ms_inst_count |
|
|
| ms_inst_name_list |
|
|
| ms_inst_names |
|
|
| obj_name_id |
|
|
| page_verify_option_change_count |
|
|
| page_verify_option_last_change |
|
|
| principal_mapping_dbo_missing_count |
|
|
| principal_mapping_dbu_count |
|
|
| principal_mapping_dbu_missing_count |
|
|
| program_name/user_count |
|
|
| pull_dbfile_id |
|
|
| pull_dbfile_id/db_name |
|
|
| pull_dbfile_id/dbw_instance |
|
|
| pull_dbfile_id/file_id |
|
|
| pull_dbfile_id/file_location |
|
|
| pull_dbfile_id/file_type |
|
|
| pull_dbfile_id/host_name |
|
|
| pull_dbfile_id/instance_name |
|
|
| pull_dbfile_id/logical_name |
|
|
| pull_dbfile_id/space_used_mb |
|
|
| pull_device_id |
|
|
| pull_device_id/compatibility_level |
|
|
| pull_device_id/db_name |
|
|
| pull_device_id/dbw_instance |
|
|
| pull_device_id/dev_location |
|
|
| pull_device_id/dev_name |
|
|
| pull_device_id/host_name |
|
|
| pull_device_id/instance_name |
|
|
| pull_device_id/last_backup_1970 |
|
|
| pull_device_id/last_backup_txt |
|
|
| pull_device_id/last_restore_1970 |
|
|
| pull_device_id/last_restore_txt |
|
|
| pull_device_id/org_compatibility_level |
|
|
| pull_device_id/stat_date_1970 |
|
|
| pull_login_id |
|
|
| pull_login_id/db_name |
|
|
| pull_login_id/dbw_instance |
|
|
| pull_login_id/DDL |
|
|
| pull_login_id/host_name |
|
|
| pull_login_id/instance_name |
|
|
| pull_login_id/login_name |
|
|
| pull_login_id/status_info |
|
|
| pull_login_id/user_name |
|
|
| strength |
|
|
| top_20_appl_db_size_id |
|
|
| top_20_appl_db_size_id/Data_size_mb |
|
|
| top_20_appl_db_size_id/db_name |
|
|
| top_20_appl_db_size_id/file_count |
|
|
| top_20_appl_db_size_id/total_size_mb |
|
|
| top_20_appl_db_size_id/transaction_log_size_mb |
|
|
| tr_log_backup |
|
|
| tr_log_backup/backup_pref |
|
|
| tr_log_backup/compress_ratio |
|
|
| tr_log_backup/compressed_size_mb |
|
|
| tr_log_backup/curr_inst |
|
|
| tr_log_backup/db_name_plus_inst_name |
|
|
| tr_log_backup/elaps_time |
|
|
| tr_log_backup/finish |
|
|
| tr_log_backup/finish_ss |
|
|
| tr_log_backup/gr_name |
|
|
| tr_log_backup/is_copy_only |
|
|
| tr_log_backup/pri_inst |
|
|
| tr_log_backup/size_mb |
|
|
| tr_log_backup/start |
|
|
| tr_log_backup/status |
|
|
| tr_log_backup/type |
|
|
| tr_log_backup_comp_ratio_all |
|
|
| tr_log_backup_comp_size_GB_all |
|
|
| tr_log_backup_comp_size_MB_all |
|
|
| tr_log_backup_count_all |
|
|
| tr_log_backup_day_no |
|
|
| tr_log_backup_day_no/backup_count_per_day |
|
|
| tr_log_backup_day_no/day |
|
|
| tr_log_backup_day_no/first_backup |
|
|
| tr_log_backup_day_no/last_backup |
|
|
| tr_log_backup_day_no/max_size_compr_mb |
|
|
| tr_log_backup_day_no/min_size_compr_mb |
|
|
| tr_log_backup_day_no/stdev_size_compr_mb |
|
|
| tr_log_backup_day_no/sum_size_compr_mb |
|
|
| tr_log_backup_duration_minutes_all |
|
|
| tr_log_backup_duration_seconds_all |
|
|
| tr_log_backup_end_last_all |
|
|
| tr_log_backup_excl_copy_only |
|
|
| tr_log_backup_excl_copy_only/backup_pref |
|
|
| tr_log_backup_excl_copy_only/compress_ratio |
|
|
| tr_log_backup_excl_copy_only/compressed_size_mb |
|
|
| tr_log_backup_excl_copy_only/curr_inst |
|
|
| tr_log_backup_excl_copy_only/db_name_plus_inst_name |
|
|
| tr_log_backup_excl_copy_only/elaps_time |
|
|
| tr_log_backup_excl_copy_only/finish |
|
|
| tr_log_backup_excl_copy_only/finish_ss |
|
|
| tr_log_backup_excl_copy_only/gr_name |
|
|
| tr_log_backup_excl_copy_only/is_copy_only |
|
|
| tr_log_backup_excl_copy_only/pri_inst |
|
|
| tr_log_backup_excl_copy_only/size_mb |
|
|
| tr_log_backup_excl_copy_only/start |
|
|
| tr_log_backup_excl_copy_only/status |
|
|
| tr_log_backup_excl_copy_only/type |
|
|
| tr_log_backup_histr |
|
|
| tr_log_backup_histr/avg_backup_count_per_day |
|
|
| tr_log_backup_histr/avg_backup_count_per_day_bar |
|
|
| tr_log_backup_histr/avg_compr_backup_size_mb_per_day |
|
|
| tr_log_backup_histr/backup_days_per_week |
|
|
| tr_log_backup_histr/backup_days_per_week_bar |
|
|
| tr_log_backup_histr/backup_days_per_week_check |
|
|
| tr_log_backup_histr/first_backup_time |
|
|
| tr_log_backup_histr/last_backup_time |
|
|
| tr_log_backup_histr/stdev_backup_count_per_day |
|
|
| tr_log_backup_histr/sum_compr_backup_size_mb_per_week |
|
|
| tr_log_backup_size_GB_all |
|
|
| tr_log_backup_size_MB_all |
|
|
| tr_log_backup_start_first_all |
|
|
| transaction_log_size_warning |
|
|
| transaction_log_size_warning/data_file_count |
|
|
| transaction_log_size_warning/data_size |
|
|
| transaction_log_size_warning/db_status |
|
|
| transaction_log_size_warning/log_file_count |
|
|
| transaction_log_size_warning/log_size |
|
|
| transaction_log_size_warning/log_space_used |
|
|
| transaction_log_size_warning/ratio |
|
|
| transaction_log_size_warning/status |
|
|
| update_index_test_date |
|
|
| uptime_period |
|
|
| uptime_period/first_conn_sec_1970 |
|
|
| uptime_period/first_dbwatch_connection |
|
|
| uptime_period/instance_name |
|
|
| uptime_period/last_conn_sec_1970 |
|
|
| uptime_period/last_dbwatch_connection |
|
|
| uptime_period/started |
|
|
| uptime_period/started_sec_1970 |
|
|
| uptime_period/uptime |
|
|
| wait_statistics_histr_sec |
|
|
| wait_statistics_histr_sec/date_val |
|
|
| wait_statistics_histr_sec/limit |
|
|
| wait_statistics_histr_sec/wait_time |
|
|