Navision performance is VERY slow

Avendra

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

ara3n

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.

Avendra

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?

ara3n

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.

Avendra

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

ara3n

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.

Avendra

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_Chow

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.

Nobody

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.

DenSter

Have you done INDEXDEFRAG? UPDATESTATS? Is your transaction log backed up?

Avendra

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.

ara3n

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.