Promhub Logo Prom hub

Microsoft SQL Server
173,632 5.0 (2 reviews)

Created 2/19/2021
Updated 2/19/2021
Revision 1
Categories
Databases
Grafana Version >=7.4.2
Datasources
Prometheus

Description

This dashboard monitors Microsoft SQL Server health and performance with a focus on resource utilization, activity, and waits. It highlights server resource overview through metrics like mssql_total_physical_memory_kb and mssql_available_physical_memory_kb, database activity via mssql_batch_requests and mssql_deadlocks, and I/O and wait statistics such as mssql_page_fault_count and wait-related dashboards like Database ${database} wait by I/O stall and mssql_total_page_file_kb.

Screenshots

Dashboard screenshot 1
Source Grafana.com

Used Metrics 16

  • mssql_available_page_file_kb

  • mssql_available_physical_memory_kb

  • mssql_batch_requests

  • mssql_connections

  • mssql_database_state

  • mssql_deadlocks

  • mssql_instance_local_time

  • mssql_io_stall

  • mssql_io_stall_total

  • mssql_kill_connection_errors

  • mssql_log_growths

  • mssql_page_fault_count

  • mssql_page_life_expectancy

  • mssql_total_page_file_kb

  • mssql_total_physical_memory_kb

  • mssql_user_errors

Get Dashboard✕
Download
Copy to Clipboard

Dashboard Preview - Microsoft SQL Server

Most Grafana dashboards are not optimized for small screens. For the best experience, view this preview on a larger screen.
grafana.shipit.dev/microsoft-sql-server