Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    21

    Unanswered: NUMA - Angel or Devil?

    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.

    Thanks,
    Ova

  2. #2
    Join Date
    Jan 2003
    Posts
    17

    Re: NUMA - Angel or Devil?

    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.

    Thanks,
    Ova
    OVA,

    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.

    -Carl

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •