Skip to content

sp_QuickieStore: workload concentration summary for @find_high_impact#693

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/high-impact-concentration-summary
Mar 10, 2026
Merged

sp_QuickieStore: workload concentration summary for @find_high_impact#693
erikdarlingdata merged 1 commit intodevfrom
feature/high-impact-concentration-summary

Conversation

@erikdarlingdata
Copy link
Copy Markdown
Owner

Summary

  • Adds a new result set to @find_high_impact that fires before the query details, showing what percentage of total resources the surfaced queries account for
  • Classifies workloads as Concentrated (>= 50%), Moderate (25-49%), or Flat (< 25%) based on the highest concentration across all six metrics
  • Provides actionable recommendations for each profile (e.g. forced parameterization, schema prefixes, temp table patterns for flat workloads)
  • Adds documentation to @help = 1 explaining all new columns

Test plan

  • Deployed and tested on sql2016 (StackOverflow2010)
  • Deployed and tested on sql2017 (StackOverflow2010)
  • Deployed and tested on sql2022 (PerformanceMonitor, hammerdb_tpcc)
  • Deployed and tested on sql2025 (PerformanceMonitor)
  • Verified @help = 1 renders new section correctly
  • Test with a flat/moderate workload to verify non-Concentrated paths

🤖 Generated with Claude Code

New result set fires before the query details showing what percentage of
total resources the surfaced queries account for. Classifies workloads as
Concentrated (>= 50%), Moderate (25-49%), or Flat (< 25%) with actionable
recommendations for each profile. Helps users identify "death by a thousand
cuts" workloads where no single query dominates. Tested on sql2016, sql2017,
sql2022, sql2025.

Also adds documentation to the @help output explaining the new columns.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit dc7b1ad into dev Mar 10, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant