SQLMonitor¶
Open-source Microsoft SQL Server monitoring, baselining, and alerting — powered by SQL Agent jobs and Grafana.
SQLMonitor helps DBAs and developers understand current load vs. usual load across every SQL Server instance they operate — DEV, TEST, UAT and PROD — without the price tag of enterprise monitoring tools.
-
Live dashboards
Ready-to-import Grafana dashboards for server health, wait stats, query workload, disk space, backups, AGs, and more.
-
SQL-Agent-native collection
Metric collection is plain SQL Agent jobs calling stored procedures — easy to read, debug and extend.
-
One-command deploy
A single PowerShell wrapper script onboards an instance end-to-end: objects, jobs, proxies, partitions, linked servers, logins.
-
Alerting built-in
Python-based alert engine with routing to PagerDuty, Slack and Email.
Live demo¶
A fully-provisioned lab instance is available for you to click around:
Open live dashboard Job Activity Monitor
| Portal | URL | User | Password |
|---|---|---|---|
| Grafana | sqlmonitor.ajaydwivedi.com | guest | ajaydwivedi-guest |
| SQL Instance | sqlmonitor.ajaydwivedi.com:1433 | grafana | grafana |
What you get¶
| Capability | What it looks like |
|---|---|
| Core health metrics — CPU, Memory, Disk, I/O, Waits, Transactions, Active Requests, Blocking | Monitoring - Live - Distributed |
| Quest-recommended Perfmon counters across every instance | Monitoring - Perfmon Counters |
| WhoIsActive workload — long runners, blockers, top consumers | WhoIsActive - Workload |
| Extended Events workload — normalized & hashed query trends | XEvent - Workload / Trend |
| Blitz Server Health & BlitzIndex Analysis | Blitz Server Health / BlitzIndex |
| Availability Group health, Backup History, Disk Space, File IO Stats | AG Health / Backups / Disk / File IO |
| Alerting via PagerDuty / Slack / Email | Alert Engine |
Optional Prometheus path via sql_exporter + Windows Exporter | Prometheus |
60-second elevator pitch¶
Why teams adopt SQLMonitor
- No SaaS. Everything runs on your own SQL Servers and Grafana.
- Boring tech on purpose. Just SQL Agent jobs, stored procedures, T-SQL tables, PowerShell and Python. Debug it like any other DBA asset.
- Scales cheaply. Hourly-partitioned tables with page compression. Memory-Optimized tables on the central inventory server. Dynamically parameterized Grafana queries so concurrent dashboard users do not thrash the monitor.
- Flexible topology. Distributed (each instance monitors itself) or Central (one inventory server polls everyone) — same codebase.
- Broad SQL Server support. All supported SQL Server versions (XEvent collection requires 2012+).
Where next?¶
- New here? Start with Why SQLMonitor and Architecture.
- Ready to install? Jump to Deployment → Install Walkthrough.
- Looking for a specific dashboard? See the Dashboards Index.
- Want to alert on something? See Alerting.