DBA Dash is an open-source SQL Server monitoring tool automating daily checks, performance tracking, and configuration change logging. It simplifies routine tasks and provides deep operational insights across SQL Server estates.

How It Works

A Windows agent connects to SQL Server instances, collecting data on backups, DBCC, corruption, drive space, agent jobs, availability groups, mirroring, log shipping, and performance counters. It captures running queries, waits, IO, and slow queries via Extended Events. An integrated AI Assistant provides advanced analysis.

Quick Start & Requirements

Installation follows a quick-start guide. Requirements: SQL Server 2016 SP1+ for DBADashDB repository; SQL Server 2008-2022 (incl. Azure/RDS) for monitored instances; Windows machine for agent (monitors multiple instances); .NET Desktop Runtime 8; agent account with required permissions (see security doc). Links to download, docs, AI Assistant setup, quick-start, and upgrade help are provided.

Highlighted Details

• Comprehensive monitoring: backups, DBCC, corruption, drive space, agent jobs, AGs, log shipping, mirroring, identity columns, custom checks.
• Performance metrics: OS counters, custom metrics, SP/function/trigger stats, waits, memory, running queries, IO, blocking, slow query tracing.
• Configuration tracking: patching, hardware, trace flags, alerts, drivers, TempDB/DB files, Resource Governor, Query Store, schema changes, agent job DDL.
• Supports Azure DB monitoring and S3 bucket integration for isolated environments.
• AI Assistant for advanced analytics.

Maintenance & Community

The README does not specify contributors, sponsorships, partnerships, or community channels (Discord/Slack). A public roadmap is also not mentioned.

Licensing & Compatibility

The README omits explicit license details. Users must verify licensing terms for adoption, particularly for commercial use or closed-source integration.

Limitations & Caveats

Agent requires Windows. DBADashDB repository needs SQL Server 2016 SP1+. Agent service account requires specific permissions (see security documentation).