Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.
  • Sql Server 2005 Windows Server 2003 64 bit 8 processors
  • 3 volumes with at least 100 gigs free on each

I was adding an sql index for a table with millions of rows and the server shut down. Nothing in the event log other than the last shut down was unexpected. Upon restart the db is suspect and I take the steps to recover it. I'm running a dbcheck for about 30 mins then another shut down. This pattern is easily repeatable meaning that it has happened every time I've attempted it.

If I don't attempt to recover this db and let it sit the server doesn't crash otherwise. It ran for a week before I noticed the db was broken. Meaning, under regular load, this server doesn't crash. This isn't a prod system but for testing.

I'm guessing its overheating though nothing is telling me that. The server has not had heat issues in the past and it was designed with heavy duty heat sinks and has a good air flow.

I suppose it could be a faulty memory stick. I'll run a memory check in a moment.

share|improve this question
    
You could install speed fan and watch your temps. Anything up to 80c should be fine. –  spuder Aug 4 '13 at 15:15
    
The memory check is a good idea. Keep us posted with the results. –  Christopher Perrin Aug 4 '13 at 15:48
    
Server make and model? –  Simon Catlin Aug 4 '13 at 19:57

1 Answer 1

up vote 0 down vote accepted

Configure your System Failure and Recovery options to create at least a minidump on crashes. When the computer crashes next, either install/use WinDBG to analyze the crash dump. Or if its a minidump, you can upload it to an online crash analysis site like: http://www.osronline.com/page.cfm?name=analyze

  1. Right-click My Computer, and then click Properties.
  2. Click the Advanced tab, and then under Startup and Recovery, click Settings (or Startup and Recovery).
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.