[dba-SQLServer] [AccessD] A real puzzler

[Paul Hartland]

Could i put an idea forward that i dont think has been mentioned yet, it
looks to be a power problem, have you checked/replaced the leads etc
On 8 Aug 2015 17:40, "Jim Lawrence" <accessd at shaw.ca> wrote:

> I have no idea what the issue could be but the server rebooting while not
> under load gives a suggestion of the cause.
>
> It must be power related. Obviously it is not external power so it leaves
> only the internal power supply and related wiring. IMHO, that is the
> problem and I would replace that power hardware as soon as convenient.
>
> Jim
>
> ----- Original Message -----
> From: "John W. Colby" <jwcolby at gmail.com>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>, "Discussion concerning MS SQL Server" <
> dba-sqlserver at databaseadvisors.com>
> Sent: Saturday, August 8, 2015 5:14:47 AM
> Subject: Re: [dba-SQLServer] [AccessD] A real puzzler
>
> For the last several days I have been flogging away at the system
> (performing real work), causing the system to stay active.  All cores
> running, 75 (out of 80) GB used for SQL Server.  No reboots during that
> entire time.  And yet:
>
> Critical    8/4/2015 6:56:10 AM    Kernel-Power    41    (63)
> Critical    8/4/2015 4:42:07 AM    Kernel-Power    41    (63)
> Critical    8/3/2015 10:04:36 PM    Kernel-Power    41    (63)
> Critical    8/3/2015 5:32:06 PM    Kernel-Power    41    (63)
> Critical    8/3/2015 2:22:15 PM    Kernel-Power    41    (63)
> Critical    8/2/2015 3:29:33 PM    Kernel-Power    41    (63)
> Critical    8/2/2015 11:21:46 AM    Kernel-Power    41    (63)
> Critical    8/2/2015 10:51:30 AM    Kernel-Power    41    (63)
> Critical    8/2/2015 7:17:21 AM    Kernel-Power    41    (63)
> Critical    7/31/2015 11:50:45 PM    Kernel-Power    41    (63)
> Critical    7/31/2015 1:05:39 PM    Kernel-Power    41    (63)
> Critical    7/30/2015 10:11:57 PM    Kernel-Power    41    (63)
> Critical    7/30/2015 4:59:26 PM    Kernel-Power    41    (63)
> Critical    7/29/2015 2:32:50 PM    Kernel-Power    41    (63)
> Critical    7/28/2015 5:20:38 PM    Kernel-Power    41    (63)
> Critical    7/28/2015 12:12:57 PM    Kernel-Power    41    (63)
> Critical    7/28/2015 4:15:38 AM    Kernel-Power    41    (63)
> Critical    7/28/2015 2:47:12 AM    Kernel-Power    41    (63)
>
> WEIRD!!!
>
> Notice no pattern in number of events per day, nor time of day. There is
> no memory dump being created, the system just reboots as if the power
> was turned off and back on.  When I was in the room with it, (several
> years ago) the system would beep as it rebooted.
>
> Here is the last such event:
>
> Log Name:      System
> Source:        Microsoft-Windows-Kernel-Power
> Date:          8/4/2015 6:56:10 AM
> Event ID:      41
> Task Category: (63)
> Level:         Critical
> Keywords:      (2)
> User:          SYSTEM
> Computer:      Azul
> Description:
> The system has rebooted without cleanly shutting down first. This error
> could be caused if the system stopped responding, crashed, or lost power
> unexpectedly.
> Event Xml:
> <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
>    <System>
>      <Provider Name="Microsoft-Windows-Kernel-Power"
> Guid="{331C3B3A-2005-44C2-AC5E-77220C37D6B4}" />
>      <EventID>41</EventID>
>      <Version>2</Version>
>      <Level>1</Level>
>      <Task>63</Task>
>      <Opcode>0</Opcode>
>      <Keywords>0x8000000000000002</Keywords>
>      <TimeCreated SystemTime="2015-08-04T10:56:10.006809600Z" />
>      <EventRecordID>270735</EventRecordID>
>      <Correlation />
>      <Execution ProcessID="4" ThreadID="8" />
>      <Channel>System</Channel>
>      <Computer>Azul</Computer>
>      <Security UserID="S-1-5-18" />
>    </System>
>    <EventData>
>      <Data Name="BugcheckCode">0</Data>
>      <Data Name="BugcheckParameter1">0x0</Data>
>      <Data Name="BugcheckParameter2">0x0</Data>
>      <Data Name="BugcheckParameter3">0x0</Data>
>      <Data Name="BugcheckParameter4">0x0</Data>
>      <Data Name="SleepInProgress">false</Data>
>      <Data Name="PowerButtonTimestamp">0</Data>
>    </EventData>
> </Event>
>
> John W. Colby
>
> On 8/8/2015 7:57 AM, James Button wrote:
> > Guest that!
> >
> > Re memory diagnostic - I have found with past experiences of accelerating
> > frequency of shut-downs, that the system didn't get a chance to record
> any
> > events.
> > And memory checks showed no problems - providing the rest of the system
> wasn't
> > being stressed.
> >
> > One system I found that removing a memory module - any of them stopped
> the
> > shutdowns, and I eventually 'bodged' the system by increasing the memory
> refresh
> > by a cycle. It was an old system and a 'new' memory module was, being
> old tech,
> > horrendously expensive
> > That worked for several years, and eventually management agreed the
> system was
> > too slow - as in users kept complaining about the system's response, so
> we were
> > actually allowed to BUY a new one!
> >
> > JimB
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>