Re: NUMCPUVPS settings for a four-processor server

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