Skip to content

v2.3 — SME Persona Synthesis

Choose a tag to compare

View all tags
@nanoDBA nanoDBA released this 28 Feb 22:47
· 160 commits to main since this release
v2.3
0f7a293

What's New in v2.3 (2.3.2026.0226)

18 improvements across three effort tiers, derived from a systematic SQL Server SME persona synthesis review.

Trivial

  • MAXRECURSION 1000 on recursive CTEs
  • Sub-second duration display in progress output
  • dm_exec_sessions fix for session context accuracy
  • ROWLOCK+READPAST on QueueStatistic queries
  • MAX_GRANT_PERCENT=25 hint added
  • TOCTOU message clarity improvements
  • Hardware context extension in debug output
  • JSON summary in ExtendedInfo END block

Low Effort

  • @QueryStoreMetric now accepts AVG_CPU
  • @HoursStaleThreshold parameter
  • @StopByTime parameter — hard wall-clock stop
  • @SkipTablesWithColumnstore parameter
  • Phase transition logging improvements
  • CommandLog schema compatibility check
  • @Help topic: SAMPLING

Medium Effort

  • Stat-level LastStatCompletedAt timestamp in output
  • Parameter fingerprint validation
  • @CheckPermissionsOnly mode — pre-flight permission audit without execution

Previous releases: v2.2 (adversarial code review, 13 bug fixes) · v2.1 (Phase 2 Extended Awareness)

Assets 2
Loading