Nav 2009 Sql 2005 Performance is very Low for huge Data

kishore_rokkam

Hi to all,

We upgrade the Nav4.0 Sp1to 2009 sp1 the problem the SQL db size is 40gb if i open Navision any item form or any table which having data its taking much time. For ex in ledger Entry Dimension we having 61lakhs records it is very Very slow.At the same time before upgradation 4.0 is fine. Can u help me how to increace the perfomance Sql Nav 2009.I done Optimization, Rebuild index in sql even though same problem...Pls help regarding this issue...

stryk

Hi kishore_rokkam,

welcome to MIBUSO.com

Well, NAV/SQL performance is actually a permanently discussed matter, so I'd like to suggest to search MIBUSO for "SQL Performance" - I'm sure you would get gazillions of useful advices and receommendations.

Performance troubles could have many many reasons, e.g. involving ...
... Hardware/Platform
... used Versions & Editions (OS, SQL, NAV)
... Configuration & Maintenance
... C/AL code and business processes
... etc.

If you could share more details about specific problems you might get more specific answers.

Kind regards,
Jörg