Grafana Cloud Instrument and send data Grafana Agent Static mode Configure static mode integrations_config mssql_config
It is recommended that you have a dedicated user set up for monitoring an mssql instance. The user for monitoring must have the following grants in order to populate the metrics:
GRANT VIEW ANY DEFINITION TO <MONITOR_USER> GRANT VIEW SERVER STATE TO <MONITOR_USER>
Full reference of options:
# Enables the mssql integration, allowing the Agent to automatically # collect metrics for the specified mssql instance. [enabled: <boolean> | default = false] # Sets an explicit value for the instance label when the integration is # self-scraped. Overrides inferred values. # # The default value for this integration is the host:port of the provided connection_string. [instance: <string>] # Automatically collect metrics from this integration. If disabled, # the mssql integration is run but not scraped and thus not # remote-written. Metrics for the integration are exposed at # /integrations/mssql/metrics and can be scraped by an external # process. [scrape_integration: <boolean> | default = <integrations_config.scrape_integrations>] # How often should the metrics be collected? Defaults to # prometheus.global.scrape_interval. [scrape_interval: <duration> | default = <global_config.scrape_interval>] # The timeout before considering the scrape a failure. Defaults to # prometheus.global.scrape_timeout. [scrape_timeout: <duration> | default = <global_config.scrape_timeout>] # Allows for relabeling labels on the target. relabel_configs: [- <relabel_config> ... ] # Relabel metrics coming from the integration, lets you drop series # that you don't care about from the integration. metric_relabel_configs: [ - <relabel_config> ... ] # How frequently the WAL is truncated for this integration. [wal_truncate_frequency: <duration> | default = "60m"] # # Exporter-specific configuration options # # The connection_string to use to connect to the mssql instance. # It is specified in the form of: "sqlserver://<USERNAME>:<PASSWORD>@<HOST>:<PORT>" connection_string: <string> # The maximum number of open database connections to the mssql instance. [max_open_connections: <int> | default = 3] # The maximum number of idle database connections to the mssql instance. [max_idle_connections: <int> | default = 3] # The timeout for scraping metrics from the mssql instance. [timeout: <duration> | default = "10s"]
Was this page helpful?
Related resources from Grafana Labs
Additional helpful documentation, links, and articles:
Getting started with your metrics, logs, and traces in Grafana Cloud
Learn to use the best open source observability software (Grafana, Prometheus, Loki, and Tempo) without the overhead of managing and scaling your own stack.
Kubernetes monitoring, out-of-the-box with Grafana Cloud
In this webinar you’ll learn how Grafana offers developers and SREs a simple and quick-to-value solution for monitoring their Kubernetes infrastructure.
Unify your data with Grafana plugins: Datadog, Splunk, MongoDB, and more
In this webinar, learn how to leverage Grafana's plugin ecosystem for access to 80+ data sources, including plugins for Datadog, Splunk, MongoDB, and more.