Performance - NAV 3.7

sujatharaoo
sujatharaoo 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

  • kapamarou
    kapamarou 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??
  • sujatharaoo
    sujatharaoo 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
  • sujatharaoo
    sujatharaoo 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
  • kapamarou
    kapamarou Member Posts: 1,152
    sujatharaoo wrote:
    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
  • sujatharaoo
    sujatharaoo 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
  • kriki
    kriki Member, Moderator Posts: 9,121
    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!

  • sujatharaoo
    sujatharaoo 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
  • kriki
    kriki Member, Moderator Posts: 9,121
    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!

  • sujatharaoo
    sujatharaoo Member Posts: 57
    hi kriki,

    Thanx for the Suggestion.
    Regards,
    Sujatha.N

Categories