Report "Inventory Valuation"

Rene70
Rene70 Member Posts: 25
edited 2006-09-26 in NAV/Navision Classic Client
Hi,

we made the change from native database to SQL-Server two weeks ago.
Up to the point of change the report "Inventory Valuation" needed about 45 minutes for calculation.
When I'm starting the report now it needs round about 18 hours.

Is there a solution for this problem? Is there some else, who has this problem too?

We are using finsql.exe 4.0 SP2 and Navision 3.70b Code

I looked into the 4.0 SP2 original programm code, but for this report, no changes were made. So I think this is still a problem when we would make an update.

Thanks for help

René

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    My guess is that there is a index problem on the value entries but it is very hard to tell without monitoring the process.

    SQL Tuning can be very timeconsuming.
    Marije Brummel | Freelance Business Central Specialist
  • Rene70
    Rene70 Member Posts: 25
    OK that might be. Is there someone out there, who has no problems with this report on an SQL-Server? :-k

    From the code of the report I cannot imagine that.
  • Captain_DX4
    Captain_DX4 Member Posts: 230
    Mark Brummel wrote:
    My guess is that there is a index problem on the value entries but it is very hard to tell without monitoring the process.

    SQL Tuning can be very timeconsuming.

    It appears that the report can be timeconsuming as well. *grin, duck*
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • Captain_DX4
    Captain_DX4 Member Posts: 230
    Rene70 wrote:
    OK that might be. Is there someone out there, who has no problems with this report on an SQL-Server? :-k

    From the code of the report I cannot imagine that.

    I was working recently for a company in Hamilton, Canada, where we were attempting to upgrade their Navision backend to SQL as well. We were informed by Microsoft to use SQL2005 with NAV 4.00b executibles. The code was the old v2.60 code. The installation there is quite large (120GB native database) and that particular report always seemed to run a bit longer anyways. But one key thing that Microsoft suggested was the SQL2005 to eek out some more speed from your system.
    Kristopher Webb
    Microsoft Dynamics NAV Developer

Categories