Monday, September 05, 2011 4:21 AMI am using Microsoft Navision ERP Software which runs on SQL Server Native Client (by default) and option to change to SQL Server. So I am using SQL Server 2008 Standard edition. There is a process is called Adjust Cost in Navision which pick the Item from item master table(40,000 records) one by one matches entry from Item Movement (11Lacs records) and Cost from Value entry table(12 lacs records) and calculate average cost and update each entry of that item value in Value Entry table by Average Cost.
So If I run this process using backend SQL Server Native Client then it takes around 10hrs to complete but If I run this process on SQL Server 2008 then it is taking around 40hrs to complete. So basically I am trying to find out where is the problem.?
- Edited by Nitesh aggarwal Monday, September 05, 2011 4:26 AM
- Edited by Sethu SrinivasanMicrosoft Employee Thursday, August 30, 2012 5:32 PM Microsoft Navision ERP Software
- Moved by Sethu SrinivasanMicrosoft Employee Thursday, August 30, 2012 5:32 PM Microsoft Navision ERP Software (От:SQL Server Application and Multi-Server Management)
Tuesday, September 06, 2011 11:41 PMHave a read of the following discussion http://dynamicsuser.net/forums/p/33564/176573.aspx
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Monday, November 07, 2011 9:05 AM
We still have issues with Adjust cost. We are not able to solve the problem and now the process is taking almost 3-4 days to run.
In case any body has some solutions , please let us know.
Thanks in advance,