SQL DBA Blog: Home

  • SOS_PHYS_PAGE_CACHE 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? Under normal conditions, no; allocations pass through quickly and the wait stays in the noise. Get Wait Statistics does not filter it out, so if it ranks, you will see…

    Read More

  • SOS_SCHEDULER_YIELD Wait Type in SQL Server

    ⏳Part of the SQL Server Wait Types Library, every wait type explained.Related pillar: Performance & Troubleshooting SQL Server uses a cooperative scheduling model. Rather than relying on the OS to preempt threads, SQL Server threads voluntarily yield the CPU at natural checkpoints after roughly 4ms of execution. When a thread yields, it moves to the…

    Read More

  • SOS_SYNC_TASK_ENQUEUE_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? No. It is not reported as a contention point; our SQL Server 2025 lab had 4 waits in a day. Get Wait Statistics does not filter it out, so if…

    Read More

  • SOS_WORK_DISPATCHER 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 will usually be the top wait on Azure SQL Database and SQL Server 2019 and can be safely ignored, and Get Wait Statistics filters it out by default.…

    Read More

  • SOS_WORKER_MIGRATION 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, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks,…

    Read More

  • SP_SERVER_DIAGNOSTICS_SLEEP 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 can be safely ignored, and Get Wait Statistics filters it out by default. What It Means Microsoft lists it as internal use only, from SQL Server 2012. It…

    Read More

  • SQLCLR_APPDOMAIN 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? Occasional waits after a restart or first use are the design. It is not a known contention point, and it was zero on our SQL Server 2025 lab. Get Wait…

    Read More

  • SQLCLR_ASSEMBLY 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? Rarely. It is not a known contention point, and it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks,…

    Read More

  • SQLTRACE File Wait Types 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 Four waits cover SQL Trace writing to and reading from trace files, and this page takes them together: SQLTRACE_FILE_BUFFER: synchronization on trace buffers during a file trace, meaning a wait for exclusive access to…

    Read More

  • SQLTRACE_INCREMENTAL_FLUSH_SLEEP 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 timer, commonly filtered as benign, and Get Wait Statistics filters it out by default. Its total follows uptime, not tracing cost. What It Means Microsoft lists…

    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