wkdpanda wrote:
I think Keith was saying that the VMware was dandy, but the SQL cluster was having issues.
Given that - everything said still applies. Look for bottle necks at the disk level, and work your way up.
-Andy
I took "dandy" to also imply that ESX is not showing high latency from its physical physical disk performance metrics. If there is a physical disk related bottleneck, I would expect ESX performance reporting/alerting to paint red all over that and be far from dandy.
That said, you might want to circle back to vSphere and look at the "physical disk command latency" of the ESX server under "Hosts and Clusters" advanced performance charts. Check that chart and look for excessive times over 10ms. A single spike once in awhile is fine, what you are looking for are lines that remain over 10ms for several polling cycles straight. Each line should represent a separate LUN, or datastore so you can zero in on the hot one(s).