June 13, 2014 at 10:03 am
I know this is an old post but I came across it through a Bing search (don't hold it against me :w00t: ).
Anyway for those that may come across this in searching for "PREEMPTIVE_OS_WAITFORSINGLEOBJECT", I came across this article from Michael Swart: "Be Quick About Reading The Data You Asked For[/url]".
A lot of the "preemptive_xx" waits in SQL Server are only documented through blog post. Through reading bits and pieces of BOL where "preemptive" comes up I understand that "preemptive" is something with the operating system or external to SQL Server. So SQL Server is basically waiting on something outside of its control before it can keep going. The article from Michael Swart suggest that seeing this particular wait type along with "ASYNC_NETWORK_IO" can be an indication that SQL Server is waiting on a client to process the data it is getting from the database.
I have learned that with waits it is important to not necessarily focus on just one, as seeing some along with others can mean more than just seeing one particular wait type frequently. Along with the fact that some are just going to happen and it is not necessarily a bad thing every time.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply