SQL DBA Blog: Home

⏳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 was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks, you will see it. The exception is…

Read More

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: CXPACKET and CXCONSUMER Wait TypesRelated pillar: Performance & Troubleshooting Is It a Problem? No. It is not a known contention point; our SQL Server 2025 lab had about 3,300 waits totalling 2 seconds in a day. Get Wait Statistics does not…

Read More

⏳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? It is a live signal more than a statistic. Its total is trivia; its presence during a shutdown that is dragging tells you a session is still running and the…

Read More

⏳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? Normally no. It is one of the standard benign waits, and Get Wait Statistics filters it out by default. The checkpoint writes themselves are recorded as ASYNC_IO_COMPLETION, so this wait…

Read More

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: PAGEIOLATCH_SH Wait TypeRelated pillar: Performance & Troubleshooting Three sleep waits share one theme, no free memory right now, so pause and try again, and this page covers them together: SLEEP_BPOOL_STEAL: not listed in sys.dm_os_wait_stats at all, so Microsoft documents nothing about…

Read More

⏳Part of the SQL Server Wait Types Library, every wait type explained.Related deep dive: WRITELOG Wait TypeRelated pillar: Performance & Troubleshooting Several sleep waits mark phases of instance startup, and this page covers the three most often asked about: SLEEP_DBSTARTUP: Microsoft describes it as occurring during database startup while waiting for all databases to recover.…

Read More

⏳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 a known contention point, and our SQL Server 2025 lab had a single wait in a day. Get Wait Statistics does not filter it out, so…

Read More

⏳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 a known contention point; our SQL Server 2025 lab had a single wait, at startup. Get Wait Statistics does not filter it out, so if it…

Read More

⏳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, and it stays tiny on normal systems; our SQL Server 2025 lab had two waits totalling under a millisecond. Get Wait…

Read More

⏳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? Usually not; it was zero on our SQL Server 2025 lab. Get Wait Statistics does not filter it out, so if it ranks, you will see it. It has two…

Read More