Press "Enter" to skip to content


Steve Stedman digs into a class of waits:

What is shown in the image above is that historic wait monitoring feature fromĀ Database Health Monitor, and it has been monitoring for a few days and the query with the most waits is xp_delete_file. When we drill down on the details we can see that the wait type is PREEMPTIVE_OS_GETPROCADDRESS.

Read on to see what might cause this and how you can fix it.