Building Custom Monitoring Queries and Alerts
Build custom SQL Server monitoring queries and alerts with AI long-running transactions, blocking chains, backup failures, and intelligent thresholds.
AI-Native Monitoring: PerformanceMonitor, PerformanceStudio, and the MCP Revolution
Erik Darling’s PerformanceMonitor and PerformanceStudio bring MCP integration to SQL Server monitoring letting AI query your performance data directly.
Migration Planning: Compatibility Checks and Deprecated Features
Plan SQL Server version upgrades with AI deprecated feature scans, compatibility level analysis, breaking change detection, and migration runbooks.
Security Audits: Finding What You Missed
AI-assisted security audits for SQL Server finding orphaned users, permission sprawl, unencrypted connections, and compliance gaps across your fleet.
Incident Response: Root Cause Analysis with an AI Partner
Walk through a realistic production incident with an AI partner from initial triage through root cause analysis to post-mortem documentation.
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.