Microsoft Navision ERP Software - SQL Server 2008 Performance Issue

Question

I 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.?

---

Nitesh

Answer 1

Have a read of the following discussion http://dynamicsuser.net/forums/p/33564/176573.aspx

---

Jeff Wharton
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

Answer 2

Hi jeff,

 

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,

 

vishal

---

Vishal Thakur