May 22, 2014 at 2:09 pm
We are seeing high miscellaneous wait types on our server. What exactly are these wait types?
May 22, 2014 at 2:25 pm
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
May 22, 2014 at 4:14 pm
yes. We are using sqlsentry.
May 22, 2014 at 4:25 pm
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
May 22, 2014 at 5:27 pm
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.
May 22, 2014 at 5:40 pm
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
May 23, 2014 at 4:25 am
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