Performance Issues - Nav v4.0 SP3

• 09-23-2008 2:41 AM

  Gary Lucas Joined on 08-01-2008 Posts 4

  Performance Issues - Nav v4.0 SP3 Reply Contact Morning Everyone!  Thought I would write to see if there is anything we can do to speed up our Navision system which seems to suffer from chronic performance issues despite good hardware being in place. We are desperatley trying to source information on various maintenance issues that we should be carrying out as well as the tuning of SQL 2005. There seems to be many companies out that at present that seem to sell products on the back of this problem which offer unprecidented gains of performance etc, but I do wonder whether this just seems to be a very "get rich quick" scheme for them as it seems like Nav has always had performance issues due to it's history and the move to SQL Server from older database engines.  We seem to always be told that the next version will have all of the whilstles and bells and greater performance but we continually seem to be let down by all this. Our establishment uses MS Nav to run it's entire business and it does seem such a shame that no one wants to give the information necessary to allow us to tune our system for it's best performance without charging thousands for someone to look at it. It is a shame we do not have the resources to employ or hire an SQL DBA but even if we did it doesn't necessarily mean that he/she could manage to sort these issues out.  I wonder if anyone else experiences the same sort of issues and what they have done to push things forward into fathoming out a solution. I am happy to provide any statistics necessary to allow any professionals that may roam the forums to give their advice. Will I only experience silence from this posting or is this really a place for help and discussion?  Kind Regards GCB

  Tags: NAV, Navision, Dynamics NAV, training, sql option, Business Analytics+Navision 4.0+SQL Server 2005

• 09-23-2008 9:41 AM

  In reply to

  DaveT Joined on 03-21-2008 Posts 51

  Re: Performance Issues - Nav v4.0 SP3 Reply Contact Hi Gary,  There are always a number of factors to improve performance and I see from your other post that your SQL is clustered.  This leads to a more complex envoirnment. You are correct you can spend big bucks on consultants and not get what you want if you cannot identify what the problems. What I recommend is to read: "The NAV/SQL Performance Field Guide" which should be available via Amazon, etc. http://www.amazon.de/Performance-Guide-Trouble-Microsoft%C2%AE-Dynamics/dp/3837014428/ref=sr_1_1?ie=UTF8&s=books&qid=1197564359&sr=1-1 2. Edition (Version 2.02) ISBN: 978-3-8370-1442-6 136 Pages (Paperback, English, b/w), 15,90 EUR Printed & Published by "Books on Demand"   which will give you enough background to engage with consultant (if necessary). This is only €16 ~ £10-12 so not a big investment. Hope this helps.   Dave Treanor Dynamics Nav Add-ons www.simplydynamics.ie/Addons.html

• 09-24-2008 2:55 AM

  In reply to

  Gary Lucas Joined on 08-01-2008 Posts 4	Re: Performance Issues - Nav v4.0 SP3 Reply Contact  Hi DaveT  Thanks for the information, we've managed to track the book down on amazon.co.uk so we'll have a read of it and let you know how we get on. I notice it is written by the same person who runs a very good website all about Nav performance so should be an informative read.   Many Thanks Gary

• 09-24-2008 1:35 PM

  In reply to

  DaveT Joined on 03-21-2008 Posts 51	Re: Performance Issues - Nav v4.0 SP3 Reply Contact Hi Gary,  Glad to help. Dave Treanor Dynamics Nav Add-ons www.simplydynamics.ie/Addons.html

• 10-13-2008 1:17 AM

  In reply to

  Gary Lucas Joined on 08-01-2008 Posts 4

  Re: Performance Issues - Nav v4.0 SP3 Reply Contact  Well I received the book and although it is incredibly informative not being a huge expert on SQL means it's a little above me. I am currently evaluating the ExpandIT Table Optimizer but I don't think that the cost really justifies the purchase as it really just executes keyboard macros using a scheduler so as part of our monthly tasks I shall be doing this manually.  We are currently optimizing some of our tables which have over 50,000 records which sees the size of the database decrease nicely I see out of interest that the book states that optimizing all tables isn't a good idea as it turnes the tables into a Sub-Optimal Nav Condition, unfortunatley it doesn't say which ones shouldn't be done.   With Regards, GCB

• 10-13-2008 1:26 AM

  In reply to

  Kine Joined on 03-21-2007 Posts 6

  Re: Performance Issues - Nav v4.0 SP3 Reply Contact  Hello Garry,  you can find many information about the performance problems on sources like www.mibuso.com, where you can download video from webcasts done by Hynek Muhlbacher. I recommand to watch this video, because it will give you overview of what can be the problem. In points: 1) SIFT 2) Indexes 3) Suboptimal code (wrong loops leading to misuses cache etc.) 4) Wrong HW and SW configuration But it is hard to help you  just through the forum. Optimizing NAV on SQL needs good know-how and this is not cheap. It is why all are offering the help for some cost. For free you can get some information, but it is not all what you need...