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
- 298 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
Performance decline.....!!???
kash387
Member Posts: 111
Hi to all experts......!!!
I am wondering on one problem I am facing at my client site......!!
NAV 2009: Classic with SQL Server 2005
My client was facing problem related to Inventory Application, i discussed with client and my superiors too, and the solution was to remove the application and reapply the Inventory transactions.
I designed processing only report, and did the re-application. I confirmed the total quantity and remaining quantity figure, location wise for each item.
Now, after this, the problem aroused with Transfer Order Posting.
When user attempts to post Transfer Shipment, system is taking too long for it.....!!
The order that was taking 30 seconds for 600 lines, now taking 30 minutes. Ofcourse, I have not touched any part of standard-code for posting routines.
Can anybody guide me what steps shall I take to increase performance at previous level.....!!
All suggestions will be welcomed..........!!!
Thanks and Regards,
Kashyap
I am wondering on one problem I am facing at my client site......!!
NAV 2009: Classic with SQL Server 2005
My client was facing problem related to Inventory Application, i discussed with client and my superiors too, and the solution was to remove the application and reapply the Inventory transactions.
I designed processing only report, and did the re-application. I confirmed the total quantity and remaining quantity figure, location wise for each item.
Now, after this, the problem aroused with Transfer Order Posting.
When user attempts to post Transfer Shipment, system is taking too long for it.....!!
The order that was taking 30 seconds for 600 lines, now taking 30 minutes. Ofcourse, I have not touched any part of standard-code for posting routines.
Can anybody guide me what steps shall I take to increase performance at previous level.....!!
All suggestions will be welcomed..........!!!
Thanks and Regards,
Kashyap
Thanks,
Kashyap
Kashyap
0
Comments
Do the reindexing in SQL and check for the performance.
that may help. :thumbsup: