Navision Database Sizing Tool

The Navision Database Sizing Tool (NDST) is designed to give estimates of database growth in order to assist in planning hard disk requirements. The tool can be used, either to make estimates for new implementations, or to make forecasts for database growth for existing implementations.

NDST can be used for either Database option for Navision (Native or SQL).

The NDST will only give you estimates. The results it gives can only be regarded as guidelines to how much your database will grow. Exact database growth depends on a lot of customer specific factors. No two customers will have the exact same record sizes, or create the exact same number of new records pr order. Database growth depends on factors such as:
1) Application areas used. A few examples: Customers using Warehouse Management will create additional records such as Picks, Putaways, Warehouse entries etc; if the customer uses Analysis Views, then this will add to database growth; synchronizing contacts with customers will add to the space used, etc.
2) Working practise. The more fields you enter in a record, the more space it will take up. A customer who enters all information (maybe including comments) on all records will use more space than a customer with the same number of records, who only enters basic information.
3) Record Size is based on the size of the table compared to the number of records in that table. The size of a table includes indexes (keys). So record sizes will be affected by the number and size of indexes.

NDST contains:
- DBSizingWorksheet.xls
- NDST.fob
- SpaceUsed.sql
- Navision Database Sizing Tool.doc