We have a very outdated SQL cluster on Windows 2k using VCS for Win 2.0 on HP DL580 G1's. Recently there have been some severe performance issues with SQL. We are on a path to upgrade once the dollars come through. The servers sit around 90% CPU and 98% memory usage. There are 4 SQL DB instances on each cluster server. In the event of a cluster failover, how would the resources on the receiving server re-act. I see it several different ways.
A: The failover occurs, and resources balance out (optimal).
B: The failover won't occur because there aren't enough resources.
C: The failover occurs, but because of resource issues, now both servers in the cluster crash.
I know we desperately need to upgrade the entire stack, but that is management decision and out of my control. I'm just wondering that since we are configured with clustering, would we be better off disabling it as to not take down both servers in the cluster in the event of 1 server failure.
Any feedback welcome. Thx