SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 06:17 AM
| ||||
| ||||
 CPUs utilization Hi, I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are assigned to Informix DB (because of limitation of using IDS Workgroup ED). I observe that doing off business hour and nobody logon the system. I run a big sql report then run UNIX command "mpstat 2 100" it show that only one CPU assigns to Informix is running full blow. But another second CPU assigns to Informix is sit 99% idle. I wonder why is Informix not able to utilize a 2nd CPU to run one job on both CPUs. I would appreciate any of your input so I can understand better. Thank you --Wayne      |
|
04-20-2008, 06:17 AM
| |||
| |||
| Re: CPUs utilization Wayne wrote: > Hi, > > I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are > assigned to Informix DB (because of limitation of using IDS Workgroup > ED). I observe that doing off business hour and nobody logon the > system. I run a big sql report then run UNIX command "mpstat 2 100" it > show that only one CPU assigns to Informix is running full blow. But > another second CPU assigns to Informix is sit 99% idle. I wonder why > is Informix not able to utilize a 2nd CPU to run one job on both CPUs. > I would appreciate any of your input so I can understand better. Thank > you Did you enable PDQPRIORITY and / or PSORT? -- Strewth! Stick a sock in it, Sheila! |
|
04-20-2008, 06:17 AM
| ||||
| ||||
| Re: CPUs utilization "My Name Is Bruce and I'm A Sock Puppet" <godzone@downundah.com> wrote in message news:2m2hacFhrgh4U1@uni-berlin.de... > Wayne wrote: > > > Hi, > > > > I have the Sun Fire V480 system with 4 CPUs and only 2 CPUs are > > assigned to Informix DB (because of limitation of using IDS Workgroup > > ED). I observe that doing off business hour and nobody logon the > > system. I run a big sql report then run UNIX command "mpstat 2 100" it > > show that only one CPU assigns to Informix is running full blow. But > > another second CPU assigns to Informix is sit 99% idle. I wonder why > > is Informix not able to utilize a 2nd CPU to run one job on both CPUs. > > I would appreciate any of your input so I can understand better. Thank > > you > > Did you enable PDQPRIORITY and / or PSORT? He mentioned Work Group Edition. PDQ is disallowed in WGE. |
Linear Mode
