Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
2 contributors

Users who have contributed to this file

@callvirtual @carlpett
255 lines (243 sloc) 23.7 KB

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!

You can’t perform that action at this time.