NT 7.30 Performance

Hi Folks! We intend to run a small DatawareHouse on a NT Compaq Machine; it is still with one Pentium III Processor, 256 Mb RAM; about 30 users running an ERP Soft, and some 5 other running some select queries..heavy ones. When we had about 2 users running these queires the performance was OK, but now with 5-6 users, all performance, including the ERP system, is very poor.. I know i must add another processor, but while it does not come, what would be better? Set oninit priority to high/real time in NT task manager? Add another CPU VP in Onconfig? Set Noage to 1? Task Manager ; CPU-->100% Memory --> 265 Mb used Any tips would be apreciated. Gustavo.

<gmurad@unimedsp.com.br> wrote in message news:7tirgg$k5o$1@news.xmission.com... > > Hi Folks! Hi there ! > > We intend to run a small DatawareHouse on a NT Compaq Machine; it is > still with one Pentium III Processor, 256 Mb RAM; about 30 users running an > ERP Soft, and some 5 other running some select queries..heavy ones. > When we had about 2 users running these queires the performance was > OK, but now with 5-6 users, all performance, including the ERP system, is > very poor.. > I know i must add another processor, but while it does not come, what > would be better? > > Set oninit priority to high/real time in NT task manager? > Add another CPU VP in Onconfig? For 1 CPU you must have SINGLE_CPU_VP=1, NUMCPUVPS=1. > Set Noage to 1? This won't help - it's not Unix :)). > > Task Manager ; > CPU-->100% > Memory --> 265 Mb used Post your ONCONFIG and onstat -p,-F,-R,-l output for some analysis. --------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285