Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What Is Wait Type PREEMPTIVE_OS_GETPROCADDRESS?


What Is Wait Type PREEMPTIVE_OS_GETPROCADDRESS?

Author
Message
DBA Matt
DBA Matt
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 290
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.
Robin Sasson
Robin Sasson
Right there with Babe
Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)Right there with Babe (769 reputation)

Group: General Forum Members
Points: 769 Visits: 530
Hi Matt,

You're right! There isn't a lot but I did come across this from Microsoft...


http://blogs.msdn.com/b/psssql/archive/2010/07/21/why-does-preemptive-os-getprocaddress-show-a-large-accumulation.aspx

Hope that helps.

Best regards

Robin

Exclamation "Be brave. Take risks. Nothing can substitute experience." Exclamation
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17607 Visits: 32267
Take a look at Amit Banerjee's write-up on that wait type. 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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
DBA Matt
DBA Matt
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 290
Thanks for the replies. Interesting reading.
Loundy
Loundy
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1614 Visits: 1190
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

There's no kill switch on awesome!
SQLEnthusiastic
SQLEnthusiastic
SSC Veteran
SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)SSC Veteran (209 reputation)

Group: General Forum Members
Points: 209 Visits: 103
One way to reproduce this wait type is documented here:

http://www.quicktechnotes.com/2014/12/25/wait-type-preemptive_os_getprocaddress/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search