Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 295 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 5 SP1 Order Planning Calculate Plan
ferrysb
Member Posts: 14
Hi All,
Please help,
- I'm using Nav 5 SP 1 North America (NA) Version.
- SQL Server 2005.
- DB Size ndf file : 633Mb
mdf file : 45 Mb
log file : 1.4 Gb
I'm using Order Planning --> Calculate Plan. It takes a very long time to finish the Calculate Plan.
1. on my Local PC / Local SQL server: It needs 3.5 hours to run the Calculate Plan.
2. on User's PC / Local SQL server, it run for more than 10 hours, and not yet finished ( seems some bottleneck is happened, because the source is used 100% on task manager ).
3. tried on CRP Server, it runs around 5 hours ( 70% only ).
Overall, it takes unusual time to finish the calculation. And during this time, all sales/item/production related table is locked, so user can't do any work on Navision.
- Currently we have around 2300 Production Order ( range from 2003 from 2009 ), around 100 Sales Order. No customization on Calculate Plan related codeunit.
- I have "Dynamic Low-Level Code" = NO, and I already run the calculate low level code activity.
- The Low level code on BOM are ranged between 1 - 6, and i think the maximum is 8. I just review it quickly from the table.
- I also did SQL optimization : the index defrag or re-index.
- Only 1 user connected to the SQL Server.
- CPU Usage is showing 100%, when processing the Calculate Plan.
Please help to advise.
Thank you.
Please help,
- I'm using Nav 5 SP 1 North America (NA) Version.
- SQL Server 2005.
- DB Size ndf file : 633Mb
mdf file : 45 Mb
log file : 1.4 Gb
I'm using Order Planning --> Calculate Plan. It takes a very long time to finish the Calculate Plan.
1. on my Local PC / Local SQL server: It needs 3.5 hours to run the Calculate Plan.
2. on User's PC / Local SQL server, it run for more than 10 hours, and not yet finished ( seems some bottleneck is happened, because the source is used 100% on task manager ).
3. tried on CRP Server, it runs around 5 hours ( 70% only ).
Overall, it takes unusual time to finish the calculation. And during this time, all sales/item/production related table is locked, so user can't do any work on Navision.
- Currently we have around 2300 Production Order ( range from 2003 from 2009 ), around 100 Sales Order. No customization on Calculate Plan related codeunit.
- I have "Dynamic Low-Level Code" = NO, and I already run the calculate low level code activity.
- The Low level code on BOM are ranged between 1 - 6, and i think the maximum is 8. I just review it quickly from the table.
- I also did SQL optimization : the index defrag or re-index.
- Only 1 user connected to the SQL Server.
- CPU Usage is showing 100%, when processing the Calculate Plan.
Please help to advise.
Thank you.
0
Comments
If you have in MF setup "Dynamic Low-Level Code"=NO then you have to use "Calculate Low Level Code" activity - That may help a little (or huge)
What is the biggest value of "Low-Level Code" in all BOM's?
Time of plan - It's all about Levels of BOM's.. Less levels less time. Sometimes one more level can add huge amount of time.
Hi JedrzejT,
thx for your reply.
yes, i have "Dynamic Low-Level Code" = NO, and I already run the calculate low level code activity.
The Low level code on BOM are ranged between 1 - 6, and i think the maximum is 8. I just review it quickly from the table.
Anybody know some fine-tune I can do for the codeunit of Nav5SP1, to speedup the process ?