Virtual CPU requirements for heavy SQL workload

Hi Everyone,

Just wondering if anyone has any feedback on configuring virtual CPU to
get the best performance with a heavy SQL workload. Say we have a
partition with one full CPU. I'm assuming SQL would perform better with
more than one virtual, but does anyone have any guidelines? Two? Ten?

I've had a look at the V6R1 Performance Capabilities Reference manual but
there doesn't seem to be any SQL specific guidelines, at least as far as I
can see.

Any advice, feedback or personal experience is appreciated.



Thanks

Adam Driver
IBM Certified Systems Administrator - System i
Infrastructure Technician
WEA Trust
608.661.6697 ext 2581
adriver@xxxxxxxxxxxx
P Please consider your environmental responsibility before printing this
e-mail.



















WEA Trust health plan earns No. 1 rating in Wisconsin.

For the second straight year, the Trust received the top score in
Wisconsin for health plan rating according to the latest results from
CAHPS, a national independent survey.Learn more about the Trust's results.





- Confidentiality Notice -

This electronic mail message and any files transmitted with it are
confidential and are intended solely for the use of the individual or
entity to whom they are addressed. Dissemination, forwarding, printing, or
copying of this electronic mail without the consent of the sender is
strictly prohibited. If you are not the intended recipient or the person
responsible for delivering the electronic mail to the intended recipient,
be advised that you have received this electronic mail in error; please
immediately notify the sender by return mail.