Why would a dba do manual failover because of high cpu? I got no answer from dba, but cpu did improve from 85 to 60, then down to about 40%. My thought is there was parameter sniffing problem and clear proc cache from failover fixed the problem,
recompiling all the procs is why cpu high at first after failover? Until cpp started spiking to 80 it was under 50% all day.
View Complete Post