Results 1 to 11 of 11

Thread: Server Crash: SQL hung on ESX box

  1. #1
    Join Date
    Feb 2009
    Posts
    7

    Server Crash: SQL hung on ESX box

    Hello,

    I wonder if anyone has come across the same issue and would share your experience with me:

    I have a sql 2k5 (SP2-Standard) server that resides on an ESX box (v3.02). It had been running for a year without any issues until last couple months. The sql server keep getting hung (no network activity, no connections can be made, CPU & Memory % used = 0) at the last weekend of the months, Sun or Sat. I was able to connect to the VI client directly to the ESX host and go to the sql server console welcome screen but couldn't do anything. Every time this issue occurs, our SA has to issues kill commands on the ESX server and Power the sql server back on.

    We got VMware Supports involved but they couldn't figure out what really caused the issue. When the server went back online, I went to the sql log folder and look for any dump files but couldn't find one. I also checked on my job schedule and couldn't find out any conflicts between any of them.

    Any thought/comments on this would be greatly appreciated.

    Simon
    Last edited by sunshinesvn; 02-18-2009 at 12:24 PM.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Any hint in sql server log and windows event logs?

  3. #3
    Join Date
    Feb 2009
    Posts
    7
    I did go through all the instances' errorlog files/window event logs but didn't see any suspicious events.

    Thanks

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Checked with server vendor?

  5. #5
    Join Date
    Feb 2009
    Posts
    7
    We haven't checked with Microsoft but with VMWare. We also use NetApp but I'm not sure if this is a storage issue.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    Who is server vendor? May need update firmware.

  7. #7
    Join Date
    Feb 2009
    Posts
    7
    I'm not sure if I understand the question correctly, but it's a VM sql server that is hosted on an ESX box v3.02. So VMWare should be our vendor that you're talking about?

    Simon

  8. #8
    Join Date
    Sep 2002
    Posts
    5,938
    No, VMWare is software. Server is hardware, the machine you run sql on.

  9. #9
    Join Date
    Feb 2009
    Posts
    7
    OK, sorry about that. It's a HP server.

    Model: ProLiant DL585 G2
    Processors: 8 CPU x 2.812 GHz
    Processor Type: Dual_Core AMD Opteron(tm)

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Contact HP then.

  11. #11
    Join Date
    Feb 2009
    Posts
    7
    Ahah, good suggestion. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •