Promhub Logo Prom hub

MS SQL servers
3,428 4.0 (1 reviews)

Created 1/13/2020
Updated 2/10/2021
Revision 4
Categories
Databases
Grafana Version >=7.3.5
Datasources
Prometheus

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
Get Dashboard✕
Download
Copy to Clipboard
Dashboard screenshot 1
Source Grafana.com

Used Metrics 17

  • sqlserver_server_properties_cpu_count

  • sqlserver_server_properties_server_memory

  • sqlserver_server_properties_engine_edition

  • sqlserver_server_properties_uptime

  • sqlserver_server_properties_db_online

  • sqlserver_server_properties_db_offline

  • sqlserver_server_properties_db_recovering

  • sqlserver_server_properties_db_recoveryPending

  • sqlserver_server_properties_db_suspect

  • sqlserver_server_properties_db_restoring

  • sqlserver_performance

  • sqlserver_database_io_read_bytes

  • sqlserver_database_io_write_bytes

  • sqlserver_database_io_reads

  • sqlserver_database_io_writes

  • sqlserver_database_io_read_latency_ms

  • sqlserver_database_io_write_latency_ms