Command Line Parameters
No Splash
/nosplash or -nosplash : Hides the splash screen at startup, this also skips the check to see if there is a new version of Database Health Monitor available.
Automated / Silent Report
DatabaseHealth.exe /silentreport “ReportName” /filelocation “C:\Reports” /instancenames “ServerName”
Required Parameters
/silentreport – Specifies which reports to generate
• Use “ALL” to generate every available report
• Use specific report names separated by commas
• Example: “Health Report,Backup Status,File Utilization”
/filelocation – Output directory for generated Word documents
• Must be a valid directory path with write permissions
• Directory will be created automatically if it doesn’t exist
• Example: “C:\Monthly Reports” or “\server\share\reports”
/instancenames – SQL Server instances to report on
• Use server names as they appear in Database Health Monitor
• Separate multiple instances with commas
• Example: “localhost” or “SQL01,SQL02\DEV,SQL03\PROD”
Optional Parameters
/databasenames – Filter reports to specific databases
• If omitted, reports cover all databases on the specified instances
• Separate multiple databases with commas
• Example: “AdventureWorks,Northwind”
Available Reports
Comprehensive Reports:
• Health Report – Complete server health overview with charts and metrics
• Quick Scan Report – Fast assessment of common issues
Backup & Maintenance:
• Backup Status – Database backup information and schedules
• DBCC CheckDB – Database consistency check results
• File Utilization – Database file space usage and growth
• VLFs – Virtual Log File analysis
Performance Reports:
• CPU by Database – CPU usage breakdown by database
• Wait Statistics – SQL Server wait statistics analysis
• Missing Indexes – Recommended missing index suggestions
• Problem Indexes – Inefficient or problematic indexes
• Plan Cache – Query plan cache analysis
• Connections – Current database connections
System Information:
• Inventory – Complete SQL Server configuration details
• Error Log – SQL Server error log entries
• Job History – SQL Agent job execution history
• Failed Jobs – Recent job failures
• Logins – Security and login information
• Orphan Users – Database users without corresponding logins
Database Analysis:
• Large Tables – Largest tables by size
• Databases by Size – Database size comparison
• Statistics – Index statistics status
• Index Fragmentation – Index fragmentation analysis
• Duplicate Indexes – Potentially redundant indexes
• Unused Indexes – Indexes that may not be needed
Advanced Reports (require historic monitoring):
• CPU Heat Map – CPU usage patterns over time
• Disk Latency Heat Map – Storage performance trends
• Blocking Heat Map – Query blocking patterns
• Deadlocks – Deadlock analysis and history
• Performance History – Long-term performance trends
Usage Examples
Generate health report for single server: DatabaseHealth.exe /silentreport “Health Report” /filelocation “C:\Reports” /instancenames “localhost”
Multiple reports for production environment: DatabaseHealth.exe /silentreport “Backup Status,File Utilization,Missing Indexes” /filelocation “\fileserver\reports” /instancenames “SQLPROD01,SQLPROD02”
All reports for development servers: DatabaseHealth.exe /silentreport ALL /filelocation “C:\Dev Reports” /instancenames “SQLDEV01\DEV,SQLDEV02\TEST”
Database-specific reporting: DatabaseHealth.exe /silentreport “File Utilization,Statistics” /filelocation “C:\DB Reports” /instancenames “localhost” /databasenames “AdventureWorks”
Output Files
The generator creates Word documents (.docx) with embedded charts and data tables. Files are named using the format: ReportName_InstanceSummary_DatabaseScope.docx
Chart images are saved separately in a Charts subdirectory for reference.
Requirements
• SQL Server instances must already be configured in Database Health Monitor
• Appropriate database permissions for report generation
• Write permissions to the specified output directory
• For historic reports, historic monitoring must be enabled