ACUMATICA

Acumatica System Maintenance

February 17, 2024 • 12 min read

Introduction

Regular system maintenance is crucial for Acumatica performance and stability. This guide covers essential maintenance tasks and best practices.

Database Maintenance

Keep your database optimized:

  • Index Rebuilding - Rebuild fragmented indexes
  • Statistics Update - Keep statistics current
  • Archive Old Data - Move historical data to archive tables
  • Clean Up Logs - Remove old log entries

Routine Maintenance Tasks

// Schedule these tasks:

1. Daily:
   - Monitor error logs
   - Check disk space
   - Verify backups

2. Weekly:
   - Database index maintenance
   - Review performance metrics
   - Clean temporary files

3. Monthly:
   - Full database statistics update
   - Review security logs
   - Audit user accounts

Monitoring & Health

Monitor key system metrics:

  • Database size and growth
  • Transaction log size
  • Application server response time
  • User session count
  • API call volumes

Backup & Recovery

// Backup Strategy:

1. Full Backup: Daily
   - Database
   - Files
   - Customizations

2. Transaction Log: Every 15 minutes

3. Configuration: Weekly
   - Site settings
   - Email settings
   - Integration configs

4. Testing:
   - Monthly restore tests
   - Document recovery procedures

Summary

Regular maintenance prevents issues and keeps Acumatica running smoothly. Implement a maintenance schedule and monitor key metrics.

For more guides, see Performance Tuning.