Detailed Metrics

In-depth analysis dashboards for troubleshooting and performance optimization.

Dashboards in this category

Analyzes database and table growth. Visualizes trends, detects abnormal increases and manages identities approaching their limit.

Identifies missing, duplicate and underutilized indexes. Provides recommendations to optimize query performance.

Complete visibility of SQL Server Agent Jobs: successful, failed, canceled executions and jobs exceeding their usual duration.

SQL Server process monitoring: active sessions, locks, blocking chains, long-running queries and deadlocks.

Queries with room for improvement sorted by CPU, reads, duration or executions, with optimized version, recommendations and an execution plan viewer.

Performance issues: Start with Process Status to identify locks
Disk space: Review Database Growth for growth trends
Slow queries: Use Slow Queries to see which queries to improve, and Index Tuning to optimize indexes
Failed automation: Check Job Status for problematic jobs