SugarCloud Managed Storage Limits
Sugar's cloud service includes a managed storage allowance based on your subscription level. This article summarizes the data allowances, explains the major factors that contribute to an instance's storage usage, and offers suggestions on how to reduce the amount of storage occupied by your instance.
Note: This article pertains only to disk space limits for instances hosted on Sugar's cloud service. For help estimating and managing storage for an on-site instance, please refer to the Uploads documentation in the Developer Guide and the Sugar On-Site Sizing Guide.
Customers with instances hosted in Sugar's cloud environment are subject to file system (FS) and database (DB) storage limits and sandbox limits depending on the product(s) (e.g., Sugar Serve) their organization has purchased from SugarCRM. The maximum data storage allowance for your SugarCloud subscription encompasses the database and files belonging to the main production instance plus any of your Sugar-hosted test instances (i.e., sandboxes). SugarCloud customers can monitor their instance's file system and database storage usage via Admin > SugarCloud Insights.
For more information on the file system and database storage allowances for each Sugar product (e.g., Sugar Serve) and how the managed storage gets calculated, refer to the SugarCloud Policy Guide and this SugarClub blog post. For more information regarding the sandbox limits for each product, refer to the SugarCloud Sandboxes page.
When the amount of managed storage used by a customer exceeds the storage capacity allocated by their Sugar subscription, additional storage fees will apply. For more information, refer to the SugarCRM Master Subscription Agreement.
This section summarizes the major factors that contribute to an instance's storage usage.
All of the records and relationships in your Sugar instance are stored in its database and contribute towards the instance's space quota. Scheduled jobs in Sugar will automatically purge unnecessary items such as backend database entries and deleted records to prevent clutter from occupying space in your system.
Both emails and their attachments will contribute toward your disk allowance. Emails that are imported and stored in Sugar (i.e. "archived") contribute to the database volume, and the messages' attachments are stored in the file system. For instances hosted on Sugar's cloud service, users may archive email messages as large as 10MB including attachments. When users upload email attachments directly to Sugar through the user interface (opposed to via email archiving), those files may be as large as 32MB or the limit specified in Admin > System Settings. For more information on limiting the permissible size of uploads, please refer to the File Upload Limits section below.
Documents and Contracts
The Documents and Contracts modules in Sugar are repositories for file uploads that need to be shared within your organization. Each time a user creates a new document or contract record, they usually upload an accompanying file attachment. The upload files are subject to the default 32MB limit or the limit specified in Administration > System Settings. For more information on limiting the permissible size of uploads, please refer to the File Upload Limits section below.
Note records in Sugar may also include attachments. Sugar stores the attached files in the
./uploads folder. By default, file uploads may be as large as 32MB or the limit specified in Administration > System Settings. For more information on limiting the permissible size of uploads, please refer to the File Upload Limits section below.
Module Loader Packages
Sugar stores any upgrade packages, installable modules, customizations, or connectors that have been uploaded via Module Loader in the
./uploads folder. As a best practice, free up additional space by uninstalling uploaded files that are no longer needed.
Managing Your Storage Usage
Schedulers control the behind-the-scenes processing and automation tasks in your Sugar instance. Some of the system actions that are run by schedulers can help you manage disk space usage by removing unnecessary artifacts from the database. Ensure that cron is running and the following schedulers are active and running at appropriate intervals:
- Prune Database on 1st of Month : Permanently removes deleted records from the database
- Prune Old Record Lists : Cleans the backend database entries that Sugar uses when generating export files
- Prune Tracker Tables : Removes old tracker records
- Remove Diagnostic Tool Files : Removes temporary files from the
- Remove Temporary Files : Removes unused files from the
- Remove Temporary PDF Files : Removes temporary files from the
For each of the above schedulers, confirm that the Status field is "Active" and the Last Successful Run field is populated appropriately relative to the expected interval:
If you find that one or more schedulers are not running as expected, please refer to the Troubleshooting Cron and Schedulers article.
Also, if you have any customizations, talk with your developer about any custom database tables which may grow very large over time. As a best practice, developers should include a custom scheduled job in the package to periodically prune the size of this database.
File Upload Limits
When users perform uploads to file-type modules like Notes and Documents, Sugar's cloud service prohibits files that are larger than 32MB. For email attachments, Sugar's cloud service prohibits the cumulative size of files attached to the message to exceed 32MB.
Administrators may choose to further restrict this limit via the Maximum Upload Size setting in Admin > System Settings. In the case of a conflict between the server-defined limit of 32MB and the admin-defined limit, the lower number will prevail. By default, the application's Maximum Upload Size setting is set to 30000000 bytes, which is equivalent to 30MB, so the default upload limit will be 30MB on a fresh SugarCloud instance.
To reduce the impact of file uploads on your instance size, simply reduce the application's Maximum Upload Size setting. For example, to reduce the limit from the default 30MB to 20MB, set the Maximum Upload Size to "20000000".
Please note that this setting can only be used to lower the maximum file size below 32MB, not increase the limit above 32MB. Sugar's cloud service limit of 32MB will supersede a Maximum Upload Size value higher than 32000000 (i.e. 32MB). For more information on system storage options, please refer to the System documentation.
Last modified: 2022-05-16 17:54:23