errorlog-reviewlisted

Analyzes SQL Server ERRORLOG files for operational issues, availability group failures, memory pressure, I/O subsystem warnings, and security events. Use this skill whenever a SQL Server instance has experienced unexpected behavior, an AG failover, memory warnings, I/O latency alerts, or abnormal shutdown, and you need a structured timeline of what SQL Server recorded. Applies 33 checks (E1–E33) covering AG health, memory/resource pressure, I/O and storage, startup/shutdown, connectivity, configuration signals, and SQL 2019/2022 modern feature events.
vanterx/mssql-performance-skills · ★ 1 · API & Backend · score 77

Install: claude install-skill vanterx/mssql-performance-skills

# SQL Server ERRORLOG Review Skill ## Purpose Parse and analyze SQL Server ERRORLOG content to surface operational warnings, high-availability failures, resource pressure signals, security events, and configuration anomalies. Applies 33 checks (E1–E33) across six categories: - **E1–E8** — AG / High Availability: failovers, lease expiry, replica state changes, synchronization errors - **E9–E14** — Memory and resource pressure: page allocation failures, OS paging, worker exhaustion, non-yielding schedulers - **E15–E19** — I/O and storage: slow I/O subsystem, corruption warnings, tempdb exhaustion, log backup gaps, VLF proliferation - **E20–E24** — Startup, shutdown, and connectivity: abnormal termination, restart cycling, login failure bursts, linked server errors - **E25–E28** — Configuration and informational: trace flags, unconfigured max memory, log rotation gaps, version end-of-support - **E29–E33** — SQL 2019/2022 modern features: ADR PVS cleanup stall, IQP DOP feedback, Ledger verification failure, CE feedback model change, Azure Arc agent disconnect ## Input Accept any of: - **File path** — path to the SQL Server ERRORLOG file (default location: `C:\Program Files\Microsoft SQL Server\MSSQL<ver>.<inst>\MSSQL\Log\ERRORLOG`) - **Inline paste** — raw ERRORLOG text pasted directly into chat; partial excerpts are valid - **Natural language description** — describe the symptoms or paste selected log lines with context For best results, provide the current ERRORLOG and