We are having an issue where several of our Crystal Reports are taking over 10 minutes to run and need to figure out why.
Platform: Windows Server 2008 R2, Quad 2.70 Xeon (VM), 16GB RAM
Database: Oracle 11gR2
Crystal Reports Server Embedded 2008 SP5
Some history: Our project went live in Feb '15 and things were good. We had 1 reporting server and reports would take a minute or 2 (if that). As time went on, the reports overwhelmed the Reporting Application Server 12 and had to be restarted multiple times per day. We scaled out the RAS service, installing it on all 4 application servers and that fixed our issue for a while. However, things are getting bad again, specifically with reports running longer than 10 minutes and intermittently not even completing.
Any suggestions would greatly be appreciated, please let me know if any further information is needed.