We have currently deployed a solution developed on SQL Server 2008 (Relational and OLAP), with the information being rendered into charts and tables and delivered using MOSS 2007.
The databases, report server and SharePoint sit on different well specc'ed machines. We have configured Kerberos to enable double hopping and from a functionality perspective, all works well!
Our concern is primarily on the performance area. When I access the dashboard from a browser on the server, I get results back in about 2 secs or less. However, when I access the same dashboard pages from a remote location (with a good internet connection), the speeds are slower - mostly 4 to 6 secs or even longer. The only reason for the performance hindrance that I could think of is internet connectivity speeds at the remote location.
I have noticed that RS renders charts as images when it has to display bars, and in some cases, when the images are bigger in size, they take longer to display on the screen.
Is there any areas of performance enhancement that I should be looking at? Can anyone spot anything that I'm not?
Thanks in advance!
