Mining the system_health Session You Already Have
The system_health session runs by default and writes .xel files. Read the event file, shred the XML, and mine the diagnostics on disk.
Memory Grant Analysis with AI
Find queries with excessive memory grants, tempdb spills, and RESOURCE_SEMAPHORE waits using AI analysis.
CXPACKET and CXCONSUMER Waits: AI-Assisted Diagnosis
Use AI to diagnose CXPACKET/CXCONSUMER waits, tune MAXDOP, and avoid setting MAXDOP=1 globally.
Wait Stats, Deadlocks, and Blocking Chains: AI-Assisted Diagnosis
Use AI to interpret wait stats, analyze deadlock graphs, and diagnose blocking chains. Turn raw diagnostic data into actionable remediation steps.