Performance - NAV 3.7

sujatharaoosujatharaoo Member Posts: 57
edited 2009-03-06 in SQL Performance
Hi,

One of our client is using Dynamics Nav 3.7 (HF(IN) – 5IN, HF(WW) -19 ) in SQL Server 2000. There are 85 Licenced users.When concurrent users posting the Transactions(Order,Invoice) we face Stand still situation in the application. Can u help me to solve this?

Thanx in Advance. :D

Regards,
Sujatha
Regards,
Sujatha.N

Comments

  • kapamaroukapamarou Member Posts: 1,152
    IMHO you need to study the documentation, search this forum and come back with specific questions.

    There are many things involved like:

    Hardware setup, SQL setup, Table Optimization, Indexes Used, Code Optimization, Locking order and so on...

    You will need to understand all of these issues involved.

    Are you an End-User, a Developer, an administrator??
  • sujatharaoosujatharaoo Member Posts: 57
    I am a developer. How to check the indexes in Navision Application? what steps required to do this ? any PDF's Availabale for this ?can u help me?

    Thanx in advance.
    Regards,
    Sujatha.N
  • sujatharaoosujatharaoo Member Posts: 57
    Hi,

    We have Checked for Hardware Configuration,Sql Setup, and Locking order. How to proceed with Table Optimization, and Code Optimization?

    Thanx in Advance.
    Regards,
    Sujatha.N
  • kapamaroukapamarou Member Posts: 1,152
    We have Checked for Hardware Configuration,Sql Setup, and Locking order.
    Thanx in Advance.

    What do you mean you have checked? Have you checked with the Microsoft documentation and with this forum to see what you need to do?

    Table optimization is:

    1: File -> Database -> Information -> Tables -> Optimize (Just a button that if you press drops and recreates indexes)

    2: Disabling keys and sumindexes not used...

    3: Code optimization is identifying areas where the code caused delays and /or locking order issues and changing that code
  • sujatharaoosujatharaoo Member Posts: 57
    Hi,

    How much time it will take to optimise the tables in 18GB Database, and to reindex in SQL2000 for the same size of the database? can anyone suggest?



    Thanx in Advance
    Regards,
    Sujatha.N
  • krikikriki Member, Moderator Posts: 9,094
    That depends largely on your hardware (especially no. of disks and their configuration).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • sujatharaoosujatharaoo Member Posts: 57
    Hi,
    Hardware Configuration
    Application Version: Microsoft Dynamics Nav 3.7 (HF(IN) – 5IN, HF(WW) -19 )
    Database Version: SQL Server 2000 (No service Pack)
    Processor: Dual Processor.
    Ram: 4 GB
    Hard Disk : 200GB
    Database Size: 18GB


    Thanx in advance
    Regards,
    Sujatha.N
  • krikikriki Member, Moderator Posts: 9,094
    I wrote "no. of disks" and not "no. of GB" :wink:

    First and for all I would upgrade SQL to the latest SP and hotfix. SQL2000 has some performance problems with cursors (and NAV uses those a lot) that are fixed in SP4.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • sujatharaoosujatharaoo Member Posts: 57
    hi kriki,

    Thanx for the Suggestion.
    Regards,
    Sujatha.N
Sign In or Register to comment.