A performance question on SQL Server Active Passive failover
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I'm new to clustered SQL Servers so bare with me. Anyway, if I run an SP that basically copies a few records from one (large) table to another, it goes in a couple of seconds if I connect to the IP of the active node. However,if I connect to the cluster IP the same SP takes three hours to run. Why the big difference? I don't even know where to start looking, any hints are welcome.
Wrong is evil and must be defeated. - Jeff Ello