[AccessD] Can anyone help me with this

[Jim Lawrence]

Hi John:

You have probably gone through all these checks but I will post them anyways. Have you checked your logs? Is there an exact time when this reboot occurs? Is the reboot spawned by something like an "exceptions error" or a system process? Considering that all your software is probably up to date could it be a hardware error? A failing piece of equipment or some new hardware that was introduced?

One comment I have seen is that an active SQL server eventually runs out of address space and if possible it is quicker and cleaner to just do an "idle time" reboot than to run the "garbage collection" routine. If that is the case there should be some option setting that would control the activation and timing? 
 
Jim

----- Original Message -----
From: "John Colby" <jwcolby at gmail.com>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Saturday, October 14, 2017 7:45:46 AM
Subject: [AccessD] Can anyone help me with this

My SQL Server (Windows 2008) reboots periodically.  Periodically implies 
on a schedule so perhaps sporadically is a better description.  This has 
been going on for years.  It will do so several times a day.

What I have discovered is that if I keep one of the cores busy, and I 
use a script in SQL Server to do that, then it never reboots.

I read that Windows 2008 can be led to believe (accidentally in my case) 
that it needs to reboot to finish an install or something of that 
nature, and it will do so when the system is "idle".  By keeping a core 
active, the system never does that reboot thing.  I do not know for sure 
that this is what is going on but it absolutely makes sense.  In he 
meantime I have to do this "keep a core active" thing or my server 
reboots.  If anyone out there understands what is really going on and 
how to tell Windows to knock it off, please contact me.

Thanks,

-- 
John W. Colby

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com