• 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.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)