How to calculate Navision SQL database size by each table?

wpcwpc Member Posts: 14
edited 2004-05-14 in Navision Attain
Dear all, :lol:

I am current working on a prospect who may use Navision for the accounting, inventory, sales and purchase operations. Attached please find the sizing information collected from the prospect and appreciate your advise if there is any ballpark estimation for the hard disk requirement or should there be any sizing tools to do the sizing exercise. Thanks million in advance for your great help.

For example:
1. Number of customer 180 records
2. Number of Sales Order per month 700 records
3. Average number of line items per sales order 30 records
4. Number of Sales Invoice per month 650 records
5. Average number of line items per invoices 30 records

Many thanks!

Comments

  • WaldoWaldo Member Posts: 3,412
    Please check the download section. There is a database sizing tool available:

    http://www.mibuso.com/dlinfo.asp?FileID=346

    May be it can help you.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • wpcwpc Member Posts: 14
    Hi Waldo,

    Thank you for your suggestion.
    Yeah! I done it, hope this prospect can close soon.

    Have a nice day!

    Regards,

    WPC :wink:
Sign In or Register to comment.