Originally posted by Ova
Does 12.5.1 use NUMA right out of the box or is there a configuration parameter(s) to set to use NUMA?
Is anyone using NUMA features that can give any hints or tips.
We moved to an IBM X440, which is at least 2x the machine we were on, but our database performance is really no better.
Any feedback would be great.
I can tell you that we did performance tests using ASE 12.5 on a Compaq (Now HP) GS160 and saw poor performance with NUMA. All of the calls across QBB ( Quad Building Bocks) had to go across an H-switch. This introduces 3 times the normal latency that a SMP box would see for memory access. Basically the GS160 is 4 SMP boxes (QBB) attached togther through an H-switch. So just imagine if you have a large ASE server that allocates memory across multiple QBB's. Depending on which processor gets the request and where the memory is, access could be either fast or slow. Then ASE moves the cached object to the MRU from the LRU and perf will change again. We worked with both sybase and compaq extensively. We did not have much luck and wound up doing a platform move to IBM and the P series.