Finding and Fixing Orphaned Users with AI
Find orphaned database users with AI SID mismatches, dropped logins, contained DB users, and Azure SQL differences.
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.
Deadlock Graph Analysis with AI
Feed deadlock XML to AI for human-readable analysis with victim identification and fix recommendations.
CXPACKET and CXCONSUMER Waits: AI-Assisted Diagnosis
Use AI to diagnose CXPACKET/CXCONSUMER waits, tune MAXDOP, and avoid setting MAXDOP=1 globally.
Eliminating Legacy Cursors: An AI-Assisted Deep Dive
A deep dive into decomposing complex legacy cursors with AI using the bulk-first, loop-for-side-effects pattern.