Press "Enter" to skip to content

Analyzing PREEMPTIVE_OS_GETPROCADDRESS Waits

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.