From my diagnosis the worker process stops responding randomly, the server becomes very slow with 100% cpu utilization. I'm not certain but I think its because of w3wp.exe process which is my app pool.
At this time, no websites respond, I have to restart IIS in order to make it work. Mostly the IIS restart / MSSQL restart does not work (error stating services are not responding) and I have to restart the entire server.
I don't understand if this is a Memory Leak / Crash / IIS Hang issue. I have installed DebugDiag from Microsoft.com & created dump files however unable to understand what the analysis results are that mention max time consuming threads etc.
Windows Server 2008 SP2
MS Sql Server 2008
I recently upgraded from windows server 2003 to windows server 2008 / mssql 2005 to mssql 2008 and
this issue was persisting in the old server as well, so I'm certain its one of my applications being mischievous.
Thank you so much for reading through my issue. You help will be greatly appreciated.