Re: NUMCPUVPS settings for a four-processor server

Gee, This goes back to what I was saying. When tuning a system, you shouldn't rely on the number of CPUs a system has. It doesn't matter. You have one proc stack, and one memory pool. -Mikey Bill Border wrote: > > We have found that in the case of systems with very fast CPU's that > there are times that you need to set NUMCPUVPS to more than the number > of physical CPU's. We have a T600 with 10 CPU's where we configure > 15 CPU VP's and we still cannot drive the all CPU's to 100% busy. When > we were using 8 or 9 CPU VP's, we had long VP ready queues and the > system was only 60% busy. > > My $0.02, > Bill > > NeilTruby wrote: > : I'm migrating two Informix database servers to a Sun Ultra E4002 with 1.5 GBytes > : of memory and 4CPUs. One server is heavily-used and performance is optimal, the > : other is lightly used. > > : I am planning to set up the heavily-used server with NUMCPUVPS=3 (one less than > : the actual number of processors) as per various recommendations, and leaving the > : other server with NUMCPUVPS=1. > > : Anyone have any other views about NUMCPUVPS settings, and about the use of > : processor affinity? > > : Thanks > > : Neil Truby > : Chase Manhattan Bank > : Bournemouth, UK > : neil.truby@chase.com > > : P.S. I know that I would probably optimise performance by having a single server > : with multiple databases; however for reasons outside my control this has been > : ruled out. > > . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . > > /*** Hewlett-Packard - AIT/Colorado Springs > / ***\\ Address: 1900 Garden of the gods Road > / \\ / Colorado Springs, CO 80907 > /* / \\ /**\\ Mailstop: C103G > /***\\ / \\/ \\ > / \\ \\ Email: border@cs.itc.hp.com > / Bill Border \\ \\ Phone: (Telnet/719) 590-3402 > / AIT Database Americas Fax: (Telnet/719) 590-3596 -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************