Is there a way to speed up the reports? When I run reports on my Win 2008 R2 server (4-cpu's, 4gb ram), it takes up to 1-2 hours to run reports for activity usage for a 1-2 day period.
What is the limiting resource for running reports? Is it cpu, ram, disk, etc? Are there any tricks or configs to getting the reports to run faster?
I watched a few Youtube videos showing people run reports and the reports generated in seconds.