Navision 4.0 SP3 is very slow in one company only

mohsin

i am facing problem in 1 of our company data a database consist of 6 companies of navision, 1 company is facing slowness while opening gl total field in chart of accounts, any solution to the prolem.

Savatage

If using sql check the sql performance forum here at mibuso.

with the limited information provided it's impossible to answer your question.
we can speculate all day without server or system specs.

stryk

As Harry suggested, you should search the forum about "SQL Performance" and you'll get gazillion of advices and reccomendations!

With NAV 4.0 SP3 there's a high chance that basically the SIFT management is causing trouble; check out this one:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx

Of course, there are probably many more things to be discussed, but for this you need to provide more background information about your system.

kriki

[Topic moved from 'Navision Financials' forum to 'SQL Performance' forum]