Author: Peter Whyte
-
BAD_PAGE_PROCESS Wait Type in SQL Server
⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGEIOLATCH_SH Wait TypeRelated pillar: Performance & Troubleshooting BAD_PAGE_PROCESS is recorded by the background suspect page logger, the process that records 823 and 824 I/O errors into msdb.dbo.suspect_pages, as it throttles itself to run no more than once every five seconds. You…
Written by
-
DBA Scripts: Get CPU Topology and OS Configuration Checks
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration What CPU and OS Settings Are Actually Doing to SQL Server OS and Hardware Info tells you what hardware exists. These two scripts go one level deeper: how SQL Server is actually scheduling work across that hardware, and whether a…
Written by
-
BROKER_TASK_STOP 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 BROKER_TASK_STOP is recorded when a Service Broker internal task handler waits (up to ten seconds at a time) to shut itself down because there are no Broker tasks, message transmission, receipt, or other asynchronous…
Written by
-
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 BROKER_TO_FLUSH is recorded by the Service Broker lazy flusher, the background thread that writes inactive transmission objects (the structures tracking message transmissions per dialog) out to a tempdb worktable to save memory. The detail…
Written by
-
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 BROKER_TRANSMISSION_TABLE is recorded when a thread waits on the process of writing inactive transmission objects, the in-memory structures tracking message transmissions per Service Broker dialog, out to a tempdb worktable to save memory. It…
Written by
-
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 DISKIO_SUSPEND occurs when a thread needs to issue I/O against a database whose I/O has been deliberately frozen. External snapshot backup tools (VSS-based agents, SAN and VM snapshot backups) freeze a database’s…
Written by
-
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 Nobody watches backup file sizes month to month, they just watch that the backup succeeded. But backup size is a free, already-collected proxy for data growth rate, and it catches two things…
Written by
-
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 DROPTEMP is recorded between attempts to drop a temporary object after a previous attempt failed, classically because a deadlock occurred while dropping a temp table. The engine backs off and retries, and the wait…
Written by
-
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…
Written by
-
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 a wait on the File Group Control Block, the structure that tracks the files in a filegroup. A thread needs it in exclusive mode whenever the file list changes or a file…
Written by
Start Here
- DBA Scripts: The Complete Guide
- Run a Full Health Check
- DBA Scripts & Tools
- SSMS: The Complete Guide
- SQL Server Errors: The Complete Guide
- Wait Types Library
The Pillars
Blog Categories
- Backups & Recovery (16)
- DBA Scripts (151)
- High Availability (HA) (12)
- Installation & Configuration (38)
- Maintenance (24)
- Migration & Upgrades (14)
- Monitoring (7)
- Performance Tuning (35)
- Security (Encryption & Permissions) (20)
- Storage & Capacity (14)
- T-SQL Fundamentals (11)
- Troubleshooting (55)
- Wait Types (235)
Latest Posts
- Cannot Execute As the Database Principal (Error 15517)
- Silent Failures: The SQL Server Problems That Never Raise an Error
- SQL Server Login Migration: What Gets Silently Left Behind
- CREATE USER WITHOUT LOGIN vs Contained Database Users
- The sqldba MCP Server: Give Your AI Assistant a Verified SQL Server Reference
- Cannot Resolve the Collation Conflict (Error 468)
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) Error Log (3) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Maintenance (6) Migration (14) 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)