SQL DBA Blog: Home

  • CMEMPARTITIONED 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? Rarely. It is not described in any detail anywhere, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it…

    Read More

  • CLR_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? Usually not. It is commonly filtered as benign and is not a known contention point; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter…

    Read More

  • CLR_MANUAL_EVENT 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? Almost never. It is commonly filtered as benign, and Get Wait Statistics filters it out by default. What It Means Microsoft’s definition: a task performing CLR execution, and is waiting…

    Read More

  • DBA Scripts: Get Query Store Top Queries

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting › Query & Performance Tuning Query Store is SQL Server’s built-in flight recorder for query performance: every query’s plan, runtime stats, and history, retained and queryable without any extra tracing setup. Most instances have had it available since SQL Server…

    Read More

  • CLR_AUTO_EVENT 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? Almost never. Microsoft says long waits are typical, and don’t indicate a problem, and Get Wait Statistics filters it out by default. What It Means It is a task performing…

    Read More

  • ASSEMBLY_LOAD and CLR Assembly 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 Four waits cover CLR assemblies loading and CLR tasks starting, and this page covers them together: ASSEMBLY_LOAD: Microsoft describes it as exclusive access to assembly loading. ASSEMBLY_FILTER_HASHTABLE: internal use only, from SQL Server 2016;…

    Read More

  • CHKPT 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 Is It a Problem? No. Expect one occurrence per startup; our SQL Server 2025 lab showed exactly one, of about 7.6 seconds. Get Wait Statistics does not filter it out, so if it ranks,…

    Read More

  • CHECKPOINT_QUEUE 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 Is It a Problem? No. It is a textbook benign wait, and Get Wait Statistics filters it out by default. What It Means Microsoft’s definition: it occurs while the checkpoint task is waiting for…

    Read More

  • CHECK_TABLES_THREAD_BARRIER 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? Usually not. It is a benign wait that always occurs for a parallel DBCC operation. Get Wait Statistics does not filter it out, so if it ranks, you will see…

    Read More

  • CHECK_TABLES_INITIALIZATION 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 not a known contention point; it is a brief blip at the start of each parallel check, and it was zero on our SQL Server 2025 lab.…

    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