Determining Space Requirements
Overview
The following space requirements must be determined for the Controller and its database.
Controller Space Requirements
The Universal Controller war file is approximately 110MB compressed and 200MB uncompressed, using a total of approximately 310MB of space when fully deployed.
However, the space requirements for the Controller are driven largely by logging. Logging requirements are based on the log levels selected in the Log Level and Platform Log Level Universal Controller system properties.
A minimum 2GB of space is recommended for logging and other operations that require the Controller file system, such as bulk (and list) import/export.
The Log File Retention Period in Days Universal Controller system property lets you specify the number of days that a Controller log file (and an Agent log file) is retained before it is purged. The default is 5 days.
Database Space Requirements
Each type of database software (MySQL, Microsoft SQL Server, Oracle) takes up different amounts of space. However, the space required for saved Controller data is the same; that is, for example, 1,000 tasks consume no more space in MySQL than they do in Oracle.
Calculating Space Requirements
Following the initialization of the Controller database, the initial table space size will be approximately 60MB.
Based on calculations using data from all task types, each Controller task instance consumes approximately 10KB of database space. You should estimate space requirements for your data based on your expected number of task executions per day and the duration for retaining history and activity data before purging.
Output Retrieval
An Agent always caches output. Output is stored in the database only if you do one or more of the following:
- Select Automatic Output Retrieval for a task.
- Create Email Notifications with output attachments for task.
- Retrieve output for a task instance.
A retrieved output file of 1K (for example) will require 2KB to 2.5KB of space in the database.