Tag: Error Log

  • DBA Scripts: Get Error Log Patterns

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting Group the Error Log Instead of Scrolling It The SQL Server error log is where the instance tells you what’s wrong, but on a busy server it’s also where hundreds of routine startup, backup, and checkpoint messages bury the handful…

    Written by

    Peter Whyte

  • DBA Scripts: Get Recent Error Log Entries

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting The SQL Server error log records almost everything worth knowing about an instance’s recent health, and almost nobody reads it until they’re already troubleshooting something. It’s not that the information isn’t there, it’s that xp_readerrorlog returns thousands of lines dominated…

    Written by

    Peter Whyte

  • DBA Scripts: Get Schema Change History

    ,

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration “What Changed on This Server Recently?” A query that worked yesterday now errors, a report comes back empty, a job that always succeeded fails, and everyone says nothing changed. Before chasing the symptom, answer the basic question directly: did anything…

    Written by

    Peter Whyte
Major pillars
DBA ScriptsEvery script, one page each SSMS Complete GuideInstall, shortcuts, git, Copilot, dark mode Error LibraryLook up an exact message, cause and fix Wait Types LibraryWhat the server was waiting on Site MapHow the pillars, areas and scripts connect
Quick scripts
Get-ActiveSessions Get-UserPermissionsAudit Get-DiskSpace Get-DatabaseFreeSpaceSummary Get-IndexFragmentation Get-AvailabilityGroupLatency Get-BackupCoverage Get-BackupRestoreProgress
Patch week
SQL Server BuildsLatest CU per version, with support dates Patch LevelWhat your server is running
Health check & AI
Full Health CheckCollect 45 diagnostics, apply rules, then an AI assessment sqldba MCP ServerGive an AI assistant a verified SQL Server reference
Script areas
Server & Configuration Storage & Capacity Backup & Recovery High Availability Performance & Troubleshooting Security Maintenance & Automation Migration & Deployment
Latest posts
Browse by topic