MSSQL Dashboard – Free Download | Anchored Tech Solutions
Free & Open Source Tool

Monitor Your
SQL Servers
Like a Pro

A free, self-hosted MSSQL monitoring dashboard built by the DBAs at Anchored Tech Solutions. Runs on your machine. No cloud, no subscription, no data leaving your network.

Python + FastAPI Free Forever Local / Intranet Windows + Linux SQL · Windows · TLS Auth
MSSQL Dashboard — localhost:8080
CPU
23%
Memory
14.2 GB
Blocked
0
Availability Groups
AG-PROD-01 PRIMARY → SQL-NODE-1 SYNCHRONIZED
AG-PROD-01 SECONDARY → SQL-NODE-2 SYNCHRONIZED
AG-DR-02 SECONDARY → SQL-DR-1 SYNCHRONIZING
3
Auth Methods
100%
Free Forever
0
Cloud Required
5 min
To Install

Everything Your SQL
Environment Needs

Built by DBAs for DBAs. Covers all the critical monitoring points for production SQL Server environments.

💻

Server Health

Real-time CPU usage, buffer pool memory, SQL Server edition & version, service uptime, and database list with states.

🔒

Blocked Sessions

Instantly see blocked sessions with the full blocking chain — who is waiting, on what, for how long, and the exact SQL being executed.

Wait Stats

Top 10 wait types filtered for noise. Identify bottlenecks in CPU, I/O, locks, network, and memory at a glance.

🔄

Availability Groups

AG replica roles, synchronization state, redo queue size (KB), send rate, lag in seconds, and failover mode — per database.

🖥️

FCI Clusters

Current active node, all cluster nodes and status, shared disk group health, and cluster quorum properties.

📦

Log Shipping

Primary, secondary, and monitor role tracking. Last backup/copy/restore times with automatic threshold violation detection.

🔔

Alert Rules

Define your own thresholds — CPU %, blocked sessions, lag minutes, etc. Alerts stored locally with acknowledge workflow.

🔐

All 3 Auth Types

SQL Server Auth, Windows/Integrated Auth, and TLS/Certificate Auth for encrypted servers — including AWS RDS with custom CA certs.

🗃️

Metric History

7-day rolling metric snapshots stored in local SQLite. View CPU & memory trends over time for any registered server.

What You Need
to Install

Lightweight requirements — runs on any Windows or Linux machine on your intranet.

Requirement Version Status Download
Python 3.11 or newer Required python.org ↗
ODBC Driver for SQL Server 17 or 18 Required aka.ms/odbc18 ↗
Visual C++ Redistributable 2019+ Required (Windows) Download ↗
TLS Certificate .cer / .pem Only for Encrypted Servers From your DBA / AWS RDS console
SQL Server login with VIEW SERVER STATE Required Grant in SSMS

Up and Running
in 5 Minutes

Download, run one file, open your browser. No Docker, no cloud accounts, no configuration files to hand-edit.

01

Download

Download the ZIP file below and extract it anywhere on your machine — a folder on your desktop works fine.

02

Install Prerequisites

Make sure Python 3.11+ and the Microsoft ODBC Driver 18 are installed. Links are in the table above.

03

Run the Installer

Double-click install.bat on Windows, or run the shell script on Linux. It installs Python packages and starts the server automatically.

install.bat
04

Open Dashboard

Your browser opens automatically to localhost:8080. Use the Add Server button to register your first SQL Server instance.

http://localhost:8080
05

Add Your Servers

Enter the hostname or VNN listener name, select your auth type (SQL, Windows, or TLS/Cert), and click Test Connection.

06

You're Live

The dashboard starts polling your servers immediately. Health metrics, AG status, FCI nodes, and log shipping lag — all on one screen.

⬇ Free Download

MSSQL Dashboard
v1.0.0

Full source code included. No license keys, no usage limits, no call-home telemetry. Your data stays on your network.

Windows 10/11 + Server 2016+
Ubuntu 20.04+ / RHEL 8+
Python 3.11+ Required
ODBC Driver 17 or 18 Required
v1.0.0 — Phase 1 Backend
mssql-dashboard
Free forever · MIT License

Common Questions

Everything you need to know before installing.

No. 100% of data stays on your machine and network. The dashboard is a local FastAPI server that connects directly to your SQL Server instances via ODBC. No telemetry, no analytics, no call-home. Your credentials are encrypted at rest using Fernet encryption in a local SQLite file.
SQL Server 2012 and newer. Most queries use DMVs that have been available since 2008 R2, but AG features require 2012+. Log shipping monitoring works on all editions that support it, including Standard and Enterprise.
The minimum required is VIEW SERVER STATE on the master database. For log shipping monitoring you also need read access to msdb.dbo.log_shipping_monitor_* tables. We recommend creating a dedicated read-only monitoring login — no sysadmin needed.
Download the RDS CA certificate from the AWS console (a .pem file). Drop it in a certs/ folder inside the dashboard directory. When adding the server, select TLS/Certificate auth type and paste the full path to the certificate. The dashboard will pass it directly to the ODBC driver.
Yes. Run it on a shared machine on your intranet and share the URL (e.g. http://192.168.1.50:8080). Anyone on the same network can open it in their browser. Each person installs their own copy if they prefer a local setup.
Version 1.0.0 is the complete backend API with all monitoring queries, encryption, and a Swagger UI at /docs. The full React frontend (graphical dashboard with charts, topology views, and alert center) is in active development and will be released as v1.1.0. Follow the GitHub repo or check back on this page for updates.
© 2025 Anchored Tech Solutions, LLC. MSSQL Dashboard is released under the MIT License.