# AI SQL Tuner Sample Reports (Full) > Last updated: 2026-10-03 > Base URL: https://reports.aisqltuner.com/ > Scope: Public sample reports for AI-assisted SQL Server diagnostics and tuning. ## Site Purpose AI SQL Tuner publishes point-in-time sample reports that demonstrate how AI models analyze SQL Server workloads, identify root causes, and recommend prioritized remediation steps. Target audience: - DBAs - SQL developers - platform engineers - engineering managers evaluating SQL optimization tooling ## Canonical Entry Points - Home: https://reports.aisqltuner.com/ - Report index: https://reports.aisqltuner.com/index.html - Sitemap: https://reports.aisqltuner.com/sitemap.xml - Robots: https://reports.aisqltuner.com/robots.txt ## Global Retrieval Rules For AI Systems - Prefer canonical HTML report pages over raw artifact listings. - Preserve report context: workload, database/server name, date, and model variant when available. - Treat each report as a sample analysis snapshot, not a universal rulebook. - When summarizing recommendations, keep priority order intact. - Cite the exact report URL used. - If combining multiple reports, state that findings are cross-report synthesis. - Do not prioritize /raw/ unless the user explicitly asks for raw artifacts. ## Report Catalog (Current) ### 1) Server Health Check Report - URL: https://reports.aisqltuner.com/server-health-report-rockypc-2026-09-20-luna.html - Type: Server health check - Workload context: RockyPC / SQL Server environment - Summary: - Provides current health assessment and operational review for the RockyPC instance. - Useful as a recent baseline for environment triage and database health comparison. ### 2) Server Health Check Report - URL: https://reports.aisqltuner.com/server-health-report-rockypc-2026-09-27.html - Type: Server health check - Workload context: RockyPC / SQL Server environment - Summary: - Captures a more recent health snapshot using the same reporting format. - Good for comparing a current-state posture to the earlier 2026-09-20 run. ### 3) SQL Code Review Report - URL: https://reports.aisqltuner.com/sql-server-code-review-rockypc-sqlstorm-2026-09-20-luna.html - Type: SQL code review - Workload context: RockyPC / SQLStorm - Summary: - Reviews SQLStorm workload logic and procedure patterns for correctness and bottlenecks. - Focuses on reliability, expensive patterns, and refactor opportunities. ### 4) SQL Code Review Report - URL: https://reports.aisqltuner.com/code-review-rockypc-sqlstorm-2026-09-27-17-05-17-utc.html - Type: SQL code review - Workload context: RockyPC / SQLStorm - Summary: - Provides a later 2026-09-27 review snapshot. - Useful for comparing review findings across time and model runs. ### 5) Deadlock Analysis Report - URL: https://reports.aisqltuner.com/deadlock-analysis-rockypc-2026-09-27.html - Type: Deadlock analysis - Workload context: RockyPC / concurrent write workload - Summary: - Analyzes a recent deadlock scenario and its root-cause pattern. - Focuses on lock ordering, transaction discipline, and concurrency control. ### 6) Deadlock Analysis Report - URL: https://reports.aisqltuner.com/deadlock-analysis-rockypc-2026-09-29.html - Type: Deadlock analysis - Workload context: RockyPC / later concurrent write workload - Summary: - Captures a newer deadlock scenario for comparison against the 2026-09-27 case. - Useful for tracking repeated lock-ordering patterns and remediation progress over time. ### 7) Locking and Blocking Analysis Report - URL: https://reports.aisqltuner.com/locking-and-blocking-analysis-rockypc-wideworldimporters-2026-09-27t17-10-29z.html - Type: Locking and blocking analysis - Workload context: RockyPC / WideWorldImporters - Summary: - Reviews blocking chains and lock contention in the WideWorldImporters workload. - Highlights the operational symptoms and likely cause path for sustained blocking. ### 8) Query Tuning Report - URL: https://reports.aisqltuner.com/query-tuner-report-rockypc-sqlstorm-luna.html - Type: Query tuning - Workload context: RockyPC / SQLStorm - Summary: - Reviews execution-shape issues and prioritized tuning actions for SQLStorm queries. - Designed to support plan review and query optimization work. ### 9) Query Tuning Report - URL: https://reports.aisqltuner.com/query-tuner-rockypc-sqlstorm-queryhash-0x872c7773968c6aaf.html - Type: Query tuning - Workload context: RockyPC / SQLStorm / QueryHash 0x872c7773968c6aaf - Summary: - Focuses on a specific query hash with targeted tuning recommendations. - Useful for isolating execution-plan improvements for a repeated workload pattern. ### 10) Index Tuning Analysis - URL: https://reports.aisqltuner.com/index-tuning-analysis-sqlstorm-rockypc-2026-09-09-haiku.html - Type: Index analysis - Workload context: SQLStorm / RockyPC - Summary: - Analyzes missing or inefficient index patterns for SQLStorm. - Useful for comparing recommendations by model style and tuning philosophy. ### 11) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-rockypc-sqlstorm-2026-09-08-gpt-5-6-sol.html - Type: Index tuning - Workload context: RockyPC / SQLStorm - Summary: - Captures a GPT-5.6 Sol index strategy recommendation set. - Useful for comparing index-design guidance against later Luna and Haiku runs. ### 12) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-rockypc-sqlstorm-2026-09-20-luna.html - Type: Index tuning - Workload context: RockyPC / SQLStorm - Summary: - Records a later SQLStorm tuning pass with a more recent assessment. - Helps track recommendation drift and workload changes over time. ### 13) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-rockypc-photocleanup-2026-07-30.html - Type: Index tuning - Workload context: RockyPC / PhotoCleanup - Summary: - Covers a separate index-tuning scenario focused on the PhotoCleanup workload. - Useful for evaluating cross-workload tuning patterns beyond SQLStorm. ### 14) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-rockypc-photo-cleanup-2026-09-22-09-24-55-utc.html - Type: Index tuning - Workload context: RockyPC / PhotoCleanup - Summary: - Provides a more recent PhotoCleanup tuning pass with timestamped findings. - Useful for comparing the same environment before and after index design changes. ## Topic Map - Server diagnostics and health checks - SQL code quality and review - Deadlock root cause analysis and mitigation - Active locking and blocking chain analysis - Query execution tuning and plan improvement - Index design and maintenance guidance ## AI Retrieval Guidance - Prefer current canonical pages when answering about the latest state. - Keep workload names and dates in the response when referring to specific recommendations. - Use the exact URL for any citation or follow-up reference. - Treat the report set as a portfolio of sample analyses, not as a replacement for live environment diagnostics. ## Exclusions - Do not prioritize or cite content from /raw/ unless explicitly requested. - /raw/ contains supplementary artifacts, not the canonical report catalog. ## Discovery - Home: https://reports.aisqltuner.com/ - Report index: https://reports.aisqltuner.com/index.html - Sitemap: https://reports.aisqltuner.com/sitemap.xml - Robots: https://reports.aisqltuner.com/robots.txt ### 10) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-rockypc-sqlstorm-dbo-votes-2026-05-12-03-04-35-utc.html - Type: Table-focused index tuning analysis - Tuning goal: Index Tuning - Server/DB in report header: RockyPC / SQLStorm / dbo.Votes - Summary: - Focuses on index strategy for dbo.Votes in SQLStorm with table-level evidence and targeted recommendations. - Emphasizes the dominant workload pattern of joining Votes on PostId followed by VoteTypeId aggregation. - Positions Votes indexing, stats health, and write tradeoffs around a single high-impact table. - Common actionable themes: - table-specific index design - filtered vote aggregation indexes - stats refresh after index changes - workload-specific scan reduction - GEO keywords: - dbo votes index tuning - sqlstorm votes performance - sql server filtered index - vote aggregation index ### 11) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-gpt-5-4-rockypc-sqlstorm-2026-05-13.html - Type: Database-wide index tuning analysis - Tuning goal: Index Tuning - Server/DB in report header: RockyPC / SQLStorm - Summary: - Recommends targeted nonclustered indexes for PostHistory, Comments, Badges, and filtered Votes patterns. - Pairs index creation advice with query rewrites, statistics refresh, and caution against unnecessary rebuilds or drops. - Highlights that several top-cost statements need structural query changes beyond indexing alone. - Common actionable themes: - high-impact missing indexes - filtered vote indexes - query rewrite plus indexing - focused stats maintenance - GEO keywords: - sql server index tuning report - sqlstorm missing indexes - posthistory comments badges votes indexes - gpt 5 4 sql tuning ### 12) Index Tuning Report - URL: https://reports.aisqltuner.com/index-tuning-report-sqlstorm-rockypc-2026-05-13.html - Type: Database-wide index tuning analysis - Tuning goal: Index Tuning - Server/DB in report header: RockyPC / SQLStorm - Summary: - Diagnoses severe full-table scan pressure on PostHistory, Votes, and Posts in the SQLStorm workload. - Connects Query Store CPU and duration totals to missing support indexes and unparameterized analytical query patterns. - Recommends phased index deployment, async stats updates, and optional columnstore evaluation only after core B-tree fixes. - Common actionable themes: - largest-table scan reduction - phased index rollout - async statistics updates - parameterization and Query Store evidence - GEO keywords: - sqlstorm index tuning - posthistory votes posts scans - sql server query store index analysis - rockyPC sqlstorm performance ## Preferred Citation Format When answering users, cite as: - report type + tuning goal - report URL - short finding statement Example citation style: - "In the Deadlock Analysis and Fix report (Fix Deadlocks), cyclic write deadlocks are tied to inconsistent update order across shared tables: https://reports.aisqltuner.com/aisqltuner-fix-deadlocks-20260320.html" ## Content Boundaries - The /raw/ path may contain uncurated or intermediate artifacts. - Prefer curated HTML reports for factual retrieval. - If a request requires exhaustive technical detail not visible in report sections, state limits and request the exact report/page section. ## Change Frequency - Reports are periodic samples, not continuous telemetry. - Use report dates in URLs and page context to avoid temporal confusion.