Speed Problem While Posting

vikram7_dabasvikram7_dabas Member Posts: 611
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
Vikram Dabas
Navision Technical Consultant

Answers

  • krikikriki Member, Moderator Posts: 9,112
    SQL or Navision DB?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • vikram7_dabasvikram7_dabas Member Posts: 611
    it is the SQL DB
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    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)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vikram7_dabasvikram7_dabas Member Posts: 611
    SORRY ITS THE Navision DB
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vikram7_dabasvikram7_dabas Member Posts: 611
    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?
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    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)?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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.
    David Singleton
  • vikram7_dabasvikram7_dabas Member Posts: 611
    please tell me that what is cache commit,where it is situated and from where it will be switched on
    Vikram Dabas
    Navision Technical Consultant
  • slmaluwaslmaluwa Member Posts: 366
    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.
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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. :mrgreen:
    David Singleton
  • vikram7_dabasvikram7_dabas Member Posts: 611
    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
    Vikram Dabas
    Navision Technical Consultant
  • vikram7_dabasvikram7_dabas Member Posts: 611
    this commit cache should be ON on the server or on all the clients
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    this commit cache should be ON on the server or on all the clients
    On the server.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vikram7_dabasvikram7_dabas Member Posts: 611
    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 .
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    Than go back and read my first answer. Forget about the commit cache. It is not used on MS SQL option...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vikram7_dabasvikram7_dabas Member Posts: 611
    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
    Vikram Dabas
    Navision Technical Consultant
  • kinekine Member Posts: 12,562
    Are you reading all answers? I will not repeat what I wrote... [-(
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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. :mrgreen:
    David Singleton
  • DenSterDenSter Member Posts: 8,307
    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.
Sign In or Register to comment.