Category: DBA Scripts

  • DBA Scripts: Get Error Log Patterns

    Part of the DBA-Tools Project. 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 of lines that actually matter. Scrolling xp_readerrorlog output looking for…

    Written by

    Peter Whyte

  • DBA Scripts: Get Edition Feature Usage

    Part of the DBA-Tools Project. What Actually Breaks If You Downgrade This Instance Edition downgrades, Enterprise to Standard, Standard to Web, look simple until you discover a feature that only Enterprise supports has quietly been in use the whole time. TDE-encrypted databases won’t open on Standard at all. Resource Governor configuration silently stops working. A…

    Written by

    Peter Whyte

  • DBA Scripts: Maintenance and Automation

    Part of the DBA-Tools Project. Is the Automation Healthy, and Is It Actually Doing the Job A SQL Agent job that silently stopped running is one of the quietest failure modes in SQL Server, nothing errors, nothing alerts, the work it used to do just stops happening until someone notices the symptom weeks later. This…

    Written by

    Peter Whyte

  • DBA Scripts: Performance and Troubleshooting

    Part of the DBA-Tools Project. Four Ways of Answering “Why Is It Slow” “The database is slow” is rarely one problem. Sometimes it’s a query, a bad plan, a stale statistic. Sometimes it’s blocking, and the fix is completely different depending on which one it actually is. Sometimes the DMV snapshot has already missed the…

    Written by

    Peter Whyte

  • DBA Scripts: Server and Configuration

    Part of the DBA-Tools Project. What This Server Is, and How It Got That Way Two pillars, one underlying question: before performance, before security, before anything else, what is this SQL Server instance, and how did it come to be configured the way it is. Server Inventory answers the first half, a snapshot of what’s…

    Written by

    Peter Whyte

  • DBA Scripts: Collectors and Baseline Infrastructure

    Part of the DBA-Tools Project, in the Performance and Troubleshooting area. From “Check When Asked” to “Already Watching” Every other pillar on this site answers a question the moment you ask it: what’s blocking right now, what are the current wait stats, how much free space is on disk today. The Collectors pillar is different.…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Collector Alerts

    Part of the DBA-Tools Project. The Job That Reads Every Other Collector and Actually Tells You Something’s Wrong Every collector in this pillar writes evidence somewhere, blocking chains, deadlocks, wait stats, VLF counts, database growth, TempDB pressure. None of them, on their own, tells anyone anything. Generate-CollectorAlertJob.sql is the cross-cutting piece: one recurring job that…

    Written by

    Peter Whyte

  • DBA Scripts: Get Patch Level

    Part of the DBA-Tools Project. Building a Patch Compliance Inventory Across an Estate Version and Edition answers “what is this one instance running” as a quick single-server snapshot. This script answers a related but different question: run it across every server you manage and you get a patch compliance inventory, ready to compare against what’s…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Health and Configuration Baselines

    Part of the DBA-Tools Project. Four Collectors, One Real Table-Design Bug Found Testing Them Four different rhythms: AG health every few minutes if you’re running Availability Groups, index fragmentation weekly, Query Store’s top queries every 30 minutes, error log entries every 10. Testing the AG health collector against a real instance surfaced a genuine table-design…

    Written by

    Peter Whyte

  • DBA Scripts: Get Transaction Log Size and Usage

    Part of theDBA-Tools Project. Understanding Transaction Log Size Usage Keeping an eye on transaction log usage is one of the simplest ways to prevent unexpected database outages. When a transaction log fills, SQL Server cannot continue writing transactions, backups begin failing, applications stop processing writes, and production quickly turns into an incident. Many environments monitor…

    Written by

    Peter Whyte

Key Links

DBA Scripts: The Complete Guide
Query and Performance Tuning
High Availability
Security
Storage and Capacity
Installation and Patching
Backups and Recovery

Blog Categories

Latest Posts

Blog Tags

Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Jobs (3) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) 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 (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)