Tag: Error Log
-
DBA Scripts: Get Recent Error Log Entries
Part of the DBA-Tools Project. 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 by routine noise, every successful backup, every log backup, every…
Written by
-
DBA Scripts: Get Schema Change History
Part of the DBA-Tools Project. “What Changed on This Server Recently?” That question comes up after almost every unexpected behavior change: a query that used to work now errors, a report that used to return data now doesn’t, a job that used to succeed now fails. Before chasing the symptom, it’s worth answering the more…
Written by
Blog Categories
- Backups & Recovery (7)
- DBA Scripts (97)
- High Availability (HA) (7)
- Installation & Configuration (14)
- Maintenance (4)
- Monitoring (14)
- Performance Tuning (11)
- Security (Encryption & Permissions) (6)
- T-SQL Fundamentals (11)
- Troubleshooting (10)
- Wait Types (201)
Latest Posts
- DBA Scripts: Generate Maintenance Jobs
- DBA Scripts: Get Job Schedules and Duration Trends
- How to Shrink SQL Server Database Files in Chunks
- DBA Scripts: Get Lock Escalation, Contention Analysis, and Blocking Chains with Plan
- DBA Scripts: Get Trace Flags and Resource Governor Configuration
- DBA Scripts: Get CPU Topology and OS Configuration Checks
Blog Tags
Access (3) Always On Availability Groups (4) Auditing (7) Backups (4) Blocking Locking (6) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (28) Disk Space (5) Error Log (2) Extended Events (7) Features (6) High Availability (6) Indexes (5) Instance (3) Inventory (6) Jobs (3) Migration (6) Monitoring (24) Performance (19) Performance Troubleshooting (9) PowerShell (4) Queries (3) Query Behaviour (5) Security (7) SQL Agent (3) SQL Scripts (21) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (9) SQL Server Versions (2) Storage and Capacity (9) T-SQL (9) Temp DB (3) Tracing (7) Transaction Logs (5) Troubleshooting (14) Windows Server (4)