SQL DBA Blog: Home

  • BROKER_TRANSMITTER Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: SOS_SCHEDULER_YIELD Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No. Microsoft says high waiting_tasks_count values for it aren’t indications of any performance problem, and Get Wait Statistics filters it out by default. What It Means The Service Broker transmitter…

    Read More

  • BROKER_TRANSMISSION_WORK Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: SOS_SCHEDULER_YIELD Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No observed case says so. It is not a known contention point, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out,…

    Read More

  • BROKER_RECEIVE_WAITFOR Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: SOS_SCHEDULER_YIELD Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Usually not. It is commonly filtered as benign, and Get Wait Statistics filters it out by default. Microsoft’s definition carries one caution, though: the wait can mean a lock contention…

    Read More

  • BROKER_INIT and Service Broker Startup Wait Types in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: SOS_SCHEDULER_YIELD Wait TypeRelated pillar: Performance & Troubleshooting Service Broker has a group of internal waits around startup, shutdown and its endpoints, and this page covers them together. The definitions are Microsoft’s: BROKER_INIT: initializing Service Broker in each active database; it should…

    Read More

  • BROKER_EVENTHANDLER Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: SOS_SCHEDULER_YIELD Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No. It is commonly filtered as benign, and Get Wait Statistics filters it out by default. What It Means Microsoft’s definition: a task waiting in the primary event handler of…

    Read More

  • BPSORT Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: CXPACKET and CXCONSUMER Wait TypesRelated pillar: Performance & Troubleshooting Is It a Problem? Mostly no. On our SQL Server 2025 lab it had about 421,000 waits and 387 seconds in a day, the ordinary sound of batch-mode sorts. Get Wait Statistics…

    Read More

  • BMPALLOCATION Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: CXPACKET and CXCONSUMER Wait TypesRelated pillar: Performance & Troubleshooting Is It a Problem? Almost never at any visible size; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks, you…

    Read More

  • DBA Scripts: Get SQL Agent Job Failure Summary

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › SQL Agent & Jobs Get SQL Agent Job Overview answers “what’s the current state of every job.” This script answers a narrower, more urgent question: “what actually failed recently, and why.” Job history in msdb holds the error message…

    Read More

  • ASYNC_IO_COMPLETION Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: BACKUPIO and BACKUPBUFFERRelated pillar: Storage & Capacity ⚡ASYNC_IO_COMPLETION is SQL Server waiting for large background I/O that does not go through the buffer pool, most often a backup reading data files, a checkpoint, or file creation. It is expected during backup…

    Read More

  • ASYNC_DISKPOOL_LOCK Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: IO_COMPLETION Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Not as contention. It is not a known bottleneck, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it…

    Read More

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