layout: default title: SQLTriage — Free SQL Server Monitoring —
> SQLTriage_
No agents. No per-server licensing. Single exe.
SQLTriage is a Windows desktop application — Blazor UI running inside WPF — that monitors multiple SQL Server instances in real time. It also runs as a headless Windows Service for 24/7 monitoring with remote browser access.
No software is installed on your SQL Servers. Everything runs from a single exe on your workstation or a dedicated monitoring host. .NET runtime and WebView2 are bundled — nothing to install separately.
Add Server — connect to any SQL Server instance in seconds
What's New — in-app release notes and update notifications
Wait Stats — real-time and historical wait category analysis
Live Sessions — active sessions, blocking chains, top queries
Database Health — per-database metrics, growth trends, backup status
Instance Overview — key metrics dashboard with time-series charts
Environment Map — force-directed topology graph across all servers
Multi-Server — monitor 50+ SQL Server instances from one place
Full SQL Audit — comprehensive health check across all connected instances
Vulnerability Assessment — Microsoft SQL Assessment API with 472+ checks
Azure Blob Export — securely upload audit results to Azure Blob Storage
Notification Channels — Email, Teams, Slack, PagerDuty, ServiceNow, Webhooks, WhatsApp
Maturity Roadmap — 5-level DBA maturity framework across all servers
Alerting — 80 alerts with IQR dynamic baselines and escalation policies
Query Plan Viewer — interactive graphical execution plan with per-operator cost %
Risk Register — compliance mapping to ISO 27001, SOC 2, and NIST frameworks
⚡ Live Dashboards
Active sessions, blocking chains, top CPU/IO queries, wait stats — refreshing every 30 seconds. Switch servers instantly.
🔍 Execution Plan Viewer
Interactive graphical plan with per-operator cost %, predicate detail, missing index warnings, and implicit conversion flags.
🔔 Smart Alerting
69 built-in alerts with dynamic IQR baselines that learn your server's normal behaviour. 7 channels: Email, Teams, Slack, PagerDuty, ServiceNow, Webhooks, WhatsApp.
🛡️ Vulnerability Assessment
500+ security checks against your SQL Server configuration. Exportable results with severity ratings and remediation guidance.
📊 Health Checks
Quick Check (30 seconds) and Full Audit (comprehensive deep-dive). Covers configuration, security, backups, fragmentation, and missing indexes.
🗺️ Maturity Roadmap
Maps sp_Blitz and sp_triage output to a 5-level maturity framework across multiple servers. PDF export for management reporting.
🖥️ Multi-Server
Monitor all your SQL Server instances from one place. Tag servers by environment (Production, Staging, DR) and filter across views.
🔧 Windows Service Mode
Run headless for 24/7 monitoring. Access dashboards from any browser on the network via Kestrel HTTPS.
☁️ Azure Blob Export
Auto-upload audit results as CSV to Azure Blob Storage. Supports SAS tokens, User Delegation SAS, and AzCopy fallback.
🌐 Environment Map
Force-directed topology graph showing all servers, their AG relationships, and connection health at a glance.
🔐 Role-Based Access
In Service mode: Admin, Operator, and Viewer roles. OAuth login via Google or Microsoft. Desktop mode is always Admin.
472 checks drawn from 9 industry sources, covering security hardening, performance best practices, HA/DR readiness, and configuration hygiene.
Sources & frameworks:
- Microsoft SQL Assessment API (220 checks) — the official Microsoft recommended ruleset for SQL Server
- Microsoft Learn (96 checks) — documented best practices from Microsoft product documentation
- Brent Ozar / sp_Blitz (~71 checks) — community-validated checks from the SQL Server First Responder Kit
- Microsoft SQL Assessment Plus (33 checks) — extended ruleset for enterprise configurations
- SQLSkills (14 checks) — checks derived from Paul Randal and Kimberly Tripp's SQL Server guidance
- CIS Benchmark for SQL Server (6 checks) — Center for Internet Security hardening rules (TRUSTWORTHY, BUILTIN\Administrators, CONTROL SERVER)
Checks are evaluated read-only against live DMVs — nothing is written to your SQL Server.
| SQLTriage | sp_Blitz | SQLWATCH | SolarWinds DPA | Redgate SQL Monitor | Idera SQL DM | |
|---|---|---|---|---|---|---|
| Cost | Free | Free | Free | $$$/server | $$$/server | $$$/server |
| Desktop UI | ✓ Blazor/WPF | SSMS only | ✓ Grafana | ✓ Web | ✓ Web | ✓ Desktop |
| Execution plan viewer | ✓ Interactive | ✗ | ✗ | ✓ | ✓ | ✓ |
| Alerting + notifications | ✓ 7 channels | ✗ | Limited | ✓ | ✓ | ✓ |
| Vulnerability assessment | ✓ 472 checks | ~250 checks | ✗ | ✗ | Limited | Limited |
| CIS Benchmark checks | ✓ | ✗ | ✗ | ✗ | ✗ | ✗ |
| Runs as Windows Service | ✓ | ✗ | Partial | ✓ | ✓ | ✓ |
| Agent on SQL Server | Not required | Not required | Required | Required | Required | Required |
| Azure SQL MI support | ✓ | Limited | Limited | ✓ | ✓ | ✓ |
| Maturity roadmap | ✓ 5-level | ✗ | ✗ | ✗ | ✗ | ✗ |
| Role-based access | ✓ Admin/Operator/Viewer | ✗ | ✗ | ✓ | ✓ | ✓ |
| Open source | ✓ GPL v3 | ✓ MIT | ✓ Apache 2 | ✗ | ✗ | ✗ |
sp_Blitz check count per Brent Ozar Unlimited documentation (~250 T-SQL health checks). Commercial tool feature claims based on publicly available documentation; verify current capabilities before purchase.
Current release: v0.85.2 — production-quality, actively developed. Suitable for production DBA use. Both options below are self-contained: .NET runtime and WebView2 are bundled.
⬇ SQLTriage-Setup.exe
Guided installer. Start menu shortcut, optional Windows Service install, upgrade detection, "Launch now" on finish. Recommended for most users.
Download from Releases →📦 SQLTriage.zip
Extract to any folder (e.g. C:\Tools\SQLTriage) and run SQLTriage.exe. No installation required. Good for air-gapped or portable use.
- Download from the Releases page — Setup.exe or ZIP
- Run it — no prerequisites to install separately
- Go to Servers → Add Server, enter your SQL Server name, click Test → Save
- Open Live Monitor Ctrl+2 to see live sessions, wait stats, and top queries
- Run a Quick Check Ctrl+Q for an instant health snapshot
The built-in onboarding wizard guides you through the setup on first run. SQLWATCH is optional — it unlocks additional historical dashboards but is not required to start monitoring.
SQL Server permissions needed: VIEW SERVER STATE · VIEW DATABASE STATE — no sysadmin, no agent install on the SQL Server.
| SQLWATCH | Marcin Gminski — SQL Server monitoring framework and data foundation |
| sp_Blitz | Brent Ozar Unlimited — SQL Server First Responder Kit |
| sp_triage | Adrian Sullivan — SQL health check scripts |
| PerformanceMonitor | Erik Darling — Performance Monitor framework and diagnostic queries |
| MadeiraToolbox | Eitan Blumin — SQL Server maintenance and best-practice scripts |
| TigerToolbox | Pedro Lopes (Microsoft) — SQL Server tools and utilities |
| Ola Hallengren | SQL Server Maintenance Solution — industry-standard backup, integrity check, and index maintenance scripts |
| Glenn Berry | SQL Server Diagnostic Information queries — DMV-based diagnostic scripts used widely in the community |
| Konstantin Taranov | sqlserver-kit — curated SQL Server scripts and best practices collection |
| Wayne Sheffield | SQL Server community scripts for performance and configuration analysis |
| Tracy Boggiano | SQL Server community scripts and DBA toolkit contributions |
| Tim Ford | SQL Agent Jobs and SQL Server community diagnostic scripts |
Released under the GNU General Public License v3.0.