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

Any hint in sql server log and windows event logs?

I did go through all the instances' errorlog files/window event logs but didn't see any suspicious events.

Thanks

Checked with server vendor?

We haven't checked with Microsoft but with VMWare. We also use NetApp but I'm not sure if this is a storage issue.

Who is server vendor? May need update firmware.

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

No, VMWare is software. Server is hardware, the machine you run sql on.

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)

Contact HP then.

Ahah, good suggestion. Thank you.