Roadmap for SQL Toolbox #4
Description
Product Roadmap
SQL Toolbox PRO is actively developed and production-driven.
The roadmap focuses on practical diagnostics that help mid–senior SQL Server developers identify performance problems faster in real environments.
v1.1 – Smart Diagnostics Upgrade (Planned)
Focus: Better intelligence, less noise.
Index Intelligence
- Detect duplicate and overlapping indexes
- Suggest INCLUDE column optimization instead of recommending entirely new indexes
Performance Diagnostics
-
Wait Statistics Root Cause Analyzer
Map wait types (CXPACKET, PAGEIOLATCH, LCK, etc.) to likely root causes. -
Unused Index Detector
Identify indexes that add write overhead but provide no read benefit.
Improved Severity Scoring
- Impact weighted by database size and activity
- Smarter prioritization of tuning recommendations
Enhanced HTML Report
- Clear severity color coding
- Improved summary layout
- Faster report generation
Configurable Exclusions
- Exclude specific databases
- Exclude specific schemas
Target: 4–6 weeks
v1.2 – Performance Intelligence Layer
Focus: Regression awareness & deeper analysis.
Query Performance Regression Detection
- Detect sudden query performance degradation
- Identify queries with unstable execution times
Query Store Integration (if enabled)
- Detect execution plan regressions
- Highlight plan changes over time
Parameter Sensitivity Diagnostics
- Identify queries potentially affected by parameter sniffing
Automated Regression Thresholds
- Configurable performance degradation thresholds
Maintenance Window Mode
- Restrict execution to defined maintenance windows
Extended Performance Trend History
- Historical tracking of performance diagnostics
Target: 2–3 months
v2.0 – Multi-Server & Enterprise Enhancements
Focus: Scale and automation.
Multi-Server Diagnostics
- Centralized analysis across multiple SQL Server instances
Alerting System
- Optional email alerting for detected performance risks
Advanced Reporting
- Export options (HTML / JSON / CSV)
Deployment Automation
- PowerShell deployment and scheduled execution
Target: Long-term evolution