mibuso.com
Home› NAV/Navision Classic Client

Navision performance is VERY slow

AvendraAvendra Member Posts: 13
edited 2006-08-10 in NAV/Navision Classic Client
Hello, we have a production Navision database server running Navision 4.0 (SP1). The database size is just under 50 GB. SQL 2000 SP3. Users are constantly complaining of slow performance, but the server shows no signs of activity. It's a huge Compaq server with 4 proc, 4 GBs or RAM etc.. Yet users say certain tasks take several minutes to complete. I've tried having users Terminal Server onto the desktop of the Navision server and running the client from there...same performance rate.

Is there anything we can do to increase performance?

Thanks for any help here..

Brian

brian.virts@avendra.com

Comments

  • ara3nara3n Member Posts: 9,257
    It's been a long time Avendra
    Me and another developer did all the development in 2.6 version. It looks like you've upgraded. I never found out why you guys switched NSC. Anyways, We had developed your system so that orders get posted at night. Has this been upgraded from the original 2.6 version? There are a lot of other things that can be done improve performance, especially with SIFT and indexes. I would contact your NSC and get in touch with a developer who has SQL experience. Also how ofter are your reindexing your keys? It should be done on weekly basis. Also what kind of RAID have you setup on server? What processes take a lot of time? Have you thought about deleting and shrinking the ledgers? Search the forum. There are couple of threads that will help you a lot on making changes to your setup to improve performance.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AvendraAvendra Member Posts: 13
    Hi ara3n, yes we have upgraded the application a couple times and did a recent upgrade of the db to 4.0. Do you still do this type of work, or can you direct me to a local vendor who could come onsite, do analysis and recommend steps to better performance?
  • ara3nara3n Member Posts: 9,257
    The first thing I would do is get SP2 client with the hotfix from MS website. SP1 has a clustered index bug, which makes all the PK unclustered. I have to see what the NSC agreement says about working for other solution center clients. I'll see if our Account Manager will contact you.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AvendraAvendra Member Posts: 13
    Great, can I just update the client to SP2? Does anything need to be updated in the database?

    Have them shot me an email. thanks!

    brian.virts@avendra.com
  • ara3nara3n Member Posts: 9,257
    yes you can update just the client to SP2 make sure you get the hotfix as well. The hotfix fixes an issue with reports cutting right margin. When you connect the first time to db, the client will ask you if you want to upgrade the server, click yes and you are done. Make sure you upgrade all the clients.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AvendraAvendra Member Posts: 13
    I'm getting mixed reviews on the SP2 client. Is this a guaranteed performance booster? Even if my customization and SQL aren’t tuned? I’ve heard this might even make things run slower. Please point me to the download files. I can’t find them at Microsoft. Do I have to upgrade everyone at the same time?
  • Alex_ChowAlex_Chow Member Posts: 5,063
    If your performance is extremely slow, then it's probably not caused by standard Navision coding.

    If your performance issue began after the upgrade, then it's probably caused by using incorrect keys on modifications that is ported over to 4.0.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • NobodyNobody Member Posts: 93
    There was a issue with 4.00 SP1 that if you created a new database it was missing all the clustered indexes. This would cause huge performance issues. This is simple to check just open up enterprise manager and choose a table like Value Entry and make sure it has a clustered index. If not there was a fix released to correct this.

    Just a thought.
  • DenSterDenSter Member Posts: 8,307
    Have you done INDEXDEFRAG? UPDATESTATS? Is your transaction log backed up?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • AvendraAvendra Member Posts: 13
    Nobody wrote:
    There was a issue with 4.00 SP1 that if you created a new database it was missing all the clustered indexes. This would cause huge performance issues. This is simple to check just open up enterprise manager and choose a table like Value Entry and make sure it has a clustered index. If not there was a fix released to correct this.

    Just a thought.

    I don't have a Value Entry table.
  • ara3nara3n Member Posts: 9,257
    Then you didn't actually upgrade, you just did an excecutable upgrade. Look at any other table. Item Ledger Entry.
    Here is the link is
    https://mbs.microsoft.com/partnersource/downloads/releases/microsoftbusinesssolutionsnavision40sp2.htm?printpage=false
    Make sure you also download the hotfix. Also when what the last time you reindexed your keys?

    Go to File->Database->Information->table
    Select all the tables and lick on optemize. This will take a couple of hours so do in after hours.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.