SQL Server Monitoring with prometheus
2,723 3.5 (2 reviews)

Created 1/7/2020
Updated 2/6/2020
Revision 1
Categories
Databases
Grafana Version >=6.5.2
Datasources
Prometheus
Get Dashboard
Download
Copy to Clipboard
Source Grafana.com

Used Metrics 21

  • sqlserver_server_properties_db_offline

  • sqlserver_server_properties_db_online

  • sqlserver_server_properties_db_suspect

  • sqlserver_server_properties_db_recovering

  • sqlserver_server_properties_db_recoveryPending

  • sqlserver_server_properties_db_restoring

  • sqlserver_performance_value

  • sqlserver_memory_clerks_size_kb

  • sqlserver_server_properties_cpu_count

  • Lock_Memory__KB____Memory_Manager

  • Database_Cache_Memory__KB____Memory_Manager

  • Connection_Memory__KB____Memory_Manager

  • Log_Pool_Cache_Misses_sec____Total___Databases

  • Log_Pool_Disk_Reads_sec____Total___Databases

  • Log_Pool_Requests_sec____Total___Databases

  • sqlserver_database_io_read_bytes

  • sqlserver_database_io_write_bytes

  • sqlserver_database_io_read_latency_ms

  • sqlserver_database_io_write_latency_ms

  • sqlserver_waitstats_wait_time_ms

  • sqlserver_waitstats_waiting_tasks_count