troubleshoot-microsoft-sql-server

What problem does it solve?

Troubleshooting Microsoft SQL Server incidents that present as log full events, memory pressure spirals, worker thread exhaustion, TempDB contention, or blocking cascades by guiding a structured diagnostic workflow using Netdata health signals.

Core Features & Use Cases

• Operator playbook triage flow via MCP: Routes an AI coding agent through a diagnostic tree using MCP queries against the same signals the Netdata operator playbook relies on.
• Focused failure archetype diagnosis: Targets the dominant SQL Server failure modes (log/disk full, memory pressure spiral, worker exhaustion, TempDB contention, blocking cascade, and parameter sniffing).
• Verification with load-bearing contexts: Re-runs MCP queries and validates that key mssql.* chart contexts return to expected ranges after remediation.
• Use Case: An on-call engineer is paged due to elevated errors and latency on a SQL Server instance; this skill guides signal collection, anomaly ranking, root-cause narrowing, and remediation verification.

Quick Start

Ask the AI to troubleshoot Microsoft SQL Server using Netdata MCP by running the verification queries for the relevant mssql.* contexts and then recommending remediation based on the matching failure pattern.