Controlling database size

Databases whose size is monitored and minimized show increased performance: database operations require less I/O and fewer CPU resources; view rebuilding and updating is quicker; and memory and disk space allocation is improved.

For databases at ODS 53 or higher, the maximum database size is 256GB on Microsoft Windows and UNIX. Otherwise, the maximum size is 64GB.

Use the following methods to minimize and monitor the size of databases:

  • Compact databases
  • Set database size quotas to prevent databases from growing beyond a specified size
  • Delete inactive documents using the document archiving tool or using agents
  • Set database performance properties that also reduce database size
  • Use replication settings to limit the size of a replica by replicating to it only what's necessary
  • When limiting the contents of a replica, decrease the database purge interval to remove deletion stubs more often
  • Disable the default user activity recording in databases
  • Disable soft deletions in databases