Is it possible to offload the resource intensive tasks such as Reporting to a different server? I know I could set up scheduled reports to run on a different server as those will get e-mailed out and require no end-user interaction, but what about a report someone needs while using Perspective, per se. If the report takes a very long time to generate (and makes the CPU skyrocket to 100% for extended period of time), could we trigger the report viewer component to show a report generated by another server? Any suggestions on how to go about doing this?
You may look at optimizing your queries so they return the data you need to report on rather than processing the data in the reporting module. Also look at your indexes etc for the data and make sure they are optimized.