Start a Conversation

Unsolved

This post is more than 5 years old

1403

March 30th, 2015 08:00

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,

54 Posts

April 1st, 2015 05:00

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=1010041

April 1st, 2015 06:00

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=1036189

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

Thanks again,

100 Posts

May 4th, 2015 14:00

Techtrader, what did you find out?

No Events found!

Top