tech1trader
1 Nickel

SP Rebooted SQL Cluster on VMWARE failed

Hello,

We recently patched our VNX5300 and in the process it rebooted each of the SPs.

Most of our servers didn't have a problem.  Our physical clustered SQL servers had no issues.  Our clustered SQL server on VMWARE went down.  It tried to failover, said it couldn't find the disk and went down.

The host it is on is VMWARE 5.0.0.2, SQL server 2008, MS Server 2008 R2,   initiators for the host are set to 4, The OS is on a virtual disk but the SQL databases, Quorum and logs are on Mapped Raw - Compatibility Mode is Physical.

The two host are identical, Checking the Cisco Fibre Switch show them zoned to both SP's.  In addition to the SQL servers 7 other smaller servers reside on the hosts, none of those had issues.

Is something configured incorrectly, should I look at something else?

Any assistance would be appreciated.

Thanks,

Labels (1)
Tags (4)
3 Replies
iop2go
1 Nickel

Re: SP Rebooted SQL Cluster on VMWARE failed

What is your vmware path selection policy ?

I know I have ran into this before:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=101004...

0 Kudos
tech1trader
1 Nickel

Re: Re: SP Rebooted SQL Cluster on VMWARE failed

Thanks!

In speaking with our SQL admin further about it it appears the Quorum drive did have the issue.

I found this link that explains how to change the path selection, is this what you mean?

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=103618...

I will need to consult with our ESX engineer on this if so.

Thanks again,

0 Kudos
TimH2
2 Iron

Re: SP Rebooted SQL Cluster on VMWARE failed

Techtrader, what did you find out?

0 Kudos