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.