MS SQL servers

Dashboard

Dashboard for Microsoft SQL server with Prometheus and Telegraf SQL plugin version 2.
Last updated: a year ago

Start with Grafana Cloud and the new FREE tier. Includes 10K series Prometheus or Graphite Metrics and 50gb Loki Logs

Downloads: 1577

Reviews: 1

  • 2020-01-13 17_10_25-MS SQL servers - Grafana.png
    2020-01-13 17_10_25-MS SQL servers - Grafana.png

This is a dashboard for Microsoft SQL server with Prometheus and Telegraf SQL plugin version 2. It displays global statistics and where is possible metrics per database. List:

  1. Global
  • CPU/Memory/SQL version/ Uptime
  • Database status (Offline, Online, Bad)
  • Global requests per sec/Buffer cache hit ratio
  1. Per database
  • Size
  • Transactions/IO stats

Collector Configuration Details

Example for telegraf deployment using Helm chart https://github.com/helm/charts/tree/master/stable/telegraf.

service:
  enabled: true
  type: ClusterIP
  annotations:
    prometheus.io/scrape: "true"
    prometheus.io/port: "9210"

env:
  - name: HOSTNAME
    value: "telegraf-polling-service"
  - name: MSSQL_USER
    valueFrom:
      secretKeyRef:
        key: mssql-user
        name: mssql-creds
  - name: MSSQL_PASSWORD
    valueFrom:
      secretKeyRef:
        key: mssql-password
        name: mssql-creds
config:
  agent:
    interval: "60s"
    round_interval: true
    metric_batch_size: 1000
    metric_buffer_limit: 10000
    collection_jitter: "0s"
    flush_interval: "10s"
    flush_jitter: "0s"
    precision: ""
    debug: false
    quiet: false
    logfile: ""
    hostname: "$HOSTNAME"
    omit_hostname: false
  outputs:
    - prometheus_client:
        listen: ":9210"
  inputs:
    - sqlserver:
        servers:
          - "Server=sqlserver-01;Port=1433;User Id=${MSSQL_USER};Password=${MSSQL_PASSWORD};app name=telegraf;"
        query_version: 2
        exclude_query:
          - Schedulers
          - SqlRequests
Get this dashboard:
11554
Dependencies: