SQL DBA Blog: Home

  • BROKER_TO_FLUSH 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 the Service Broker lazy flusher’s background wait, it is commonly filtered as benign, and Get Wait Statistics filters it out by default. Its total follows uptime, not…

    Read More

  • BROKER_TRANSMISSION_TABLE 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. Microsoft documents it as internal use only and gives no threshold or cause for it. It is one of the Broker waits that Get Wait Statistics deliberately leaves…

    Read More

  • DISKIO_SUSPEND Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: BACKUPIO and BACKUPBUFFER Wait TypesRelated pillar: Storage & Capacity Is It a Problem? The freeze it records is by design, and a short one is barely felt. It becomes an incident when the freeze runs long, because every session that needs…

    Read More

  • DBA Scripts: Get Backup Size Trend

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Backup & Recovery What Your Backup Sizes Are Quietly Telling You The backup drive is filling faster than planned, or a full backup suddenly ran long, and you need to know which database grew and when. This rolls msdb backup history up to…

    Read More

  • DROPTEMP Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? It should be absent or tiny on a healthy system; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it…

    Read More

  • DBA Scripts: Get Last DBCC CHECKDB

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation DBCC CHECKDB is the only thing that actually confirms a database’s data is structurally sound; backups only prove a database can be restored, not that what gets restored is undamaged. Skipping it, or letting it silently stop running, means corruption can…

    Read More

  • FGCB_ADD_REMOVE 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: Storage & Capacity ⚡FGCB_ADD_REMOVE is not a wait type: it is a latch class, and its waits show up as LATCH_EX and LATCH_SH. It protects a filegroup while files are added, dropped, grown or shrunk, so time…

    Read More

  • LATCH_DT Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Almost never. LATCH_DT should be one of the smallest numbers in your wait profile, if it appears at all; it was zero on our SQL Server 2025 lab. Get Wait…

    Read More

  • LATCH_EX Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX, TempDB Allocation ContentionRelated pillar: Performance & Troubleshooting ⚡LATCH_EX is a wait for an exclusive latch on an internal structure that is not a data page, and the wait name does not say which structure. A little is normal on every…

    Read More

  • LATCH_KP Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGELATCH_EX Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Practically never. A LATCH_KP wait means a thread wanted to pin a structure while another thread held it for destruction, which is a narrow window, so expect zero or close…

    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