We upgraded a server last weekend from ASA 9 to ASA12 64 bit. One query (execution plan attached) when executed pegs the CPU for one core (it is a 4 core machine) for several minutes. The same query on all of our other ASA 12 systems (and on ASA 9 systems) runs in seconds or less. The data on the other systems is different in content but not structure.
Before the upgrade this same query ran quickly. Other queries run well (or at least no others ones have been reported yet).
What makes this server different?
asked 07 Dec '11, 18:55