hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID

Question

hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID

ggoble

Hall of Fame

Points: 3337
More actions
January 10, 2011 at 11:09 am

#388593

Can anyone explain what these wait types are?
PREEMPTIVE_OS_AUTHENTICATIONOPS
PREEMPTIVE_OS_LOOKUPACCOUNTSID

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 1

I wrote a blog last week about PREEMPTIVE_OS_LOOKUPACCOUNTSID..

If you are seeing this as an high wait type along with slow perf, then you may wish to check it out... Also follow the link through to Steve Hindmarsh blog

My Blog[/url]

tomas.nelson Old Hand Points: 313 More actions · Answer 2

I have problems with that kind of waits

PREEMPTIVE_OS_AUTHENTICATIONOPS

wait_typewaiting_tasks_countwait_time_msmax_wait_time_mssignal_wait_time_ms

PREEMPTIVE_OS_AUTHENTICATIONOPS146477045791693275300

someone to give me a clue pleaaaaase????

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 3

Hi, have you tried this blog?

http://sqlblogcasts.com/blogs/steveh/archive/2010/04/21/interesting-ssms-issue-with-waittype-of-preemptive-os-lookupaccountsid.aspx

tomas.nelson Old Hand Points: 313 More actions · Answer 4

Yes! I already had read it. And makes some sense; but even with all consoles closed I continue to see this wait increasing.... =(

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 5

Have you checked that the DNS/AD settings are correct.

I also found an issue when the SQL server have an old DNS server as the primary.

tomas.nelson Old Hand Points: 313 More actions · Answer 6

Yes i have checked and everything looks fine... =(

But then I can i assume that this kid of problems could be caused by the infraestructure or for the environment authentication (DNS, Active Directory, WINS, DHCP etc. etc.) ??????

I DO NOT UNDERSTAND WHY MICROSOFT IS NOT DOCUMENTED THIS.

Richard Sweetnam-491406 Valued Member Points: 51 More actions · Answer 7

Hi

Looking at the wait type and what's involved it seems like there will ALWAYS be a wait whenever you invoke a SID lookup, even if that wait is only 1 millisecond or less. The key here is whether or not the wait type is having an impact. if you divide the Wait_time_ms by the Waiting_tasks_count you should see the average ms/wait and if the post you made earlier is accurate that means that the waits are averaging at less than 1 ms. I don't think you need to worry about this.

If it is troubling you, you could setup a query that looks at the wait stats regularly (Daily, hourly or less or more frequently) and notifies you when the wait type goes over X ms (up to you to decide what is bad for your environment, I would say averages of 5ms or higher are probably bad). Remember to flush your stats regularly for accurate results though as they are cumulative.

Hope this helps,

Richard

Paul Brewer SSCrazy Points: 2955 More actions · Answer 8

It might be related to some sort of OS memory leak triggered by some random event, rebooting the server often resolves and stablizes it (based on experience rather than insider knowledge). I know of a server where an instance restart will trigger ever increasing PREEMPTIVE_OS_AUTHENTICATIONOPS wait type times, a server reboot stablizes it. When it reaches between 12-15% the impact becomes noticeable.

Loundy SSCertifiable Points: 6080 More actions · Answer 9

PREEMPTIVE_OS_AUTHENTICATIONOPS could indicate problems talking to a domain controller - not personally experienced this though.

[font="Times New Roman"]There's no kill switch on awesome![/font]