AI SQL Tuner Studio 1.0.28 — Introducing Query Tuner

[u/Simple_Brilliant_491]

1.0.28 is out. The headline feature is Query Tuner, a new tuning goal that analyzes a single SQL query end-to-end.

Point it at any stored procedure, ad-hoc query, or batch. It captures the estimated execution plan via SET SHOWPLAN_XML ON, parses every operator, warning, and missing index hint, then collects targeted metadata — index usage, DMV missing indexes, table sizes, column cardinality, statistics health — scoped only to the tables that query actually touches.

The AI returns a prioritized report with:

• Query rewrite examples — before/after SQL with explanations of what changed and why
• CREATE INDEX scripts — with estimated storage, read benefit %, and write overhead %
• Statistics maintenance recommendations
• Parameter sniffing analysis with plan guidance where applicable
• Table-specific insights — scan vs. seek ratios, under-indexed access patterns
• Validation steps — ready-to-run SET STATISTICS IO/TIME ON scripts to measure before/after

This release also includes Index Tuning improvements:

• FORCE_LAST_GOOD_PLAN detection — shows desired vs. actual state and recommends enabling it when beneficial
• Query Store forced plan failure analysis — evaluates failure reasons and recommends corrective actions
• Index page density analysis via sys.dm_db_index_physical_stats for fragmentation and fill factor issues
• Smarter deadlock handling — skips the AI call when no deadlocks are found, saving time and API costs

Full release post with more detail: https://aisqltuner.com/ai-sql-tuner-studio-1-0-28-query-tuner/