How to setup service MBSN 4.0

bsuspect

We just have made an upgrade from 2.60 to 4.0.
Now some performance problems appear. Most problems were solved by changing keys and filters.

Now I´ve tried to start the server service on a 2003Server with a higher DBMS Cache. The starting like the 2.60 service with cache=xxx in the service start-window wont work.

How can a start the service eith a bigger cache?
Do I have to change the priority of the service too?
What cache settings are useful for the clients?
Any other settings to increase performance?

-Native database on Dual-Xeon CPU Server with 2GB RAM and Win2003 Standard-Server.

kine

1) Do not use more than 700MB of cache
2) if it is Dual Xeon does not matter, because Native DB is able to use only one CPU... (you can say of caurse in this case that the second CPU is for OS)
3) critical point of performance are HDDs. You said nothing about this...

DenSter

Navision is just not capable of using more than 1GB of RAM with the native database server, and I think effectively it can only use 700-800MB.

There is a file called "w1w1ism.pdf" in the doc folder of your product cd. This document has all the parameters that you can use to start up or to reconfigure the database server.