Roadmap for SQL Toolbox

[mmarcec]

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