How to calculate Navision SQL database size by each table?

wpc
Member Posts: 14
Dear all, 
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!

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!
0
Comments
-
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.0 -
Hi Waldo,
Thank you for your suggestion.
Yeah! I done it, hope this prospect can close soon.
Have a nice day!
Regards,
WPC0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions