DBMS Cache Size

Frekie

Hey - According to Attain's documentation the maximum DBMS Cache equals 1 GB. Also according to this document it is user related (anything between 8 and 20 MB per user). Does that implies that there is a restriction on the users say somewhere between 125 and 50 ?
More over why is there such a restriction ? Is it related to Attain ? Has anybody tried to set it higher ?

Thanx ;-)

Waldo

We are talking about the Navision Database Server. It can only use 1 processor and 1 Gb of RAM. That's why it isn't powerful enough for +50 users. In that case, it is recommended that you use the SQL Server Option, since it can use multiple processors and more the 1 Gb RAM ... plus its management of concurrent users is much more efficient.

It isn't possible to assign more than 1 Gb DBMS Cache (you get an error message).

Hope this answers your question(s) ...

eromein

Per 1 GB of database size you have to assign 20 MB memory. Add 4 to 12 MB per user. Depending on how heavily this user is using Navision. This is according to documentation from Navision.


It's not an answer, but it's a little nuance.

So say you have a Database of 2 GB.

1024 MB – 40 MB (2 x 20MB) = 984 MB

984 MB / 8 MB (Average per user) = 123 Users. (should be unless I'm mistaken.)