Are you getting frustrated with slow reports, climbing storage costs, and that sinking feeling that your database is becoming an expensive digital hoarder?
You’re not alone. 64% of Australian SMBs report database performance issues as they grow, and many are shocked to discover they’re paying AUD $55 per GB for extra database storage when they hit their limits.
Here’s the thing: Business Central’s compression features can cut your database size by 40-60% and dramatically improve performance. But most SMBs don’t even know these features exist.
Let me show you exactly how to transform your sluggish system into a lean, mean business machine.
For expert guidance tailored to Australian SMBs, visit Work Made Simple (WMS).
Every invoice you create, every transaction you process, every report you run adds data to your system. Over time, this creates a perfect storm:
Sound familiar? This is where Business Central's compression arsenal comes to your rescue.
What it does: Business Central Online automatically compresses your table data using advanced algorithms without you lifting a finger.
The magic: This feature runs behind the scenes, achieving 40-60% database size reduction while actually improving query performance. It’s like having a professional organizer constantly tidying your digital warehouse.
Real impact: A Melbourne manufacturing company reduced their database from 45GB to 18GB, saving over $1,400 annually in storage costs alone.
What it does: Consolidates historical transaction records (older than 5 years) into summary entries while maintaining accuracy.
The breakthrough: Instead of storing 2 million individual General Ledger entries, you get clean monthly or yearly summaries. Your financial reports run 20-40% faster, and auditors still get all the detail they need.
Australian advantage: Perfect for businesses approaching their BAS reporting deadlines – compressed data doesn’t slow down those critical tax calculations.
What it does: Moves older documents and records to compressed storage while keeping them instantly accessible within Business Central.
The brilliance: You satisfy Australian compliance requirements for document retention, but your day-to-day system stays lightning fast. Export archived data to Excel or CSV anytime for analysis.
Game-changer moment: When auditors come knocking, you can pull up any historical document in seconds, not hours.
What it does: Automatically deletes unnecessary log files, temporary data, and outdated records based on rules you set.
The relief: No more manual cleanup tasks eating up your IT time. Set it once, and it runs every night at 2AM, keeping your database lean.
Perfect for: Job queue logs that can balloon to millions of useless entries. One policy change, and you’re back to a streamlined system.
What it does: Provides a unified interface where you can manage compression, deletion, and archiving tasks without jumping between screens.
The convenience: See exactly what’s taking up space, apply retention policies, and run compression jobs from one location. Even non-technical team members can manage basic database housekeeping.
For businesses considering custom solutions, wmsit.com.au offers comprehensive custom ERP development services specifically designed for Australian businesses, with deep understanding of local compliance requirements and market dynamics.
| Myth | Reality |
|---|---|
| Compression will slow down my system | Compression actually improves performance by reducing I/O operations |
| I’ll lose important historical data | All data is preserved — compression creates summaries while archiving originals |
| It’s too technical for my team | The Data Administration wizard guides you through every step |
| Compression is only for huge enterprises | SMBs see the biggest impact — 40–60% database reduction is common |
| I need expensive consultants | Most features are automatic or require simple configuration |
The Challenge:
A high-volume Australian business was managing large SKU counts and transaction volumes that had grown over years of operation. Their Business Central database had ballooned — daily processing was taking up to 11 hours, and store replenishment alone was consuming 4 hours every day. The system was not broken — it was drowning in its own historical data.
The WMS Approach:
Work Made Simple WMS deployed a structured Business Central database compression and performance tuning engagement:
The Results:
“This is the kind of performance transformation that does not require a new ERP system — it requires the right expertise applied to the system you already have.”
— Work Made Simple (WMS)
Australian businesses are required by the ATO to retain financial records for a minimum of 5 years — and in some cases up to 7 years for CGT assets. Business Central compression does not delete records — it summarises and condenses them while preserving all totals, balances and audit trail data required for ATO review.
Specifically, compression preserves:
What compression does NOT preserve:
ATO record-keeping requirements
Microsoft learn.microsoft.com — compression and audit trail
Microsoft Dynamics 365 Business Central on the cloud includes a base storage allocation per environment. As your database grows beyond this allocation, Microsoft charges for additional storage — billed in AUD through your Microsoft agreement.
| Database Size | Typical Annual Storage Cost (AU Cloud) | Post-Compression Estimate | Annual Saving |
|---|---|---|---|
| 100 GB | ~$1,200–$2,400 AUD | ~$480–$960 AUD (60% reduction) | ~$720–$1,440 AUD |
| 500 GB | ~$6,000–$12,000 AUD | ~$2,400–$4,800 AUD | ~$3,600–$7,200 AUD |
| 1–5 TB | ~$12,000–$60,000 AUD | ~$4,800–$24,000 AUD | ~$7,200–$36,000 AUD |
At WMS , we’ve guided over 200 Australian SMBs through Business Central optimization. Our clients typically see:
We know the unique challenges Australian businesses face – from BAS reporting deadlines to seasonal cash flow pressures. That’s why we’ve developed a proven process that gets your compression features working perfectly without disrupting your operations.
Visit our Business Central optimization page to see detailed case studies and implementation guides.
Every day you delay implementing these features costs you money and productivity. Your database is growing, your storage bills are climbing, and your team’s frustration is building.
Ready to transform your Business Central performance? Book a free 30-minute consultation where we’ll:
Assess your current database size and compression opportunities
Show you exactly which features will deliver the biggest impact
Provide a customized implementation roadmap for your business
DM us or call today – let’s turn your sluggish system into the competitive advantage it should be.
Your future self will thank you for taking action today.
Get started with WMS. Business Central expertise and join the growing number of Australian SMBs running lean, fast, and profitable operations.
Summarises historical closed-period data to reduce database size, improve performance and cut cloud storage costs — without removing data needed for ATO compliance
Slow reports, longer posting times, growing cloud bills and extended month-end close are the four key warning signs
No — compression preserves all ledger balances, tax summaries and period totals required for ATO audit and BAS reconciliation. Drill-through to individual transactions from compressed periods is removed
Typically 40–60% of historical data volume — as demonstrated in WMS client engagements. For multi-terabyte databases, this translates to significant annual cloud storage savings
After closing and finalising each fiscal year — once the period is audited and no further adjustments are needed
Compression is largely irreversible without restoring from a pre-compression backup. This is why a full backup before compression is mandatory
Compression summarises data within the live database; archiving moves data out of the live system entirely. Both reduce active database size but serve different purposes — see our archiving guide for detail
Yes — compression jobs can be scheduled via Business Central’s Data Administration page or through automated scripts configured by your Microsoft partner
When planned and executed correctly, compression can be performed with no downtime to business operations. WMS has compressed multi-terabyte databases without interrupting live operations
Work Made Simple (WMS) is a certified Microsoft Dynamics 365 Business Central partner in Australia with direct experience compressing large-scale BC databases. Contact us for a free compression assessment.
