Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID Expand / Collapse
Author
Message
Posted Monday, January 10, 2011 11:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 8:42 AM
Points: 378, Visits: 995
Can anyone explain what these wait types are?

PREEMPTIVE_OS_AUTHENTICATIONOPS
PREEMPTIVE_OS_LOOKUPACCOUNTSID
Post #1045469
Posted Wednesday, January 12, 2011 12:19 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:19 AM
Points: 1,530, Visits: 1,729
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
Posted Tuesday, June 26, 2012 11:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:30 AM
Points: 6, Visits: 97
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
Posted Tuesday, June 26, 2012 3:58 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:19 AM
Points: 1,530, Visits: 1,729
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
Posted Tuesday, June 26, 2012 4:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:30 AM
Points: 6, Visits: 97
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
Posted Wednesday, June 27, 2012 1:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:19 AM
Points: 1,530, Visits: 1,729
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
Posted Wednesday, June 27, 2012 9:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 20, 2014 9:30 AM
Points: 6, Visits: 97
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
Posted Monday, October 29, 2012 5:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 14, 2014 4:02 AM
Points: 1, Visits: 22
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
Posted Friday, May 10, 2013 1:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 30, 2014 6:45 AM
Points: 65, Visits: 948
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.
Post #1451430
Posted Friday, May 10, 2013 1:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 8:05 AM
Points: 1,597, Visits: 1,150
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 »

Add to briefcase

Permissions Expand / Collapse