Large Navision SQL DBs

cnicola

Hey guys,

I have a client that currently has a 3.60 SQL db of 140Gb and growing several GBs a month. They have about 30-40 concurrent users (I actually mean people always in the system. Not necessarily always doing something ).
We are having some issues with general performance and locking.
I know it is a complex issue but I am beginning to question whether this size is getting towards the limit of what Navision can handle efficiently.
So was wondering if there is anyone out there with DB of this size or much bigger and if so whether you are willing to share some of your hardware layout and any experiences you may have had ...
Any information if very much appreciated.

P.S. I am aware of the issues related to locking and SQL and that is what I am working on now. But even when not locked it is still pretty slow so I am wondering what hardware is needed or if Navision is still suitable at this kind of sizes. ](*,)

kauffmann

Yes, I know a (Dutch) company using a Navision C/SIDE database of ca. 450GB, with more than 100 concurrent users. They are moving to SQL right now, after thourough testing at an IBM lab in Montpellier, France.

However, I don't know if they are willing to share their hardware layout and test results since they payed a lot for it.

What I can say here is that Navision seems to be able handle such a large SQL database.

There is also a some very useful documentation available at Microsoft about tuning the Navision SQL environment.

kine

Navision can be as fast as fast is the HW (server and client). If something is too slow, there are two issues: locking (wait time) and HW overload (latch wait time, CPU wait time, slow network, problems on network, low memory...) And of course, optimizing indexes (keys) is one part of the problem too, because you can lower the system load when writing data, you will have shorter lock time and faster system... But do not forget - good HW and good setup of the HW is the base together with optimized keys.

kriki

One of the posts (there are so many) that can help for performance on SQL is
http://www.mibuso.com/forum/viewtopic.php?t=7235

Try also searching the forum for "sql performance". You will get more answers than you want.

beetlestone

Yes, I know a (Dutch) company using a Navision C/SIDE database of ca. 450GB, with more than 100 concurrent users. They are moving to SQL right now, after thourough testing at an IBM lab in Montpellier, France.

Could someone please confirm that it is possible to use a database greater than 264GB when using the Native server v3.60. Even the Microsoft site says that this limit applies.