hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » hight wait type of...

hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID

Rate Topic

Display Mode

Topic Options

Author

Message

ggoble

Posted Monday, January 10, 2011 11:09 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:45 PM
Points: 366, Visits: 840

Can anyone explain what these wait types are?

PREEMPTIVE_OS_AUTHENTICATIONOPS
PREEMPTIVE_OS_LOOKUPACCOUNTSID

Post #1045469

sql_lock

Posted Wednesday, January 12, 2011 12:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:28 AM
Points: 1,289, Visits: 1,532

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

Post #1046292

tomas.nelson

Posted Tuesday, June 26, 2012 11:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:24 PM
Points: 6, Visits: 87

I have problems with that kind of waits

PREEMPTIVE_OS_AUTHENTICATIONOPS

wait_type waiting_tasks_count wait_time_ms max_wait_time_ms signal_wait_time_ms
PREEMPTIVE_OS_AUTHENTICATIONOPS 14647704 5791693 27530 0

someone to give me a clue pleaaaaase????

Post #1321410

sql_lock

Posted Tuesday, June 26, 2012 3:58 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:28 AM
Points: 1,289, Visits: 1,532

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

Post #1321597

tomas.nelson

Posted Tuesday, June 26, 2012 4:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:24 PM
Points: 6, Visits: 87

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

Post #1321615

sql_lock

Posted Wednesday, June 27, 2012 1:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:28 AM
Points: 1,289, Visits: 1,532

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.

Post #1321723

tomas.nelson

Posted Wednesday, June 27, 2012 9:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:24 PM
Points: 6, Visits: 87

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.

Post #1321943

Richard Sweetnam-491406

Posted Monday, October 29, 2012 5:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 5:04 AM
Points: 1, Visits: 20

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

Post #1378197

Paul Brewer

Posted Friday, May 10, 2013 1:07 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:06 AM
Points: 54, Visits: 613

It might be related to some sort of OS memory leak, try rebooting the server.

Post #1451430

Loundy

Posted Friday, May 10, 2013 1:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:42 AM
Points: 1,388, Visits: 769

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

There's no kill switch on awesome!

Post #1451437

« Prev Topic | Next Topic »

Permissions