Xp_delete_file and Preemptive_Os_GetProcAddress waits
If you are noticing a number of waits showing up on your SQL Server of type PREEMPTIVE_OS_GETPROCADDRESS and it is linked to the system procedure xp_delete_file the you may want to look at your backup cleanup jobs. Lets take a look at what you may actually be seeing – see image above What is shown in the image above is …
Xp_delete_file and Preemptive_Os_GetProcAddress waits Read more »