I host a RS2005 instance on a Win2003 server (2gb ram; 3ghz xeon cpu) which is performing quite nicely.
I'm now migrating to a RS2008R2 instance on Win2008R2 server (12GB ram; Xeon 5110, 64bit) and hoping for a big performance increase.
Instead I see the reverse. It's a 5-10second delay every time I select an option in the Report Manager. Similarly, on demand reports are taking 15 seconds instead of 3 seconds.
The Win2008R2 server is a brand new machine, freshly installed with OS and SQL. I have a test Win2008R2 server inhouse (much lower specs) which runs fine.
What can I try?
The hosting provider has currently disabled McAfee antivirus, with no noticeable difference.
Any help would be MUCH appreciated.
View Complete Post