Large Navision SQL DBs

cnicola
cnicola Member Posts: 181
edited 2006-02-06 in NAV/Navision Classic Client
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. ](*,)
Apathy is on the rise but nobody seems to care.

Comments

  • kauffmann
    kauffmann Member Posts: 56
    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.
    A good programmer makes al the right mistakes
    My blog
  • kine
    kine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,121
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • beetlestone
    beetlestone Member Posts: 46
    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.
    Darren Beetlestone

Categories