Following a colleague running a heavy query via a linked server and killing the process on the remote machine, we've had SQL becoming non reponsive and I had to restart the server (the services individually failed to restart).
The error is 'Non-yielding IOCP Listener error' and followed some memory issues.
I'm following recommendations in these links and am implementing the changing both the Min and Max SQL memory settings to the same (2GB less than the machine capacity).
http://blogs.msdn.com/grahamk/archive/2008/09/11/non-yielding-iocp-listener-stack-dump-analysis.aspx
http://204.9.76.233/Community/forums/p/24993/139079.aspx#139079
(Admittedly I should have done this years ago but with 32GB to play with on the box, I've never come close to investigating any memory problems.)
No comments:
Post a Comment