report with more users RRS feed

  • Question

  • Hi Gurus,

    I have ssrs report and report access by 3000 users in same time frame. I am trying to improve report access performance .could you please let me know is there any way to improve the report access  performance.

    I have one sql table with 2000 k+ data.. I am trying pull the data with stored procedure.

    • Edited by vamsi1980 Saturday, October 15, 2016 7:23 PM
    Saturday, October 15, 2016 7:04 PM

All replies

  • What specifically is the performance issue you are facing? It is the stored procedure performance for retrieving the data or is it the time it takes to render the report? Can you provide some information from the Report Execution Log in the Report Server database. Take a look at the view ExecutionLog2 (or 3) views and provide some stats to determine where the potential issue is.

    Dan English's BI Blog

    Sunday, October 16, 2016 2:30 AM
  • Hello,

    You can setup report snapshots/caching, then data is queried only once e.g. per hour and the users get the report quite quick, see Performance, Snapshots, Caching (Reporting Services)

    If render time is the issue, then you can setup a report server farm to spread the workload, see Add an Additional Report Server to a Farm (SSRS Scale-out)

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Visakh16MVP Sunday, October 16, 2016 1:17 PM
    Sunday, October 16, 2016 7:34 AM