sqlserver-query-optimization

What problem does it solve?

This Skill addresses slow-performing SQL Server queries by providing a systematic approach to analyze execution plans, identify missing indexes, resolve parameter sniffing issues, and detect implicit type conversions, ultimately improving database responsiveness and reducing resource consumption.

Core Features & Use Cases

• Query Analysis: Reads execution plans to pinpoint performance bottlenecks like table scans, key lookups, and inefficient joins.
• Index Optimization: Identifies and suggests missing indexes based on query patterns and provides guidance on creating effective indexes.
• Parameter Sniffing Fixes: Detects and offers solutions for parameter sniffing problems that lead to suboptimal query plans.
• Implicit Conversion Resolution: Finds and helps fix data type mismatches that prevent index seeks.
• Regression Detection: Leverages Query Store to identify and revert performance regressions.
• Use Case: An application reports slow response times for a critical report. This Skill can analyze the underlying SQL query, identify that a missing index is causing a full table scan, and provide the exact CREATE INDEX statement to resolve the issue.

Quick Start

Analyze the performance of the stored procedure 'usp_MonthlyReport' by examining its execution plan and identifying potential optimizations.