Memory Grant Analysis with AI
Find queries with excessive memory grants, tempdb spills, and RESOURCE_SEMAPHORE waits using AI analysis.
Blocking Chain Triage with AI
Analyze blocking chains with AI to identify head blockers and get actionable resolution steps.
CXPACKET and CXCONSUMER Waits: AI-Assisted Diagnosis
Use AI to diagnose CXPACKET/CXCONSUMER waits, tune MAXDOP, and avoid setting MAXDOP=1 globally.
Compatibility Level Audit: Finding Databases Stuck in the Past
Audit database compatibility levels with AI and find databases missing intelligent query processing improvements.
Diagnosing Parameter Sniffing with AI
Use AI to analyze execution plan XML, identify sniffed values, and evaluate RECOMPILE, OPTIMIZE FOR, and PSP optimization.
Eliminating Cursors with AI-Generated Set-Based Alternatives
Feed a cursor-based procedure to AI and get a set-based rewrite with honest advice about when cursors are still right.