SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


server automatic restart


server automatic restart

Author
Message
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3850 Visits: 4014
We have a windows 2008 server sp2 that hosts a SQl server 2008.

Recently the server has an automatically restart at a night and a weekend.
In the HP Proliant Integrated Management Log viewer I can see the
Operating system failure bug check 0x00000050, see detail in the attachment screenshot.

I assume this is a blue screen restart, it crashed then it restart itself and run fine after that.

What could be the reason that crashes and how can we dignostic it and fix it?

Thanks much
Attachments
Screenshot.gif (32 views, 79.00 KB)
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86045 Visits: 41096
sqlfriends (12/1/2013)
We have a windows 2008 server sp2 that hosts a SQl server 2008.

Recently the server has an automatically restart at a night and a weekend.
In the HP Proliant Integrated Management Log viewer I can see the
Operating system failure bug check 0x00000050, see detail in the attachment screenshot.

I assume this is a blue screen restart, it crashed then it restart itself and run fine after that.

What could be the reason that crashes and how can we dignostic it and fix it?

Thanks much


It's telling you exactly what the problem is and the Operating System errors are probably just a symptom of a much larger problem. Either memory module 3 or memory module 4 or both have a serious problem. It could be a failure of one of the chips or it could be that they're just not seated properly. I'd try the reseating thing (take them all the way out and then put them back), fire the system up, and see if you get the same critical errors. If you do, you're going to need to replace some memory modules. Depending on the warranty that HP provided you (or not), it might be fully covered and HP might replace the modules for free.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3850 Visits: 4014
Thanks much, Jeff.

Could you tell me where you can see it could be issue with memory module 3 or 4 in the attachment?

Oh, I see - I accidently highligted in blue, I actually meant the newest two records on the top which happend last week.

The blue highted is something happened in 2011.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86045 Visits: 41096
sqlfriends (12/3/2013)
Thanks much, Jeff.

Could you tell me where you can see it could be issue with memory module 3 or 4 in the attachment?

Oh, I see - I accidently highligted in blue, I actually meant the newest two records on the top which happend last week.

The blue highted is something happened in 2011.


Crud. Sorry about that. When I blew it up big enough to read, I couldn't see the dates anymore and didn't realize that I was looking at old entries. My apologies.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3850 Visits: 4014
Thanks,

So for the first top 2 records, can we see it is a hardware problem or not?
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86045 Visits: 41096
sqlfriends (12/4/2013)
Thanks,

So for the first top 2 records, can we see it is a hardware problem or not?


I don't know the answer to that question. I'm thinking a call to MS might be the right thing to do.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3850 Visits: 4014
Thanks, will do
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search