mibuso.com
Home› NAV/Navision Classic Client

Poor Performance 3.7 Urgent!!!

PEzechielsPEzechiels Member Posts: 83
edited 2006-05-25 in NAV/Navision Classic Client
Hi,
A customer of mine has recently upgraded to 3.7 and they are experiencing a very poor performance .
It takes about 20-30 seconds just to generate a lookup.
Salary processing takes up to 12 hours.
The cache on the clients is already 18000kb.

Server specs:
Operating System: Microsoft Windows Server 2003 (5.2,build 3790)
ServicePack 1
System Manufacturer: Hewlett-Packard
System Model: HP Netserver
BIOS: Default System BIOS
Processor: Intel(R) Pentium(R) III processor, ~1.0GHz
Memory: 768MB RAM.

Can somebody shed some light as to what can cause this poor performance?

Thnx in advance

PEzechiels

Comments

  • jsrarkjsrark Member Posts: 50
    Have you changed the disk configuration?
    Is the poor perfromance at the workstation or also on the server?
    What is the spec. for the workstation?
    Are you running C/Side or SQL?
  • PEzechielsPEzechiels Member Posts: 83
    Have you changed the disk configuration?
    No we haven't changed the disk configuration.

    Is the poor perfromance at the workstation or also on the server?
    The poor performance is at the workstation.

    What is the spec. for the workstation?
    The workstation which was running the salary processing is a PIII,192MB

    Are you running C/Side or SQL?
    C/Side
  • kinekine Member Posts: 12,562
    192MB of RAM on client is Minimum... And if you need to do big processing like you described, you need RAM to have big Cache... and you need enough free space on your disk for temp files.

    You can watch the CPU and Memory utilization in task manager...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PEzechielsPEzechiels Member Posts: 83
    But even if there's no processing going on the performance is still bad.
    20-30 seconds for a lookup is very bad
  • kinekine Member Posts: 12,562
    20-30seconds - if there are FlowFields and you set some filter to this flowfield, you can have BIG performance problem... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PEzechielsPEzechiels Member Posts: 83
    [-X No flowfield Kine
  • kinekine Member Posts: 12,562
    Than you need to watch:

    1) CPU, RAM, HDDs activity on client and on server.
    2) Network performance

    You wrote that "The cache on the clients is already 18000kb. " What does it means? 18000kb is 18MB - it is not big... :-)

    How big is the cache on your Navision DB server?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PEzechielsPEzechiels Member Posts: 83
    cache on Navision DB server = 200MB

    What would you suggest please? :cry:
  • mvlietmvliet Member Posts: 22
    a few pointers:

    - how is the performence if you run a client on the navision server ?
    - how much stress do the disks and CPU have on the server ?
    Imtech Dynamics Solutions
  • PEzechielsPEzechiels Member Posts: 83
    how is the performence if you run a client on the navision server ?
    havent tried that yet
    - how much stress do the disks and CPU have on the server ?

    cpu usage server 2-3%
  • GoMaDGoMaD Member Posts: 313
    Can you tell us on which version of 3.70 the customer is running (3.70, 3.70A, ...)

    some performance tips:
    1. use the commitcache property (commitcache=yes)

    2. Max memory usage (when the navision service is running there should be around 200MB of memory available to the OS, can be seen in the taks manager of the server, tab Performance, look under Physical Memory (K), all the rest can be assigned to server.exe of navision with the cache property)

    Other tips will follow
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • PEzechielsPEzechiels Member Posts: 83
    Customer is running on 3.70
    commitcache = yes

    How can i assign the rest of the memory to the server without re-installing?
  • GoMaDGoMaD Member Posts: 313
    the mmc plug in for navision server to change the cache size
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!
  • SavatageSavatage Member Posts: 7,142
    I used Navision Database Server Setup Wizard v1.01
    http://www.mibuso.com/dlinfo.asp?FileID=304

    :D

    NaviServer Manager v1.1
    http://www.mibuso.com/dlinfo.asp?FileID=273
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • themavethemave Member Posts: 1,058
    It almost sounds like the keys were not re-activated, a lot of times during an upgrade the keys are de-activated to make the restore faster. Worth checking out

    good luck
  • Alex_ChowAlex_Chow Member Posts: 5,063
    PEzechiels wrote:
    Hi,
    A customer of mine has recently upgraded to 3.7 and they are experiencing a very poor performance .
    It takes about 20-30 seconds just to generate a lookup.
    Salary processing takes up to 12 hours.
    The cache on the clients is already 18000kb.

    Server specs:
    Operating System: Microsoft Windows Server 2003 (5.2,build 3790)
    ServicePack 1
    System Manufacturer: Hewlett-Packard
    System Model: HP Netserver
    BIOS: Default System BIOS
    Processor: Intel(R) Pentium(R) III processor, ~1.0GHz
    Memory: 768MB RAM.

    Can somebody shed some light as to what can cause this poor performance?

    Thnx in advance

    PEzechiels

    This hardware setup sounds pretty slow for a Navision server. Depending on your database size and the number of users, you definately want a fast machine as a server. The faster the machine, the better your performance.

    With Navision, a lot of work is done on the server level, especially with the newer versions of Navision where resource usage is a lot higher than Navision 2.x.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • PEzechielsPEzechiels Member Posts: 83
    Guys thnx for all the replies.

    Ok Where can i find the MMC plugin for navision financials?
    The keys are activated.

    The database size is about 2.5 Gb.
    No. of users : 20 of which 2 or 3 do alot of processing at the end of the month.
  • SavatageSavatage Member Posts: 7,142
    deadlizard wrote:
    This hardware setup sounds pretty slow for a Navision server. Depending on your database size and the number of users, you definately want a fast machine as a server. The faster the machine, the better your performance.

    our first machine was a PIII - we upgraded to a Xeon & doubled the mem.

    It's like Night & Day MY adjust cost report went from 3 hours to 15 mins.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
Sign In or Register to comment.