Optimization Problem

Mally
Member Posts: 128
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?
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?
0
Comments
-
you must have a maintenance plan0
-
dear concern
sorry I didnt understand what do u mean by maintanance pla?0 -
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"?0
-
[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!0 -
Dear concern
I only want to know that what'll happen to DB when I opimized DB? What r benefits and disadvantages?0 -
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 know0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions