Server shuts down when running sql query

Question

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.

You could install speed fan and watch your temps. Anything up to 80c should be fine. — spuder, Aug 04 '13 at 15:15
The memory check is a good idea. Keep us posted with the results. — Christopher Perrin, Aug 04 '13 at 15:48
Never so much mind the temps, mind the voltages, tell us about your power supplies. — mckenzm, Mar 13 '20 at 05:54

score 0 · Accepted Answer · answered Aug 04 '13 at 16:16

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

Right-click My Computer, and then click Properties.
Click the Advanced tab, and then under Startup and Recovery, click Settings (or Startup and Recovery).

Server shuts down when running sql query

1 Answers1