Home Forums SQL Server 2008 SQL Server 2008 - General hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID RE: hight wait type of PREEMPTIVE_OS_AUTHENTICATIONOPS & PREEMPTIVE_OS_LOOKUPACCOUNTSID

  • 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