Faster, Smarter Automation with the Latest Command-Line Updates in Database Health Monitor
Every year during audit and compliance season, support tickets flood in with the same urgent request: DBAs need a fully automated, hands-off way to generate the same comprehensive SQL Server health reports they create manually in the Database Health Monitor GUI — without ever launching the app.
They want a scheduled task that runs at 3 AM (or any interval) to connect to one or many instances, collect all diagnostic data, and deliver a professional report to a shared folder or email — completely unattended. That real-world need is why we added true silent mode and powerful command-line parameters to Database Health Monitor.
The latest release lets you run Database Health Monitor 100% from the command line or scheduled tasks, producing the exact same detailed reports as the GUI:
- Full deadlock history with graphs
- Current and historical blocking chains
- CPU, memory, and wait-stats trends
- Backup status and history
- Database and file-growth trends
- Index fragmentation and statistics
- Missing indexes and Query Store insights
- Configuration checks and best-practice alerts
- Dozens of additional health checks
New parameters make automation easy: specify report type (Quick Scan, Full Health Report, etc.), output folder, format (HTML/PDF), and target instances. The tool uses saved connection details from config files — no plaintext passwords — so one command can process 5, 10, or 50 instances sequentially.
Many teams now run a daily 7:00 AM task. By the time the DBA checks email or the share, a fresh, timestamped report is waiting with instant insights into blocking, deadlocks, backups, space, and performance. Historical reports in dated folders make trend comparison effortless.
This feature exists because customers demanded it — often in desperate, all-caps emails during crunch time. Database Health Monitor is built on real SQL Server pain points, and automated reporting is a prime example.
If you’ve ever wanted full Database Health Monitor power without opening the GUI, try the new command-line options today. Keep the feedback coming — the next feature is likely something another DBA like you needs right now.