I've been working on a PoC environment to move a small Report Manager site to SharePoint. By small I mean ~150 users, 50-odd reports, datamart and cube datasources (i.e. most reports run in under 5 seconds). The environment is SQL 2008 R2 and SharePoint 2010.
In SharePoint integrated mode, portal performance is quite poor. Application warm-up seems to be a continual issue, and can take several minutes. Performance surfing through SharePoint and SSRS pages within SharePoint is also very sluggish. Even report execution and rendering seems much slower.
When I finally "gave up" and switched SSRS back to Report Manager (on the same server), performance is lightning fast - probably 5-10 times faster.
The server seems reasonably spec'd: 8GB ram, 2-core VM, with plenty of free disk space. It is hosting a fair bit e.g. SQL, SSAS, SSIS, SSRS, SharePoint. Even so, free RAM was about 1-2GB when SharePoint was running - seems OK to me.
My question is, is anyone out there having any success with SharePoint 2010 performance, especially for SSRS? I'm reluctant to give up on it (especially Excel Web Server) but all I'm seeing are similar negative experiences.
I'm no SharePoint expert by any means but that memory seems low to me, do you have ability to test on a "beefier" machine? For the good performance you are seeing, are you using a mechanism to surface reports in SharePoint so it functionally behaves the same as if it were in integrated mode or are you just running the reports from Report Manager? SharePoint, SSAS, and SSRS all require a lot of memory, so does SSIS but I'm assuming that you run your packages while users are sleeping.
That's about as "beefy" as the servers get at that site ... perhaps I should be taking the SharePoint system requirements more seriously.
The good performance was when SharePoint was turned off, so purely using Report Manager.
SQL database engine, SSAS and SSRS are all dialed down in their memory settings, to avoid soaking up all the memory. SSIS packages are indeed largely run overnight. None of those parameters changed between observing poor SharePoint performance and good Report Manager performance.
Are you seeing good SharePoint performance for SSRS in Integrated mode? Can you describe the environment?
Hi There are some known performance issues with SSRS integrated, to be resolved in 2012.
As you're running Sharepoint 2010 Enterprise (needed for Excel services), there is a workaround.
Create a Performance Point Reporting services component pointing to your native mode server ~ this will give you Native speed while still letting you embed the RS as a normal Sharepoint web part, including connecting PPS filters to it