• SQL-DBA-01 (2/9/2016)


    Hi

    I captured wait stats for 3 hrs and during the period I found that this wait stats "PREEMPTIVE_OS_AUTHENTICATIONOPS" number is v high.

    Should I suspect this to any trouble with AD/DC? Or checking the avg ms/wait value of 1.2 is a good number?

    Second Sample TimeSample Duration in Secondswait_typeWait Time (Seconds)Number of WaitsAvg ms Per Wait

    YYYY-MM-DD hh:mm:ss1915148PREEMPTIVE_OS_AUTHENTICATIONOPS54084.8434332631.2

    I've read that a high wait here could indicate a problem with the domain controller, but I've never looked into it too deeply. What's your normal for this wait?