SQL DBA Blog: Home

  • DBA Scripts: Get Linked Servers

    Part of the DBA-Tools Project. Four Questions, One Topic: What’s Linked to This Server Linked servers are the kind of configuration that gets set up once, for one integration, and then forgotten until a migration or an incident forces someone to ask what’s actually connected to this instance and how. There are four separate questions…

    read more

  • 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…

    read more

  • 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…

    read more

  • 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…

    read more

  • DBA Scripts: Get OS and Hardware Info

    Part of the DBA-Tools Project. What Is This Server Actually Running On Before you can reason about performance, capacity, or whether a setting makes sense, you need the basics: how much CPU and memory the box actually has, what OS it’s running, and how long SQL Server has been up. It’s a small set of…

    read more

  • DBA Scripts: SQL Agent and Jobs

    Part of the DBA-Tools Project, in the Maintenance and Automation area. A SQL Agent job that silently stopped running is one of the quietest failure modes in SQL Server, nothing errors, nothing alerts, the maintenance work it used to do just stops happening until someone notices the symptom weeks or months later: a fragmented index…

    read more

  • SQL Server Replication Monitoring Scripts

    This is the set I reach for when replication starts acting up. Latency creeping, agents stuck, or subscribers falling behind — these queries cut through the noise fast. I’ve used them in production environments for years. What’s Inside If you run transactional replication, keep these handy. They save time when things go sideways. For the…

    read more

  • SQL Server Wait Types Library

    Wait statistics are the single best first step in any SQL Server performance investigation. Every time a query waits on a resource, whether that’s a lock, disk I/O, a transaction log flush, a memory grant, or something else, SQL Server records it. By the time a performance problem appears, the evidence is usually already sitting…

    read more

  • PARALLEL_REDO_WORKER_SYNC Wait Type in SQL Server

    PARALLEL_REDO_WORKER_SYNC is recorded when the main parallel redo thread on an Availability Group replica waits for its redo worker threads to complete their assigned work. It is the general completion-synchronisation wait of the redo pipeline, the main thread pausing at a rendezvous point while workers finish. It completes the set of parallel redo coordination waits…

    read more

  • PARALLEL_REDO_WORKER_WAIT_WORK Wait Type in SQL Server

    PARALLEL_REDO_WORKER_WAIT_WORK is recorded on an Availability Group secondary when one of the parallel redo worker threads is waiting to be given log records to replay. Most of the time that is because the primary simply is not generating log right now, so the workers idle. It is the opposite condition to PARALLEL_REDO_FLOW_CONTROL: there, workers are…

    read more

Blog Categories

Latest Posts

Blog Tags

Always On Availability Groups (4) Auditing (7) Backups (5) 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) Instance (3) Inventory (6) Jobs (3) Maintenance (6) Migration (13) Monitoring (24) Performance (21) Performance Troubleshooting (9) PowerShell (4) Queries (3) Query Behaviour (5) Security (7) 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 (9) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (14) Windows Server (4)