Originally posted by: Wouter Liefting
Kumar, that is impossible to answer based on a short post.
First, you don't have a choice between virtual processors and physical cores. The hypervisor will always map whatever amount of "virtual processors" you specified, onto the number of available "physical processors". If you use "dedicated processors" there is a 1-on-1 relationship, if you use processors from the "shared pool" ("shared processors"), anything can happen depending on the exact settings, the size of the shared pool, and how much CPU demand there is from other partitions. There may be a 1-on-1 relationship but it may also be that up to 10 (20 on the latest Power7 HW) virtual processors will be folded onto one physical processor. Which is highly inefficient.
Furthermore, what also matters is whether your workload is peaking a lot, or whether it's relatively constant throughout the day. And do you have the spare capacity in the managed system to deal with those peaks or not? Do you have other partitions on the same machine that can benefit from the available CPU cycles if your partition is quiet? Oh, and what is the licence entitlement for your database? How many CPU cores are you paying for?
You said you have to create the LPAR with 10 CPUs (cores I assume) as per the initial demand. Is that what your customer is paying for, and what your licence entitlement is? If you then only entitle the partition to four processing units, you only allow the partition to use 40 ms of CPU time for each timeslice of 10 ms. While the customer specified 100 ms of CPU time per timeslice. Doesn't sound like that's going to work.
In any case, an entitlement of 4.0 but 10 virtual processors only makes sense if your partition is "uncapped". And only if your workload is "bursty", with the troughs of your workload needing about 4.0 CPU, but the peaks requiring 10.0 CPU. And if there are at least 10 physical CPUs available in the shared pool (or MSPP if you use that), and the other partitions in the same shared pool are also bursty with peaks at different times. If your workload is fairly constant, or if there is no excess capacity in the shared pool in the first place, your system will run better with just 4 or maybe 5 VPs. Assuming that the entitled capacity of 4.0 is sufficient for the task of course.
You see, there are a lot of variables that influence the proper settings for best performance. And we haven't even discussed what "best" performance is in a virtualized environment. (Highest throughput for this single partition, or optimum use of resources across all partitions?) Fully answering your question on this forum is not going to work because you really need an expert who is going to dig into your exact situation and requirements. You can either get help from such an expert, or become an expert yourself. Attend a course (I recommend the AN31), attend a conference (The Power conference in Athens is coming up early November) or dig into a few redbooks and other IBM documentation.