Bad performances upgrading Navision to release 4.0 SP1

fedepol

Hello everybody,
I've upgraded Navision from release 2.60 to Navision 4.0 SP1 on SQL Server database. All procedures, in particulary the posting, are very slow. I try to optimize some keys, to change some properties like MantainSQLIndex, but the result doesn't change. I also didn't understand very well how to corretcly set this properties...

Can someone gives me an idea?

Thanks in advance for all........

Federica

kine

1) You need to understand, that 4.00SP1 is slower, because need to do more work than 2.60 (mainly posting dimensions, creating detail entries etc.)

2) You are not talking about HW. Please, specify your HW, DB size, user count...

3) You can read more about the optimalizations and properties connected to this in Troubleshooting guide which is on the MBS Tools CD

bestianhow

yes, i agree with Kamil Sacek.
Navision 4.01 really of checking, especially in posting area.
The hardware also another concern.
Can you give more information regarding your hardware and database size?

jjanauskas

nav 4.00 SP1 seems having a performance issue on SQL server. I noticed about that at http://www.mibuso.com/forum/viewtopic.php?p=41548#41548

ara3n

There is also another problem with SP1. There are no Clustered keys in any table. Pervious to SP1 the primary key was the clustered key by default. With SP1 none of the keys are clustered. This is horrible for performance. This is suppose to be fixed in SP2. For right now you have rebuild your keys weekly, or Go at least through you Ledgers objects and assign a clustered key to a good key. Regards.

DenSter

You can ask MS for a script that sets the primary keys to clustered in the mean time. That was what was suppoed to have happened anyway.

Waldo

Can't you give us the script, or make it available in the downloads-section? Partnersource is down at the moment ](*,) .

DenSter

I don't have the script myself. I'll see if I can find it though.