Epicor Database Growth Forecast Calculator
Disks fill slowly and then all at once. This calculator projects database size from daily transaction volume, the rows each transaction writes, row width, index overhead and annual growth, then multiplies by the copies you keep so storage budgets are realistic.
Your numbers
Labor, inventory, order and GL transactions combined.
Include history, audit and log tables that each transaction touches.
Your results
Rough sizing from averages. Measure real table growth with SQL Server size reports and include log files, attachments and tempdb separately.
Projected database size vs years
Sweeps Forecast horizon from 1 to 10, holding your other inputs fixed.
Database sizing and archive review
Optional: we can look at your table sizes and suggest archive and index options.
Optional. The tool and every export work without this. No spam.
How to use it
Estimate daily transactions across labor, inventory, orders and journals. Count the rows each one writes, including history and audit tables. Enter an average row size and index overhead from your own table sizes, a growth rate and a horizon. Add your current size and how many copies exist for backups, pilot and test. The tool gives projected size and total storage.
- Use sp_spaceused or the largest tables report to get real row sizes.
- Count attachments and document storage separately.
- Include the copies that consume your SAN or cloud bill.
The formula
Year one added data equals transactions times 365 times rows per transaction times row size times one plus index overhead, divided by bytes per gigabyte. With annual growth g, the sum over the horizon follows a geometric series, which is g to the power of years minus one, divided by g minus one. Add the current size, then multiply by the number of copies.
Reading the result
Growth compounds, so a modest rate matters over five to ten years. The chart shows the projected size curve to help you time storage purchases or decide when to archive. If one or two tables dominate, an archive or purge policy for old history may cut the curve more than buying disks, provided you keep what auditors and customers need.
Common mistakes
Forgetting transaction log and tempdb space, not counting pilot or test copies and assuming index overhead is zero all understate needs. Another is purging without legal review of retention rules. Check backup size and restore time too, because a database that is easy to store may still be too large to restore inside your recovery window.
Frequently Asked Questions
What index overhead should I use?
Compare table data size to index size in SQL Server reports for your biggest tables. Sixty percent is a placeholder, and the real figure varies from table to table, especially if many custom indexes were added.
Does this include attachments?
No. Attachments and documents are often stored outside the database or in separate stores. Estimate them separately so they are not hidden in the transaction forecast.
Should I plan for the cloud differently?
Cloud storage is billed continuously, so copies and retention have a direct monthly cost. Use the horizon and copies fields to compare lease terms or storage tiers, and confirm limits with your provider.
Can I archive old data in Epicor?
Options depend on your version and tools, and any purge needs testing and business sign-off. Involve finance and compliance before removing history, and validate reports after the archive.
Netray can analyse your largest tables and recommend archive options. The forecast works fine without us.
Related Tools
Epicor BAQ Runtime and Row Volume Estimator
Model how filters, joins and indexes change the rows a BAQ reads and the seconds it takes, before you publish it to users.
EpicorEpicor DMT Data Load Time Calculator
Plan DMT load windows by combining record counts, throughput, error rates and fix time into total hours.
EpicorEpicor REST API Paging and Throughput Calculator
Estimate how long an Epicor REST extract takes for a given page size, latency and concurrency, and find the sweet spot.
More Epicor tools
See all- Epicor Kinetic Customization Change Request Form Template
- Epicor Kinetic Go-Live Cutover Plan Template
- Epicor Kinetic User Access Request Form Template
- Epicor Kinetic BPM Directive Inventory Worksheet
- Epicor Kinetic Scheduled Task Register Worksheet
- Epicor Kinetic Custom Report Inventory Worksheet
- Epicor Kinetic Data Migration Mapping Worksheet
- Epicor Kinetic Data Load Effort Calculator
- Epicor Business Object Services Reference
New to Epicor ERP? Start with the Epicor ERP guide and toolkit, or plan with Training Path Builder, ERP Certification Study Planner, Upgrade Path Planner.
Keep exploring
Free tools
- Epicor Kinetic Database Tables ReferenceLook up the main Erp.* tables in Epicor Kinetic with what each holds and the columns that identify a row. Useful when writing BAQs and SQL.
- Epicor Kinetic AI Assistant Sizing and Value CalculatorEstimate GPUs, vector index size, hours saved and payback for a private AI assistant on Epicor Kinetic on-premises.
- Epicor Kinetic Data Load Effort CalculatorEstimate total data migration hours for an Epicor project from record counts, error rate and number of test cycles.
ERP fixes and how-tos
- Parts Not Showing Demand in Epicor Kinetic: Forecast, Planning BOM and Time Fence ChecksWhy demand is missing in Epicor Kinetic MRP: forecast entry, planning BOM, time fence settings, release dates, and capable to promise, with a check list.
- Convert Epicor Classic Dashboards to KineticHow to convert Epicor Classic dashboards to Kinetic during an upgrade: what carries over, what must be rebuilt, and how to verify each dashboard.
- How to Add AI to Epicor Kinetic On-Premises Without Moving Your DataReference architecture for a private AI assistant on Epicor Kinetic on-premises: BAQ and REST v2 access, SQL replica, local LLM, roles, audit and rollout.
AI on your ERP
- Private AI for Epicor Kinetic Cloud, Outside the Multi-Tenant BoundaryRun a private LLM on Epicor Kinetic private cloud or Kinetic Cloud data via BAQs, REST v2 and Data Fabric, keeping sensitive manufacturing data off shared AI.
- AI for Epicor Kinetic Job Shops: Quote History, Job Variance and Schedule RiskPrivate AI for Epicor Kinetic job shops: quote-to-job history, JobHead and JobOper variance, subcontract delays and schedule risk, via REST and BAQs.
Integrations
- How to add AI agents to Epicor KineticHow to add AI agents to Epicor Kinetic: a tool layer over the REST v2 API and BAQs, MRP exception triage, PO expediting, and human approval before any write.
- How to add an AI chatbot to Epicor KineticAdd an AI chatbot to Epicor Kinetic: an internal assistant for planners and buyers or a customer portal bot, grounded in BAQs and runnable fully on-prem.
Software
- Epicor KineticEpicor Kinetic explained for manufacturers: modules, REST API, BAQs, deployment, strengths, limits and alternatives to compare before choosing or upgrading.
- Epicor CPQEpicor CPQ is a cloud configure-price-quote product with visual 3D configuration for manufacturers. Modules, ERP integrations and alternatives explained.