I would like to solicit your opinion on our Baan server setup as we are currently facing
performance issue especially on Sales Invoicing, Service Invoicing and Generating Projects
from Sales Order. On a bad day a single invoice can take up to 3 minutes to print. We have
around 250 users. Baan 4C4 SP20 app and database (SQL Server 2000 Enterprise SP4) is in the same Server. We have
windows 2003 Enterprise Edition R2 SP2. We have 24 GB RAM. We have four dual-core Intel Xeon
processors. SAN-connected. We have 125 GB database used. We are also heavy users of SQL
Reporting Services and have job running on Intergratio Package in early morning. We use
Taxware. Our CPU utilization could come up to 96% in the middle of the day. We do experience
better speed in the morning and late afternoons when there are less users.

2. Printing normally has to deal with writing in tmp . If tmp is not cleared for quite some time , then printing / login etc can be slow .

3. As u use reporting service , u may not be using baan reporting substantially . Still check if u have lot of disk based data transformations used in Baan reporting and Baan proceses for summarizing / compressing data and such reports / programs run regularly daily .If yes , then u can speed up the system by using memory based algorithms in such reports / programs.

4. What is the number of records in invoicing related tables like tdsls040/1/5/50/1 , tsssma tables and number of customers u talk about . Is there possibility to archieve such sales data to archieve company . That will definitely improve the performance of invoice printing.

5. Do u have large number of companies . If yes , do u share tables for modules which arenot used e.g. we did not used tp , tr modules . We shared all such tables . So in our case , for each new company the number of tables created at db level were only 500 as against 2500 . DB catalogue size greatly reduces with table sharing (of course without compromising functionality ) .

6.What is the make up ntbshell , mslsqldriver and reporting services in overall server load . mssql and reporting services are resource intensive and not releasing the resources when needed . Is it possible to reduce the allocations of memory / cpu resourses so that more resources are available to ntbshell.

7. Run TSQLs to get most time consuming SQL in runtime in enterprise manage at the time of peak loads.