SQL DBA Blog: Home

  • TERMINATE_LISTENER Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: ASYNC_NETWORK_IO Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? No. It marks a network listener being torn down, an infrequent event; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so…

    Read More

  • THREADPOOL Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Performance & Troubleshooting THREADPOOL is one of the most serious wait types in SQL Server. It means all worker threads are occupied and incoming requests cannot get a thread to execute on. Those requests do not run slowly, they do not run…

    Read More

  • TRACE_EVTNOTIF Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: ASYNC_NETWORK_IO Wait TypeRelated pillar: Performance & Troubleshooting Is It a Problem? Not by itself; it was zero on our SQL Server 2025 lab, which has no event notifications. Get Wait Statistics does not filter it out, so if it ranks, you…

    Read More

  • TRACEWRITE Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: ASYNC_NETWORK_IO Wait TypeRelated pillar: Performance & Troubleshooting ⚡TRACEWRITE is the SQL Trace rowset provider, the one Profiler uses, waiting for trace buffers. It grows when events are produced faster than the client reads them. Run the check to list running traces…

    Read More

  • UCS_SESSION_REGISTRATION 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 not a known contention point; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks, you…

    Read More

  • VDI_CLIENT_OTHER 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? No. It can be safely ignored. Get Wait Statistics does not filter it out, so if it ranks, you will see it. It was zero on our SQL Server 2025…

    Read More

  • WAIT_ON_SYNC_STATISTICS_REFRESH 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 ⚡WAIT_ON_SYNC_STATISTICS_REFRESH is a query stopped before it can compile, waiting for an automatic statistics update to finish. It explains the query that is normally instant but sometimes hangs for a while. Run the check…

    Read More

  • WAIT_XTP_CKPT_CLOSE 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? Usually not. It is not reported as a contention point, and it is commonly filtered as benign. Get Wait Statistics does not filter it out, so on a server with…

    Read More

  • WAIT_XTP_HOST_WAIT 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 not reported as a contention point, it is commonly filtered as benign, and Get Wait Statistics filters it out by default. What It Means Microsoft describes WAIT_XTP_HOST_WAIT…

    Read More

  • WAIT_XTP_OFFLINE_CKPT_LOG_IO 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? Not usually. It is not reported as a contention point, and it is zero on servers without memory-optimized tables, as on our SQL Server 2025 lab. Get Wait Statistics does…

    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