[dba-SQLServer] A real puzzler

[Damien Solodow]

No records of BSOD in the Event Log/dumps?
Do your baseboard controller logs (iDrac, iLO, etc) say anything about the cause of the reboot?

In the Event Log anything about the reboot or around the time? Perhaps some task/process is making it think it *should* reboot?

DAMIEN SOLODOW
Senior Systems Engineer
317.447.6033 (office)
317.447.6014 (fax)
HARRISON COLLEGE

________________________________________
From: dba-SQLServer [dba-sqlserver-bounces at databaseadvisors.com] on behalf of John W. Colby [jwcolby at gmail.com]
Sent: Friday, August 07, 2015 10:20 PM
To: Discussion concerning MS SQL Server; Access Developers discussion and problem solving
Subject: [dba-SQLServer] A real puzzler

My SQL Server spontaneously reboots.  In the past it was once a month,
then once week or two.  Now it is several times a day.

UNLESS SQL Server is exercised heavily, and then it will not reboot.

That is counter intuitive.

If the issue were a memory issue, SQL Server using all of the memory
(and it does) would find and trigger such errors.
If it were a heat issue, SQL Server using all of the processors (and it
does) would cause more heat.

Etc.

If I stop the service(s) it still reboots.

I am at a loss, not only as to cause, but how to troubleshoot.

Any words of wisdom?

Dual chip mother board.
Two AMD processors each with 8 cores (15 cores total)
80 gigs RAM
Windows 2008
SQL Server 2008

--
John W. Colby

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com