Unfortunately, this is not a simple proposition nor is it cost free. Another approach is to distribute the load on the resources such that the peaks are somewhat flattened. This would reduce the problem of contention and allow the system s resources to act within their limits. Here are some suggestions as to how this may be accomplished. Run reports outside of peak periods.
People do most of their updating and viewing of data during the day when they are in the office.
If you run reports near the end of the day, the system will likely have more available resources. Use the Job Scheduling function when submitting reports to have them placed in the processing queue in the evening. Use the RPT reporting instance for viewing and reporting and leave the live AMS system for critical data entry. Run reports in the background. The bottom line is, clicking the button to execute a job interactively will place a greater strain on system resources than running a job in the background.