Speed Problem While Posting

vikram7_dabas

My problem is that there is our one client,there r 20 users when they r posting the sales invoice then the speed of the server becomes very slow please give me the appropriate solution.this is challenge for me.me waiting 4 ur reply.please help me yaar

kriki

SQL or Navision DB?

vikram7_dabas

it is the SQL DB

kine

In this case I recommend to read the posts about performance on this forum and watch the video with webcast about NAV performance on SQL from Hynek Mulbacher (see download section)

vikram7_dabas

SORRY ITS THE Navision DB

kine

In this case we need to know more informations about the system: number of HDDs, their configuration (which RAID, how they are connected, how are divided), DB configuration (how many files, which size, where are placed) etc.

vikram7_dabas

my question was that when 20 users are working at the same time and 1 of them is posting the sales invoice then the other 19 user's speed becomes very slow.there r 6 HDD,2 of them r in RAID in the server.The HDD are divided into 3 and 3.THE SPACE IS ABOUT 450GB and the RAM is 12GB.The size of the database is 90 GB.Now please any body give me the solution.i m in the critical stage.please also tell me that is there can be any key problem?

kine

there r 6 HDD,2 of them r in RAID in the server.The HDD are divided into 3 and 3

If I decrypt this correctly:

You have 2 RAID arrays with 3 HDDs each (I assume RAID 5 in this case)?

David_Singleton

vikram7_dabas wrote:

my question was that when 20 users are working at the same time and 1 of them is posting the sales invoice then the other 19 user's speed becomes very slow.there r 6 HDD,2 of them r in RAID in the server.The HDD are divided into 3 and 3.THE SPACE IS ABOUT 450GB and the RAM is 12GB.The size of the database is 90 GB.Now please any body give me the solution.i m in the critical stage.please also tell me that is there can be any key problem?

It sounds like you have wasted money on ram and large hard drives instead of building a Navision server.

For this database, you need about 20 drives for the database. These should be configured as 10 sets of RAID 1. split that database up as 10 9gig parts over these drives.
Ram needs to be a max of 1.5 gig, with 1 gig allocated to Navision, the rest is just wasted, Make sure Commitcache is switched on.

vikram7_dabas

please tell me that what is cache commit,where it is situated and from where it will be switched on

slmaluwa

Here is the text from Navision Help file about CommitCache:

Commit Cache
The disk is the slowest part of a PC and the time it takes for the PC to write to the disk can give the user the impression that the program is slow because the screen is not updated quickly. To improve this situation, Navision has a function called commit cache. This function ensures that write transactions are completed as soon as the data is logically present in the database. That is, before it is physically written to the disk (or read from the disk - this works in both directions). The write transactions remain in the commit cache until there is no other activity on the physical disk, or until the commit cache is filled up. Then the transactions are written to the physical disk.

From within the application, you can click File, Database, Information and see whether commit cache has been turned on or off (a check mark in the Commit Cache field means that it is turned on).

To change this setting, click Tools, Options and the Options window appears.

The next time you start the program, the new setting is valid. You can read more about this in the manual Installation and System Management: Microsoft Business Solutions–Navision Database Server.

David_Singleton

vikram7_dabas wrote:

please tell me that what is cache commit,where it is situated and from where it will be switched on

Vikram, the client is relying their business on their ERP system, as there partner, you really need to make the effort to read all the manuals. On your install CDs, there are a number of PDF files. You really need to read them and know them like the back of your hand. Your customer is relying on you haveing this knowledge.

Not that I have anythign against finding out stuff on "the net", but the starting point always needs to be RTFM.

vikram7_dabas

there commit cache is on until then there speed is very slow ihave read all the pdfs until then the problem is not solving.please tell me that what i have to do.help me in this situatuion

vikram7_dabas

this commit cache should be ON on the server or on all the clients

kine

vikram7_dabas wrote:

this commit cache should be ON on the server or on all the clients

On the server.

vikram7_dabas

our client have sql database not the Navision database my mistake firstly i told u that they have Navision Database.in the sql database i didnt find any commit cache option.help me i dont know that what i have to do .

kine

Than go back and read my first answer. Forget about the commit cache. It is not used on MS SQL option...

vikram7_dabas

my client is not using the Navision database they r using the sql database and there is no option of commit cache in server as well as in client also.help me

kine

Are you reading all answers? I will not repeat what I wrote... [-(

David_Singleton

vikram7_dabas wrote:

our client have sql database not the Navision database my mistake firstly i told u that they have Navision Database.in the sql database i didnt find any commit cache option.help me i dont know that what i have to do .

Mark is sitting back reading this and singing...

"We're In The Money, We're In The Money"

[-o< [-o< [-o< [-o<

Actually he is more likely on the phone to the BMW dealer to tell them that he is buying a Ferrari instead.

DenSter

Vikram, please get your lead involved. You obviously don't know where to find these things, and this is hurting your customer. Find someone that does know, before you do serious damage.