RE: Virtual Processors and CPU-Load

Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes that have the largest BUFREADS (select * from sysmaster:sysptprof order by bufreads desc) ------------------------------------------ Alexey Sonkin Senior Database Administrator > we are a little bit confused concerning the CPU-Load of our = > Informix-Database-Server. (9.4 UC3, RH9 2.4.20) > We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at = > 99.9%! > Virtual processor summary: > class vps usercpu syscpu total > cpu 2 8537.87 176.72 8714.59 > aio 4 282.68 1645.61 1928.29 > ------=_NextPart_000_0098_01C40CD9.FCAF4D00-- sending to informix-list