wait types-miscellaneous

  • We are seeing high miscellaneous wait types on our server. What exactly are these wait types?

  • deep_kkumar (5/22/2014)


    We are seeing high miscellaneous wait types on our server. What exactly are these wait types?

    Are you using a 3rd party tool that is reporting the misc waits?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • yes. We are using sqlsentry.

  • There are no "miscellaneous" waits in SQL Server. SQL Sentry has taken some of the "noise" waits and just grouped them under miscellaneous. You can ignore those for the most part.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • the problem is sql server not responding for a minute or two and then recovers. There's no blocking or deadlock schedulers. In a fraction of second it's getting recovered. It throws the error-

    New queries assigned to process on Node 0 have not been picked up by a worker thread in the last 60 seconds.

  • Have you looked into CPU contention or CPU bottlenecks?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • there's no cpu or memory contention. We increased the max workers thread from 2000 to 4000.But we are still seeing issue. Suddently the worker thread count reaches the max value and sql server doesn't respond. when look at the wait_types it shows sos_scheduler_yield and XE_BUFFERMGR_FREEBUF_EVENT are very high. Not able to figure out why the server is behaving weirdly.

    server config: windows server 2008 r2 sp1

    sql server : sql server 2008 sp3

Viewing 7 posts - 1 through 6 (of 6 total)

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