• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

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
0
jlingg
Asked:
jlingg
  • 3
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
What do you mean by completely freezes?

Either it runs out of resources or Hangs out because of deadlocks..
Kindly provide us some more info or error message associated with it.
0
 
jlinggAuthor Commented:
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.
0
 
tigin44Commented:
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...
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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.
0
 
jlinggAuthor Commented:
This problem has apparently gone away on it's own.  We have not had a recurrence in weeks.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> This problem has apparently gone away on it's own.

Anyhow have some proactive plans to monitor these kind of occurrences in future by creating an perfmon and profiler event to capture those freezing events later on..
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now