Unsolved
This post is more than 5 years old
9 Posts
1
1403
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,
iop2go
54 Posts
0
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
tech1trader
9 Posts
0
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,
TimH
100 Posts
0
May 4th, 2015 14:00
Techtrader, what did you find out?