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.
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.
Download
Download the ZIP file below and extract it anywhere on your machine — a folder on your desktop works fine.
Install Prerequisites
Make sure Python 3.11+ and the Microsoft ODBC Driver 18 are installed. Links are in the table above.
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
Open Dashboard
Your browser opens automatically to localhost:8080. Use the Add Server button to register your first SQL Server instance.
http://localhost:8080
Add Your Servers
Enter the hostname or VNN listener name, select your auth type (SQL, Windows, or TLS/Cert), and click Test Connection.
You're Live
The dashboard starts polling your servers immediately. Health metrics, AG status, FCI nodes, and log shipping lag — all on one screen.
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.
Common Questions
Everything you need to know before installing.
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.
.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.
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.
/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.
Need Custom SQL Server Monitoring
or Database Work?
The team at Anchored Tech Solutions provides enterprise database administration,
custom monitoring solutions, and SQL Server consulting for businesses of all sizes.
