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.