C
ChUIMonster
Guest
If there are truly only 4 cores (out of a total of 10) and they are truly dedicated then it probably isn't a NUMA problem. Although it could still be a virtualization issue. What is the CPU entitlement? But 10 is a very strange total number to have. Usually these things come in powers of 2. LPAR configuration can make a big difference. The defaults for AIX are not friendly to databases. By default AIX makes everything dynamic and spreads your CPU over as many cores as it can. You have to go way out of your way to change that. Databases use large shared memory caches that must be coordinated. That is generally done with mutex locks (aka "latches") and the process of doing that requires CPU caches to be synchronized. That is *much* more efficient when the cores are dedicated and share the same silicon. Which is the exact opposite of the defaults on NUMA servers (and almost all large servers are NUMA these days) and in virtualized environments. A couple of simple commands that might shed some light: "lparstat -i" and "lssrad -va"
Continue reading...
Continue reading...