Speedup performance of database

jannav

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.

kapamarou

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

[Topic moved from 'NAV/Navision' forum to 'SQL Performance' forum]

jannav

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

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

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.

jubeljoy

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.