Nav 2009 Sql 2005 Performance is very Low for huge Data

kishore_rokkam
kishore_rokkam Member Posts: 5
edited 2010-05-02 in SQL General
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...

Comments

  • stryk
    stryk Member Posts: 645
    Hi kishore_rokkam,

    welcome to MIBUSO.com :D

    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
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories