Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

server automatic restart Expand / Collapse
Author
Message
Posted Sunday, December 1, 2013 1:23 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 1,792, Visits: 3,262
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


  Post Attachments 
Screenshot.gif (30 views, 79.82 KB)
Post #1518708
Posted Sunday, December 1, 2013 6:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1518730
Posted Tuesday, December 3, 2013 3:33 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 1,792, Visits: 3,262
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.
Post #1519433
Posted Wednesday, December 4, 2013 2:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1519524
Posted Wednesday, December 4, 2013 9:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 1,792, Visits: 3,262
Thanks,

So for the first top 2 records, can we see it is a hardware problem or not?
Post #1519696
Posted Wednesday, December 4, 2013 4:19 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1519835
Posted Wednesday, December 4, 2013 4:32 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 1,792, Visits: 3,262
Thanks, will do
Post #1519836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse