Summary

• Default trace collector: Added ErrorLog, Object DDL, and Security Audit event types. Added duration_us and end_time columns for autogrow I/O stall tracking. Filter autogrow events to > 1s duration only. Exclude tempdb Object DDL and auto-stats (_WA_%) noise.
• Removed Trace Analysis tab: Redundant with the improved Query Trace Patterns tab under Queries.
• Memory clerks picker: Added type picker with search, top-N selection, and clear-all to Dashboard (parity with Lite).
• Memory grants fix: Removed granted_memory_mb > 0 filter in both Dashboard and Lite that hid chart data when no active grants existed.
• Query Trace Patterns plans: Wired up Get Actual Plan using full SampleQueryText (removed artificial 500-char truncation). View Estimated Plan shows redirect message.
• Upgrade script: Added 03_default_trace_schema.sql to 1.3.0-to-2.0.0 upgrade path.

Test plan

• Built Dashboard with zero errors/warnings
• Deployed collector to sql2022, verified event filtering (tempdb excluded, auto-stats excluded, autogrow > 1s threshold)
• Verified Default Trace tab shows clean data with Duration (ms) and Growth (MB) columns
• Verified memory clerks picker works with top-5 default selection
• Verified Get Actual Plan works on Query Trace Patterns rows
• Upgrade script tested on sql2022 (idempotent column adds)

🤖 Generated with Claude Code