Optimization Problem

Mally
Mally 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

  • KTA8
    KTA8 Member Posts: 399
    you must have a maintenance plan
  • Mally
    Mally Member Posts: 128
    dear concern
    sorry I didnt understand what do u mean by maintanance pla?
  • kine
    kine 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.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!


  • Mally
    Mally 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?
  • jubeljoy
    jubeljoy 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