May 3, 2012 at 3:36 am
Hi,
In the past week we've twice had a log shipping restore job hang with a wait type of PREEMPTIVE_OS_GETPROCADDRESS.
We're using SQL Backup so I've raised the issue on the Red Gate support forums. My question here is, what does this wait type actually mean? I can't find it listed in BOL, and an internet search returned very little, other than a few people having issues with third party backup tools.
If anybody can shed any light on what this wait type means that would be greatly appreciated.
Thanks.
May 3, 2012 at 4:58 am
Hi Matt,
You're right! There isn't a lot but I did come across this from Microsoft...
Hope that helps.
Best regards
Robin
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
May 3, 2012 at 5:40 am
Take a look at Amit Banerjee's write-up on that wait type[/url]. It might be a less than optimal measure due to how it accumulates artificially.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 3, 2012 at 7:03 am
Thanks for the replies. Interesting reading.
December 22, 2014 at 6:53 am
I just watched a video course by Paul Randall on performance tuning with wait stats (highly recommended course!) and he said that if you remove the PREEMPTIVE_OS_ you are left with the windows api name. so in this case GETPROCADDRESS - a quick google search gives more information on the API. http://msdn.microsoft.com/en-us/library/windows/desktop/ms683212%28v=vs.85%29.aspx
December 24, 2014 at 8:14 pm
One way to reproduce this wait type is documented here:
http://www.quicktechnotes.com/2014/12/25/wait-type-preemptive_os_getprocaddress/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply