SQL Server Instance Overview

Provides visibility into SQL Server instances, database states, and performance trends.
This dashboard helps monitor database availability, connection counts, and long-running queries while tracking data and log growth over time for each instance.

Instance Health and Database Status

This dashboard displays high-level metrics for deadlocks, total databases, active connections, and longest-running queries. The Database Details table lists all SQL instances with associated databases, their current state, and size metrics to assess availability and capacity at a glance.

Data and Log Utilization

This dashboard shows trends for database data size and log size over time, helping identify storage growth patterns, capacity thresholds, and potential optimization opportunities.

Use Cases

Use Case	Description
Monitor SQL Server instance health	Monitor overall SQL Server instance health and ensure databases are online and responsive.
Identify high-usage instances	Identify instances with unusually high connection counts or long-running queries.
Track storage usage trends	Track storage usage trends to prevent capacity issues or unexpected data growth.