Improving performance for SharePoint 2010 and Reporting Services in integrated mode


  • Hi,

    on a vm I've SharePoint Foundation 2010 and SQL Server 2008 R2 with Reporting Services configured as integrated mode.

    I've published some reports on the home page and when I load it, it takes more 1' and 30" to complete the page load. I've analyse the queries with SQL Server tools (e.g. Profiler) without any meaning results. I've adjusted a query reducing the execution time from 30" to 2" but this good result isn't visible when I load the home page.

    So, I think that the issue is related to SharePoint performance with Reporting Services.

    Any suggests to me, please? Many thanks

    14 มิถุนายน 2555 15:47