From C/Side Database to SQL Database

Hauke_Amend

Hello,

we have heavy blockages in our C/Side database.
By profing the availability of our products we have theses
blackages. Also by making offers and searching for
products. The user must wait a few seconds til several
minutes. We now this is a "bad" quality in the database
from navision, but is the Update to SQL the solution?
Are there disadvantages in using SQL?

craigbarbs

If the database is running very slow, there are other things you could try before changing to SQL. Have you checked your DBMS cache? The installation manual says that you should assign 12 mb per user.

bostjanl

craigbarbs wrote:

If the database is running very slow, there are other things you could try before changing to SQL. Have you checked your DBMS cache? The installation manual says that you should assign 12 mb per user.

I think that 12 MB that manual is refering to are "normal" RAM. That is amount of RAM, that server is useing for handlig one user session.


bostjanl

bostjanl

Hauke Amend wrote:

Hello,

we have heavy blockages in our C/Side database.
By profing the availability of our products we have theses
blackages. Also by making offers and searching for
products. The user must wait a few seconds til several
minutes. We now this is a "bad" quality in the database
from navision, but is the Update to SQL the solution?
Are there disadvantages in using SQL?

User are blocked? Cheking availability and searching are read-only operations, so no locks should happend.

What text do user get in their status line:
-object XXX locked by
-searching table ....

If you get first text, than locking is problem, but if you get the second text, than you should look if you use proper keys,..


Bostjanl

craigbarbs

While I agree that you should check that you are using correct keys, I would just like to point out that manual is actually referring to the amount of cache that is required.

The availability windows are using flowfields. If you are processing many transactions and you cache is too small, you will have performance issues.

Hauke_Amend

We have a DBMS Cache of 300MB. We can use 100 Users. Normaly
we have 60-75 Users online. Object cache on the clients ist 8 MB.

Waldo

So you have about 70 users online. Then, the DBMS cache is indeed too low. You should increase this, for starters.

Can you please give us full details? What is your complete server configuration, (+ RAID configuration), size of the databasefile, how much was the standard navision-code modified, ... .

Hauke_Amend

To find out if the Hardware is working well, we made the Performance Net Test.

Attain database Installation Manuell Side. 143.

There is a value writen of 1.220.065,00 Packets (100 byte) per second.
Is this reachable? We have
1.301,00 Packets (100 byte) per second.