SQL DBA Blog: Home

  • EE_PMOLOCK Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: RESOURCE_SEMAPHORE Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Not in practice. It is not a known contention point; our SQL Server 2025 lab had about 750 waits totalling under a fifth of a second. Get Wait Statistics does…

    Read More

  • EC 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 Is It a Problem? It depends on the queries reading through it. Without a buffer pool extension configured, expect zero, as on our SQL Server 2025 lab, where the extension is disabled. Get Wait…

    Read More

  • DUMP_LOG_COORDINATOR Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: WRITELOG Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No. It is normal while running fn_dump_dblog to read log records from a backup, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter…

    Read More

  • DPT_ENTRY_LOCK Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: HADR_SYNC_COMMIT Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? It can be, on a readable secondary. The secondary replica redo model write-up lists it among the waits with performance impact, and says it only occurs when a parallel redo…

    Read More

  • DISPATCHER_QUEUE_SEMAPHORE 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 its wait time is expected to increase when the dispatcher is idle, which is most of the time, and Get Wait Statistics filters it out by default.…

    Read More

  • DBA Scripts: Get Table Sizes

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity Walk onto a new SQL Server instance and the first honest question is usually “where’s all the space going.” Not at the database level, sys.master_files answers that in seconds, but at the table level, inside a database that’s grown for…

    Read More

  • DIRTY_PAGE_TABLE_LOCK Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: HADR_SYNC_COMMIT Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? It can be, on a readable secondary under the right mix. The secondary replica redo model write-up lists it among the parallel redo waits that slow things down: read-only queries…

    Read More

  • DIRTY_PAGE_POLL 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? No. It is a background poll, commonly filtered as benign, and Get Wait Statistics filters it out by default. It can rank high in raw output purely from uptime. What…

    Read More

  • DBMIRRORING_CMD Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: HADR_SYNC_COMMIT Wait TypeRelated pillar: High Availability Is It a Problem? Usually not. It is typical background on any mirrored instance and is commonly filtered as benign. Get Wait Statistics does not filter it out, so if it ranks, you will see…

    Read More

  • DBMIRROR_WORKER_QUEUE Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: HADR_SYNC_COMMIT Wait TypeRelated pillar: High Availability Is It a Problem? No. Idle mirroring workers are the healthy state; it is commonly filtered as benign, and Get Wait Statistics filters it out by default. What It Means Microsoft’s definition is short: the…

    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