Microsoft SQL Server Dashboard

This is a comprehensive Microsoft SQL Server Dashboard designed to monitor key performance indicators. It provides real-time insights into your SQL Server environment

Microsoft SQL Server Dashboard

Overview

This is a comprehensive Grafana dashboard designed for monitoring Microsoft SQL Server. It provides real-time insights into your SQL Server environment, making it easy for both technical and non-technical users to understand the performance of their SQL Server instances.

Features

The dashboard includes the following panels:

Uptime: Displays the SQL Server start time.
Queries per Second: Shows the average duration of queries and their execution count.
Table Locks: Provides information about the current table locks in the system.
Buffer Pool Hit Rate: Visualizes the rate of hits in the buffer pool.
Index Usage: Presents the usage statistics of indexes.
Buffer Pool Usage: Monitors the usage of the buffer pool.
CPU Utilization: Tracks the CPU usage of the SQL Server.
Disk I/O: Monitors the disk input/output operations.
Network Usage: Displays the network traffic related to the SQL Server.
Memory Usage: Provides insights into the memory consumption of the SQL Server.
Query Cache: Displays the query cache statistics in the SQL Server.
Current Connections: Shows the current connections to the SQL Server.
Table Locks: Provides information about the current table locks in the system.
Running Threads: Displays the number of running threads in the SQL Server.
Open Files Limit: Shows the limit of open files in the SQL Server.
Temp Tables Created On Disk: Visualizes the number of temporary tables created on disk.
Slow Queries: Displays the slow queries in the SQL Server.
RowCount: Shows the total number of rows across all tables in the database.
Total Space: Displays the total space (in MB) allocated to all tables in the database.
Used Space: Shows the space (in MB) currently used by all tables in the database.
Unused Space: Provides information on the unused space (in MB) within the allocated space for all tables in the database.

You are welcome to contribute to the project at this link. If you find it interesting, please consider giving it a star ⭐️ ! Your support is greatly appreciated.

Revisions