Server freeze restarted quickly so how do I fiond what went wrong?

Posted by Charlie on Server Fault See other posts from Server Fault or by Charlie
Published on 2012-12-19T10:09:24Z Indexed on 2012/12/19 11:04 UTC
Read the original article Hit count: 202

Filed under:
|
|

I have a SQL SERVER DB running on a windows server 2008 (VMWare) Yesterday I could not RDP to it so I ended some RDP sessions which were left logged in. This seemed to solve the problem. However last night I learned that the DB was inaccessible and unresponsive to customers. My colleague checked the server but again is unable to create an RDP connection.
He then restarted the server and since it has been fine.

Looking at the CPU Readings of the Server it spiked up to 100% before the original RDP problem .After I ended the extra seeions uit again dropped down to normal levels however before the time of the customer complaint it had rose to 100% again - before it had to be restarted. Is there anyway I can investigate which processes may have caused the problem in the first place. Would there be some kind of memory dump from when it was restarted. I would prefer to find out what is wrong now instead of waiting until it happens again.

© Server Fault or respective owner

Related posts about windows-server-2008

Related posts about rdp