Optimization Problem

MallyMally Member Posts: 128
edited 2009-09-09 in SQL General
Dear Concern
I m using Navision SQL database.My DB size is more than 80GB.I want to optimized the DB.If I'll optimize DB, then what will happen to my DB?I'll face any problem after Optimizing DB?

Comments

  • KTA8KTA8 Member Posts: 397
    you must have a maintenance plan
  • MallyMally Member Posts: 128
    dear concern
    sorry I didnt understand what do u mean by maintanance pla?
  • kinekine Member Posts: 12,562
    SQL DB needs maintenance - it means regular re-indexing (defragmenting), SIFT tables maintenance, statistics updates etc. It is not just about "press a button"... And one question - what do you expect from the "optimization"?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • krikikriki Member, Moderator Posts: 9,112
    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • MallyMally Member Posts: 128
    Dear concern
    I only want to know that what'll happen to DB when I opimized DB? What r benefits and disadvantages?
  • jubeljoyjubeljoy Member Posts: 154
    I think following link that will give you a clear idea about data base optimize in Navision easily
    http://microsoft-dynamics-nav.blogspot. ... ion%20Slow
    Anything more let me know
Sign In or Register to comment.