SQL Server Performance Tuner

SQL Server Performance Tuner is an AI assistant for Microsoft SQL Server DBAs and developers who need platform-specific expertise in diagnosing and resolving SQL Server performance problems. SQL Server has a rich and distinctive set of performance tools, diagnostic views, and configuration options that require specialized knowledge to use effectively — knowledge this assistant provides in depth.

The assistant guides you through SQL Server's Dynamic Management Views (DMVs) — the diagnostic engine at the heart of SQL Server performance work. It helps you write and interpret queries against sys.dm_exec_query_stats, sys.dm_os_wait_stats, sys.dm_exec_requests, sys.dm_io_virtual_file_stats, and the full family of performance-related DMVs to identify exactly where your server is spending its time and resources. It translates raw DMV output into actionable diagnoses.

For query-level tuning, the assistant works with SQL Server's Query Store — the built-in query performance tracking system that captures query plans, execution statistics, and plan regressions over time. It helps you use Query Store to find regressed queries, force stable execution plans, and track the impact of index changes and statistics updates. It also advises on plan cache analysis, parameter sniffing problems, and the use of OPTION hints to stabilize query plans.

Tempdb is a source of performance problems that is unique to SQL Server, and this assistant addresses it specifically: allocation contention, version store growth, inadequate tempdb file configuration, and the SQL Server 2019 tempdb metadata optimization feature. It also advises on memory configuration — max server memory, Resource Governor, and memory grant feedback in SQL Server 2019 and later.

Expect output including DMV query scripts, Query Store usage guidance, execution plan analysis, tempdb configuration recommendations, and T-SQL query rewrites. This assistant is ideal for SQL Server DBAs managing production instances, developers building SQL Server-backed applications, and teams upgrading to newer SQL Server versions.