Server shutdown

Question

Server shutdown

Admingod

SSCertifiable

Points: 5997
More actions
April 5, 2017 at 9:42 am

#323597

I see in the event logs as below. What could be the reason. Any idea?
The previous system shutdown was unexpected.
January 26, 2019 at 1:15 am

This was removed by the editor as SPAM
January 30, 2019 at 11:55 pm

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

There could be so many reasons. Power loss, system crash, hardware failure, to name but a few. You need to check the logs prior, and possibly not just on your SQL server, to the error to find out why.

For example, if it was due to power loss, was anyone in the office at the time? Did they notice there was a black/brown out? Maybe the cleaner was in your server room and unplugged it to use the vacuum cleaner (yes, that seems stupid, but I would bet money to say it's happened to someone).

If it were a system crash, there should hopefully be logs prior to state what cause it. As there should be for hardware failures.

Of course, those are not the 3 only reasons, and my statement is somewhat sweeping, but you need to do more research first.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Yes the cleaner in the server room unplugging a server has happened - sad but real.

Don't forget to check the Host logs if this happens to be a VM. It will take a bit of sleuthing but that is about all that can be done.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

Thom A - Wednesday, April 5, 2017 10:13 AM
There could be so many reasons. Power loss, system crash, hardware failure, to name but a few. You need to check the logs prior, and possibly not just on your SQL server, to the error to find out why.
For example, if it was due to power loss, was anyone in the office at the time? Did they notice there was a black/brown out? Maybe the cleaner was in your server room and unplugged it to use the vacuum cleaner (yes, that seems stupid, but I would bet money to say it's happened to someone).
If it were a system crash, there should hopefully be logs prior to state what cause it. As there should be for hardware failures.
Of course, those are not the 3 only reasons, and my statement is somewhat sweeping, but you need to do more research first.

That vacuum cleaner thing happened repeatedly at a previous company of mine, many years ago, when I was using DEC VAX computers. No one could figure out why the server kept restarting overnight.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

lptech Hall of Fame Points: 3208 More actions · Answer 4

Years ago, I heard of a situation involving a coffee maker.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

lptech - Wednesday, April 5, 2017 2:01 PM
Years ago, I heard of a situation involving a coffee maker.

I am waiting for the curious case of the Ice Cream maker causing a server restart. Maybe somebody can force a restart with a popcorn machine.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Thom A SSC Guru Points: 99130 More actions · Answer 6

SQLRNNR - Wednesday, April 5, 2017 3:02 PM
lptech - Wednesday, April 5, 2017 2:01 PM
Years ago, I heard of a situation involving a coffee maker.
I am waiting for the curious case of the Ice Cream maker causing a server restart. Maybe somebody can force a restart with a popcorn machine.

Wait, am I the only one who's makes Ice Cream in the server room because it's cold in there..? I thought that was a given. I just have, to err... Check on... a thing... Yes, "a thing"! 'Cuse me.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

On a serious note, I have had network switches that were misbehaving force server restarts. The range of causes is pretty wide.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events