Unanswered: SQL 2k dual cpus spin in opposite directions
I am running Win2k SQL 2k with NT4 sp6a WebFarm. At least once a day, the cpus on the SQL 2k box seem to spin in opposite directions and cause system sluggishness ( word ? ). Both cpus never go beyond 60% of utilization. When one cpu peaks the other troughs. This is also causing connections to hang, and they won't terminate with a kill command either.
Any help would be greatly appreciated. This one has me baffled.