collector.mssql.md

mssql collector

The mssql collector exposes metrics about the MSSQL server

Metric name prefix	mssql
Classes	Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods Win32_PerfRawData_MSSQLSERVER_SQLServerAvailabilityReplica Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager Win32_PerfRawData_MSSQLSERVER_SQLServerDatabaseReplica Win32_PerfRawData_MSSQLSERVER_SQLServerDatabases Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics Win32_PerfRawData_MSSQLSERVER_SQLServerLocks Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics Win32_PerfRawData_MSSQLSERVER_SQLServerSQLErrors Win32_PerfRawData_MSSQLSERVER_SQLServerTransactions
Enabled by default?	No

Flags

--collectors.mssql.classes-enabled

Comma-separated list of MSSQL WMI classes to use. Supported values are accessmethods, availreplica, bufman, databases, dbreplica, genstats, locks, memmgr, sqlstats, sqlerrors and transactions.

--collectors.mssql.class-print

If true, print available mssql WMI classes and exit. Only displays if the mssql collector is enabled.

Metrics

Name	Description	Type	Labels
wmi_mssql_collector_duration_seconds	The time taken for each sub-collector to return	counter	collector, instance
wmi_mssql_collector_success	1 if sub-collector succeeded, 0 otherwise	counter	collector, instance
wmi_mssql_accessmethods_au_batch_cleanups	Not yet documented	counter	instance
wmi_mssql_accessmethods_au_cleanups	Not yet documented	counter	instance
wmi_mssql_accessmethods_by_reference_lob_creates	Not yet documented	counter	instance
wmi_mssql_accessmethods_by_reference_lob_uses	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_read_aheads	Not yet documented	counter	instance
wmi_mssql_accessmethods_column_value_pulls	Not yet documented	counter	instance
wmi_mssql_accessmethods_column_value_pushes	Not yet documented	counter	instance
wmi_mssql_accessmethods_deferred_dropped_aus	Not yet documented	counter	instance
wmi_mssql_accessmethods_deferred_dropped_rowsets	Not yet documented	counter	instance
wmi_mssql_accessmethods_dropped_rowset_cleanups	Not yet documented	counter	instance
wmi_mssql_accessmethods_dropped_rowset_skips	Not yet documented	counter	instance
wmi_mssql_accessmethods_extent_deallocations	Not yet documented	counter	instance
wmi_mssql_accessmethods_extent_allocations	Not yet documented	counter	instance
wmi_mssql_accessmethods_au_batch_cleanup_failures	Not yet documented	counter	instance
wmi_mssql_accessmethods_leaf_page_cookie_failures	Not yet documented	counter	instance
wmi_mssql_accessmethods_tree_page_cookie_failures	Not yet documented	counter	instance
wmi_mssql_accessmethods_forwarded_records	Not yet documented	counter	instance
wmi_mssql_accessmethods_free_space_page_fetches	Not yet documented	counter	instance
wmi_mssql_accessmethods_free_space_scans	Not yet documented	counter	instance
wmi_mssql_accessmethods_full_scans	Not yet documented	counter	instance
wmi_mssql_accessmethods_index_searches	Not yet documented	counter	instance
wmi_mssql_accessmethods_insysxact_waits	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_handle_creates	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_handle_destroys	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_ss_provider_creates	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_ss_provider_destroys	Not yet documented	counter	instance
wmi_mssql_accessmethods_lob_ss_provider_truncations	Not yet documented	counter	instance
wmi_mssql_accessmethods_mixed_page_allocations	Not yet documented	counter	instance
wmi_mssql_accessmethods_page_compression_attempts	Not yet documented	counter	instance
wmi_mssql_accessmethods_page_deallocations	Not yet documented	counter	instance
wmi_mssql_accessmethods_page_allocations	Not yet documented	counter	instance
wmi_mssql_accessmethods_page_compressions	Not yet documented	counter	instance
wmi_mssql_accessmethods_page_splits	Not yet documented	counter	instance
wmi_mssql_accessmethods_probe_scans	Not yet documented	counter	instance
wmi_mssql_accessmethods_range_scans	Not yet documented	counter	instance
wmi_mssql_accessmethods_scan_point_revalidations	Not yet documented	counter	instance
wmi_mssql_accessmethods_ghost_record_skips	Not yet documented	counter	instance
wmi_mssql_accessmethods_table_lock_escalations	Not yet documented	counter	instance
wmi_mssql_accessmethods_leaf_page_cookie_uses	Not yet documented	counter	instance
wmi_mssql_accessmethods_tree_page_cookie_uses	Not yet documented	counter	instance
wmi_mssql_accessmethods_workfile_creates	Not yet documented	counter	instance
wmi_mssql_accessmethods_worktables_creates	Not yet documented	counter	instance
wmi_mssql_accessmethods_worktables_from_cache_ratio	Not yet documented	counter	instance
wmi_mssql_availreplica_received_from_replica_bytes	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_sent_to_replica_bytes	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_sent_to_transport_bytes	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_initiated_flow_controls	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_flow_control_wait_seconds	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_receives_from_replica	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_resent_messages	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_sends_to_replica	Not yet documented	counter	instance, replica
wmi_mssql_availreplica_sends_to_transport	Not yet documented	counter	instance, replica
wmi_mssql_bufman_background_writer_pages	Not yet documented	counter	instance
wmi_mssql_bufman_buffer_cache_hit_ratio	Not yet documented	counter	instance
wmi_mssql_bufman_checkpoint_pages	Not yet documented	counter	instance
wmi_mssql_bufman_database_pages	Not yet documented	counter	instance
wmi_mssql_bufman_extension_allocated_pages	Not yet documented	counter	instance
wmi_mssql_bufman_extension_free_pages	Not yet documented	counter	instance
wmi_mssql_bufman_extension_in_use_as_percentage	Not yet documented	counter	instance
wmi_mssql_bufman_extension_outstanding_io	Not yet documented	counter	instance
wmi_mssql_bufman_extension_page_evictions	Not yet documented	counter	instance
wmi_mssql_bufman_extension_page_reads	Not yet documented	counter	instance
wmi_mssql_bufman_extension_page_unreferenced_seconds	Not yet documented	counter	instance
wmi_mssql_bufman_extension_page_writes	Not yet documented	counter	instance
wmi_mssql_bufman_free_list_stalls	Not yet documented	counter	instance
wmi_mssql_bufman_integral_controller_slope	Not yet documented	counter	instance
wmi_mssql_bufman_lazywrites	Not yet documented	counter	instance
wmi_mssql_bufman_page_life_expectancy_seconds	Not yet documented	counter	instance
wmi_mssql_bufman_page_lookups	Not yet documented	counter	instance
wmi_mssql_bufman_page_reads	Not yet documented	counter	instance
wmi_mssql_bufman_page_writes	Not yet documented	counter	instance
wmi_mssql_bufman_read_ahead_pages	Not yet documented	counter	instance
wmi_mssql_bufman_read_ahead_issuing_seconds	Not yet documented	counter	instance
wmi_mssql_bufman_target_pages	Not yet documented	counter	instance
wmi_mssql_dbreplica_database_flow_control_wait_seconds	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_database_initiated_flow_controls	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_received_file_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_group_commits	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_group_commit_stall_seconds	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_apply_pending_queue	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_apply_ready_queue	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_compressed_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_decompressed_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_received_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_compression_cachehits	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_compression_cachemisses	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_compressions	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_decompressions	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_remaining_for_undo	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_log_send_queue	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_mirrored_write_transactions	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_recovery_queue_records	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_redo_blocks	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_redo_remaining_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_redone_bytes	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_redones	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_total_log_requiring_undo	Not yet documented	counter	instance, replica
wmi_mssql_dbreplica_transaction_delay_seconds	Not yet documented	counter	instance, replica
wmi_mssql_databases_active_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_backup_restore_operations	Not yet documented	counter	instance, database
wmi_mssql_databases_bulk_copy_rows	Not yet documented	counter	instance, database
wmi_mssql_databases_bulk_copy_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_commit_table_entries	Not yet documented	counter	instance, database
wmi_mssql_databases_data_files_size_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_dbcc_logical_scan_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_group_commit_stall_seconds	Not yet documented	counter	instance, database
wmi_mssql_databases_log_flushed_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_cache_hit_ratio	Not yet documented	counter	instance, database
wmi_mssql_databases_log_cache_reads	Not yet documented	counter	instance, database
wmi_mssql_databases_log_files_size_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_files_used_size_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_flushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_flush_waits	Not yet documented	counter	instance, database
wmi_mssql_databases_log_flush_wait_seconds	Not yet documented	counter	instance, database
wmi_mssql_databases_log_flush_write_seconds	Not yet documented	counter	instance, database
wmi_mssql_databases_log_growths	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_cache_misses	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_disk_reads	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_hash_deletes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_hash_inserts	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_invalid_hash_entries	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_log_scan_pushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_log_writer_pushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_empty_free_pool_pushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_low_memory_pushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_no_free_buffer_pushes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_req_behind_trunc	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_requests_old_vlf	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_requests	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_total_active_log_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_pool_total_shared_pool_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_log_shrinks	Not yet documented	counter	instance, database
wmi_mssql_databases_log_truncations	Not yet documented	counter	instance, database
wmi_mssql_databases_log_used_percent	Not yet documented	counter	instance, database
wmi_mssql_databases_pending_repl_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_repl_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_shrink_data_movement_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_tracked_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_write_transactions	Not yet documented	counter	instance, database
wmi_mssql_databases_xtp_controller_dlc_fetch_latency_seconds	Not yet documented	counter	instance, database
wmi_mssql_databases_xtp_controller_dlc_peak_latency_seconds	Not yet documented	counter	instance, database
wmi_mssql_databases_xtp_controller_log_processed_bytes	Not yet documented	counter	instance, database
wmi_mssql_databases_xtp_memory_used_bytes	Not yet documented	counter	instance, database
wmi_mssql_genstats_active_temp_tables	Not yet documented	counter	instance
wmi_mssql_genstats_connection_resets	Not yet documented	counter	instance
wmi_mssql_genstats_event_notifications_delayed_drop	Not yet documented	counter	instance
wmi_mssql_genstats_http_authenticated_requests	Not yet documented	counter	instance
wmi_mssql_genstats_logical_connections	Not yet documented	counter	instance
wmi_mssql_genstats_logins	Not yet documented	counter	instance
wmi_mssql_genstats_logouts	Not yet documented	counter	instance
wmi_mssql_genstats_mars_deadlocks	Not yet documented	counter	instance
wmi_mssql_genstats_non_atomic_yields	Not yet documented	counter	instance
wmi_mssql_genstats_blocked_processes	Not yet documented	counter	instance
wmi_mssql_genstats_soap_empty_requests	Not yet documented	counter	instance
wmi_mssql_genstats_soap_method_invocations	Not yet documented	counter	instance
wmi_mssql_genstats_soap_session_initiate_requests	Not yet documented	counter	instance
wmi_mssql_genstats_soap_session_terminate_requests	Not yet documented	counter	instance
wmi_mssql_genstats_soapsql_requests	Not yet documented	counter	instance
wmi_mssql_genstats_soapwsdl_requests	Not yet documented	counter	instance
wmi_mssql_genstats_sql_trace_io_provider_lock_waits	Not yet documented	counter	instance
wmi_mssql_genstats_tempdb_recovery_unit_ids_generated	Not yet documented	counter	instance
wmi_mssql_genstats_tempdb_rowset_ids_generated	Not yet documented	counter	instance
wmi_mssql_genstats_temp_tables_creations	Not yet documented	counter	instance
wmi_mssql_genstats_temp_tables_awaiting_destruction	Not yet documented	counter	instance
wmi_mssql_genstats_trace_event_notification_queue_size	Not yet documented	counter	instance
wmi_mssql_genstats_transactions	Not yet documented	counter	instance
wmi_mssql_genstats_user_connections	Not yet documented	counter	instance
wmi_mssql_locks_average_wait_seconds	Not yet documented	counter	instance, resource
wmi_mssql_locks_lock_requests	Not yet documented	counter	instance, resource
wmi_mssql_locks_lock_timeouts	Not yet documented	counter	instance, resource
wmi_mssql_locks_lock_timeouts_excluding_NOWAIT	Not yet documented	counter	instance, resource
wmi_mssql_locks_lock_waits	Not yet documented	counter	instance, resource
wmi_mssql_locks_lock_wait_seconds	Not yet documented	counter	instance, resource
wmi_mssql_locks_deadlocks	Not yet documented	counter	instance, resource
wmi_mssql_memmgr_connection_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_database_cache_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_external_benefit_of_memory	Not yet documented	counter	instance
wmi_mssql_memmgr_free_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_granted_workspace_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_lock_blocks	Not yet documented	counter	instance
wmi_mssql_memmgr_allocated_lock_blocks	Not yet documented	counter	instance
wmi_mssql_memmgr_lock_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_lock_owner_blocks	Not yet documented	counter	instance
wmi_mssql_memmgr_allocated_lock_owner_blocks	Not yet documented	counter	instance
wmi_mssql_memmgr_log_pool_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_maximum_workspace_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_outstanding_memory_grants	Not yet documented	counter	instance
wmi_mssql_memmgr_pending_memory_grants	Not yet documented	counter	instance
wmi_mssql_memmgr_optimizer_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_reserved_server_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_sql_cache_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_stolen_server_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_target_server_memory_bytes	Not yet documented	counter	instance
wmi_mssql_memmgr_total_server_memory_bytes	Not yet documented	counter	instance
wmi_mssql_sqlstats_auto_parameterization_attempts	Not yet documented	counter	instance
wmi_mssql_sqlstats_batch_requests	Not yet documented	counter	instance
wmi_mssql_sqlstats_failed_auto_parameterization_attempts	Not yet documented	counter	instance
wmi_mssql_sqlstats_forced_parameterizations	Not yet documented	counter	instance
wmi_mssql_sqlstats_guided_plan_executions	Not yet documented	counter	instance
wmi_mssql_sqlstats_misguided_plan_executions	Not yet documented	counter	instance
wmi_mssql_sqlstats_safe_auto_parameterization_attempts	Not yet documented	counter	instance
wmi_mssql_sqlstats_sql_attentions	Not yet documented	counter	instance
wmi_mssql_sqlstats_sql_compilations	Not yet documented	counter	instance
wmi_mssql_sqlstats_sql_recompilations	Not yet documented	counter	instance
wmi_mssql_sqlstats_unsafe_auto_parameterization_attempts	Not yet documented	counter	instance
wmi_mssql_sql_errors_total	Not yet documented	counter	instance, resource
wmi_mssql_transactions_tempdb_free_space_bytes	Not yet documented	gauge	instance
wmi_mssql_transactions_longest_transaction_running_seconds	Not yet documented	gauge	instance
wmi_mssql_transactions_nonsnapshot_version_active_total	Not yet documented	counter	instance
wmi_mssql_transactions_snapshot_active_total	Not yet documented	counter	instance
wmi_mssql_transactions_active_total	Not yet documented	counter	instance
wmi_mssql_transactions_update_conflicts_total	Not yet documented	counter	instance
wmi_mssql_transactions_update_snapshot_active_total	Not yet documented	counter	instance
wmi_mssql_transactions_version_cleanup_rate_bytes	Not yet documented	gauge	instance
wmi_mssql_transactions_version_generation_rate_bytes	Not yet documented	gauge	instance
wmi_mssql_transactions_version_store_size_bytes	Not yet documented	gauge	instance
wmi_mssql_transactions_version_store_units	Not yet documented	counter	instance
wmi_mssql_transactions_version_store_creation_units	Not yet documented	counter	instance
wmi_mssql_transactions_version_store_truncation_units	Not yet documented	counter	instance

Example metric

This collector does not yet have explained examples, we would appreciate your help adding them!

Useful queries

This collector does not yet have any useful queries added, we would appreciate your help adding them!

Alerting examples

This collector does not yet have alerting examples, we would appreciate your help adding them!