Speedup performance of database

jannav
jannav Member Posts: 15
edited 2009-09-10 in SQL Performance
Hi,

We are a Navision customer for 4 years and started with the classic version and are now using the 5.0 SQL version. We do most of our development ourselves (just changing/creating reports). Our database is growing by the minute with on average 400/500 orders a day (5/20 lines).

Are there consultants we can help with speeding up this database?, tips? as we expect our the production to grow the coming years. Our hardware seems not to be a problem because if we analyse the OS/SQL performance logs the harddisks have time to spare. We are thinking about the 2009 version, maybe it's faster.

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    I'm sure many among us are able to help, but we'll need plenty of info. For example where exactly is your performance poor?
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision' forum to 'SQL Performance' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • jannav
    jannav Member Posts: 15
    Well during the posting of an order, itemlines, warehouse lines are created. This can lockout some users if 6 users are typing in orders.

    Our partner talked about transferring this procedure to a batched process. Do you think SQL can handle 30.000 lines a day this way? We are considering changing the posting process but would like to here some working solutions.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    jannav wrote:
    Are there consultants we can help with speeding up this database?, tips?

    If you mean "free forum advise" then there are many people on MiBuSo that can help you, but I would recommend that first you start searching (use key words SQL Navision performance ) to get an idea of what questions you need to ask.

    If you mean that you are looking for a specialist that specializes on Tuning Navision databases on SQL and want to pay for professional services, then your best options are Mark Brummel and Jorg Stryk.


    By the way, you need to get over the concept that you don't have a hardware issue. I have worked on many performance issues on Navision systems over the best part of 2 decades, and NEVER in my life have I seen 100% a correctly configured server for Navision*** when I was called in because of a performance issue.



    *** PS: Of course if the customer didn't have problems I wouldn't have seen it, so I assume most are configured correctly, but when there is a performance problem there is almost always a hard ware issue as a part of the problem.
    David Singleton
  • David_Singleton
    David_Singleton Member Posts: 5,479
    jannav wrote:
    Well during the posting of an order, itemlines, warehouse lines are created. This can lockout some users if 6 users are typing in orders.

    Our partner talked about transferring this procedure to a batched process. Do you think SQL can handle 30.000 lines a day this way? We are considering changing the posting process but would like to here some working solutions.

    With a correctly configured system, Navision should handle posting 50,000-100,000 lines per day out of the box.
    David Singleton
  • jubeljoy
    jubeljoy Member Posts: 154
    This can be solve by following methods
    Better first you optimize your database first. For that just go to the following link that will give you and idea about how to optimize the data.http://microsoft-dynamics-nav.blogspot. ... ion%20Slow
    Also you check out which user is locking your table by some procedure for that go to following link
    http://microsoft-dynamics-nav.blogspot. ... ion%20Slow

    Another case is that some of the user may use less configuration systems so that will take more time to execute things, so system will lock others table until thats over.
    Jubelhttp://navisionplanet.com

Categories