Performance - NAV 3.7

sujatharaoo

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.

Regards,
Sujatha

kapamarou

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

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.

sujatharaoo

Hi,

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

Thanx in Advance.

kapamarou

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

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

kriki

That depends largely on your hardware (especially no. of disks and their configuration).

sujatharaoo

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

kriki

I wrote "no. of disks" and not "no. of GB"

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.

sujatharaoo

hi kriki,

Thanx for the Suggestion.