jlingg
asked on
SQL Server 2008 - Freezes must be rebooted
I have a sql server 2008 standard 64 bit server. Twice in the last two days it has completely frozen and stops working. I am able to connect to it's event log from another computer and there is nothing in it related to the problem. To get it working again we have to power off and on. It then continues to work fine. Is there any way to increase the level of logging so that it writes more events to the event viewer or some other way to monitor it in order to diagnose the problem? Running on Windows Server 2008. Any ideas would be appreciated.
thanks
thanks
ASKER
I mean that it stops processing requests from SharePoint (it is primarily the back end of a sharepoint install), It no longer let's you log in (either from RDP or at the console). It shows nothing in the event viewer to give you a clue on what has gone wrong. The only way to get it going again is to power the system off and back on again.
did you try to use the admin log on? It has precedence and can let you log on even if it does not responds to the nor mal users. Once you get in then you can check whats going on...
Try using Profiler or Audit triggers to find out what causes your database to frozen state.
That would be better to prevent this scenario in future.
That would be better to prevent this scenario in future.
ASKER
This problem has apparently gone away on it's own. We have not had a recurrence in weeks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Either it runs out of resources or Hangs out because of deadlocks..
Kindly provide us some more info or error message associated with it.