sp_QuickieStore: add sys.database_automatic_tuning_configurations support#686
Merged
erikdarlingdata merged 3 commits intodevfrom Mar 2, 2026
Merged
sp_QuickieStore: add sys.database_automatic_tuning_configurations support#686erikdarlingdata merged 3 commits intodevfrom
erikdarlingdata merged 3 commits intodevfrom
Conversation
Issue #661: Add sys.database_automatic_tuning_configurations to sp_QuickieStore expert mode 4 changes to sp_QuickieStore.sql: 1. Temp table (line ~1483): #database_automatic_tuning_configurations with correct data types (notably sql_variant column type_value is stored as nvarchar(120) with explicit CONVERT, and state is integer — the Microsoft docs were wrong about the types) 2. Data population (line ~8552): Inside IF @sql_2022_views = 1, queries sys.database_automatic_tuning_configurations with no WHERE filter (database-level config, not per-query) 3. Expert mode output (line ~9364): Shows the result set when @expert_mode = 1 and data exists. Silently skips when empty (empty is normal) 4. Debug output (line ~11715): Standard debug pattern with "is empty" message Tested and working on both sql2022 (16.0.4222) and sql2025 (17.0.4015) — the initial sp_configure_automatic_tuning failure on sql2022 was bad parameter syntax, not a version limitation. The feature works identically on both versions.
…atic_tuning_configurations.
Avoids implicit nvarchar-to-bigint conversion; TRY_CAST works at all compat levels unlike TRY_CONVERT which requires >= 130. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
Summary
sys.database_automatic_tuning_configurations(issue sp_QuickieStore: expert mode should know about sys.database_automatic_tuning_configurations/sp_configure_automatic_tuning #661)Closes #661
🤖 Generated with Claude Code