Using AI for Performance Tuning in SQL 2025

When performance problems strike, DBAs and developers are under pressure to find answers quickly. In SQL Server 2025 AI tools can now assist by analysing code, execution plans, and performance metrics in seconds.

This session demonstrates how to use AI to troubleshoot common SQL Server performance issues, including inefficient queries, missing or misused indexes, and sub-optimal query patterns. We’ll walk through real examples, showing how AI recommendations compare to traditional tuning techniques and how to combine both approaches for better results.

You’ll gain practical guidance on using AI responsibly, understanding its output, and avoiding common pitfalls while tuning mission-critical workloads.

Identify performance bottlenecks in T-SQL more quickly by using AI Apply AI-generated tuning recommendations effectively Integrate AI into an existing performance-tuning workflow