Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Database Optimizatio in NAV 2009
sakameeran
Member Posts: 52
Dear Experts,
We have some clarification / support / guidance on Microsoft Dynamics NAV Database Optimization,
1) Our Current Microsoft Dynamics NAV database size is around 250GB, due to this huge database size we are facing issue with Backup Management System / Performance. Even it is increasing every month 10 GB (approx.).
2) For reducing the database size shall we use “NAV Optimize option” (File-> Database ->Information -> Tables ->Optimize)? Is this the best solution? Is there any impact after in using this optimization activity?
3) For your information, we made a test database base and did this optimization activity and reduced the database size from 250GB to 180GB (around 70 GB reduced).
4) Expecting your valuable suggestions / advise / solution.
Thanks
Regards,
S.A.K.Ahamed Meeran
We have some clarification / support / guidance on Microsoft Dynamics NAV Database Optimization,
1) Our Current Microsoft Dynamics NAV database size is around 250GB, due to this huge database size we are facing issue with Backup Management System / Performance. Even it is increasing every month 10 GB (approx.).
2) For reducing the database size shall we use “NAV Optimize option” (File-> Database ->Information -> Tables ->Optimize)? Is this the best solution? Is there any impact after in using this optimization activity?
3) For your information, we made a test database base and did this optimization activity and reduced the database size from 250GB to 180GB (around 70 GB reduced).
4) Expecting your valuable suggestions / advise / solution.
Thanks
Regards,
S.A.K.Ahamed Meeran
0
Comments
Another good place is start reading posts here:
viewforum.php?f=34