SQL DBA Blog: Home

  • WAIT_XTP_RECOVERY 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? The wait is honest; its duration is the operational fact. It is not a known contention point, but warns that the database is not available until the thread waiting on…

    Read More

  • WAIT_XTP_TASK_SHUTDOWN 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 a known contention point; our SQL Server 2025 lab had 2 waits totalling 2 ms. Get Wait Statistics does not filter it out, so if it…

    Read More

  • WAITFOR_PER_QUEUE 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 a normal wait in any environment using Service Broker activation procedures, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter…

    Read More

  • WRITE_COMPLETION Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: IO_COMPLETIONRelated pillar: Performance & Troubleshooting ⚡WRITE_COMPLETION is a thread waiting for a synchronous write, and the most common cause is writing pages into a database snapshot, including the hidden one DBCC CHECKDB creates. Its timing usually gives the cause away. Run…

    Read More

  • WRITELOG Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Storage & Capacity Every committed transaction in SQL Server must wait for its log records to be written to disk before the commit is acknowledged. WRITELOG is the wait for that write to complete. It is present on every transactional system, the…

    Read More

  • XE_BUFFERMGR_ALLPROCESSED_EVENT 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 is not reported as a contention point, and Get Wait Statistics filters it out by default. On our SQL Server 2025 lab it had about 1,300 waits and…

    Read More

  • XE_DISPATCHER_WAIT 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. XE_DISPATCHER_WAIT is the idle time of the Extended Events dispatcher threads, and it belongs on the benign filter list next to XE_TIMER_EVENT. A large total means the dispatchers spent…

    Read More

  • XE_FILE_TARGET_TVF 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 is not reported as a contention point, and Get Wait Statistics filters it out by default. Its total is a record of event file reads, by you, by…

    Read More

  • XE_LIVE_TARGET_TVF 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 as a contention point. It is not reported as causing trouble in its own right, and Get Wait Statistics filters it out by default. Its size mostly follows how…

    Read More

  • XE_TIMER_EVENT 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 is a standard benign wait, and Get Wait Statistics filters it out by default. What It Means Microsoft lists it as internal use only. It is a thread…

    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