If you’ve ever wished for a single tool that could quickly assess the true health of your SQL Server, including performance, configuration, security, and operational stability, your wait is over.
Today, we’re excited to announce the launch of AI SQL Tuner’s SQL Server Health Check, a powerful new tuning goal in AI SQL Tuner designed to give DBAs, developers, and IT teams a complete, AI‑driven diagnostic of their SQL Server environment.
Whether you’re troubleshooting slow performance, validating a new deployment, or performing routine maintenance, ServerHealth delivers the deep insights you need in one unified report.
Table of Contents
What Is ServerHealth?
ServerHealth is an end‑to‑end SQL Server health assessment that analyzes your instance across performance, configuration, security, and operational reliability.
It collects critical telemetry from DMVs, system configuration, Query Store, and more—then uses AI to translate raw data into clear, actionable recommendations.
This isn’t just another DMV script; it’s a holistic SQL Server health check powered by intelligent analysis. Here is an example of the results.
What ServerHealth Analyzes
1. Wait Statistics
Identify the root causes of performance slowdowns, including:
- I/O bottlenecks (PAGEIOLATCH_*, WRITELOG)
- CPU pressure (SOS_SCHEDULER_YIELD, CXPACKET)
- Memory contention (RESOURCE_SEMAPHORE)
- Locking and blocking (LCK_*)
2. I/O Performance
Pinpoint storage issues with:
- Read/write latency per file
- Total I/O stall times
- MB read/written
- File‑level performance hotspots
3. System Configuration
Get a complete snapshot of your SQL Server instance:
- CPU and scheduler configuration
- Memory allocation and targets
- SQL Server version, edition, and patch level
- HADR, clustering, uptime
- Collation and security settings
4. sp_configure Settings
Detect misconfigurations such as:
- Non‑default or risky settings
- Memory misallocation
- MAXDOP and parallelism issues
- Advanced settings that may need tuning
5. Query Performance
Analyze the most expensive queries by:
- CPU time
- Logical reads
- Memory grants and spills (SQL 2019+)
- Execution frequency and patterns
6. High‑Value Missing Indexes
Find the top missing indexes with:
- Impact score
- Equality/inequality columns
- Included columns
- Seek/scan counts
- Recommendations to run IndexTuning for deeper analysis
7. Query Store Configuration
Review Query Store health across all databases:
- State (OFF, READ_ONLY, READ_WRITE)
- Storage usage
- Capture/cleanup settings
- Retention policies
- Read‑only reasons
8. DBCC CHECKDB Status
Ensure database integrity with:
- Last CHECKDB timestamp
- Days since last run
- OK/WARNING/CRITICAL indicators
- Databases overdue or never checked
9. Connection Encryption
Improve security by reviewing:
- Encryption status
- Authentication scheme
- Client network address
- Warnings for unencrypted connections
10. Sysadmin Role Membership
Audit privileged access:
- Full list of sysadmin accounts
- Excessive membership warnings
- Risky accounts (sa, BUILTIN groups)
- Least‑privilege recommendations
11. Recent Deadlocks (Past 7 Days)
Quickly detect concurrency issues:
- Timestamps and summary counts
- Recommendations for deeper analysis with FixDeadlocks
- Platform‑specific support (On‑prem, MI)
How to Run ServerHealth
Run it with a single command:
aisqltuner -S localhost -goal ServerHealth -EExport to HTML:
aisqltuner -S localhost -goal ServerHealth -E -o serverhealth_report.htmlAzure AD, SQL Auth, custom OpenAI deployments, and multilingual output are all supported.
What You Get: Actionable AI Recommendations
ServerHealth doesn’t just collect data—it interprets it.
You’ll receive AI‑generated guidance across:
Performance Improvements
- CPU optimization
- Memory tuning
- I/O enhancements
Configuration Optimization
- sp_configure recommendations
- Database‑level settings
- Version‑specific best practices
Security Enhancements
- Authentication and encryption guidance
- Privilege audits
- Edition‑appropriate recommendations
Operational Best Practices
- Maintenance schedules
- Monitoring suggestions
- Capacity planning
Proactive Maintenance
- Preventive actions
- Long‑term optimization strategies
- Trend analysis over time
SQL Server Version Support
- SQL Server 2019+ – Full feature set
- SQL Server 2017 and earlier – Full analysis with estimated plans
- Azure SQL Managed Instance – Fully supported
Best Practices for Using ServerHealth
- Run during normal workload periods
- Compare results monthly or quarterly
- Review all sections for a holistic view
- Test changes in non‑production
- Combine with IndexTuning or CodeReview for deeper analysis
Troubleshooting Tips
- No data found → Ensure workload is running
- Access denied → Grant
VIEW SERVER STATE - Empty wait stats → Server may have restarted
Sample Results
See Server Health Sample Results for an example of the results you can expect in just minutes.
Start Using ServerHealth Today
The new ServerHealth goal gives you the visibility you’ve always wanted into your SQL Server environment—without the complexity of manual scripts or fragmented tools.
If you’re ready to improve performance, tighten security, and prevent issues before they happen, ServerHealth is your new go‑to diagnostic.
Run your first health check today and see your SQL Server like never before.
