SSRS requests for same report
Can anybody point me at an MSDN article that would explain how SSRS would handle multiple requsts for the same report ? We have a number of reports that are exactly the same and are considering a single report that uses database functions to return the required dataset.
October 29th, 2011 3:44am
Hi Pikey Barfield, You need to consider two main scenarios: to scale up or scale out. Scale up means all reports consolidated on one server with high specs (RAM, CPUs). Scale out means you install a report server farm including multiple instances of SSRS with a single instance of SSRS on a single box. See more here - Scaling Up Reporting Services 2008 vs. Reporting Services 2005: Lessons Learned Also, for a single (consolidated) report you could use a caching technique - Caching Reports (SSRS) Also, performance-wise it is better to use stored procedures in place of database functions (user-defined functions).Sergei
October 29th, 2011 6:03am
Thanks Sergei - we will consider those options in the long run - but for now I'm just looking for some MS documentation that says "SSRS starts a new thread for each report request" even if the same report is requested twice
October 29th, 2011 8:12am
Hi pikey barfiels, May be Roberr Bruckner’s blog will help your question: Dataset Execution Order. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
October 31st, 2011 2:25am
Dear Sharp, Thanks for your answer, the article is very interesting and has taught me something I will use in future. However the article is answering a more complicated question than I am asking, which is - if 3 people request the same report at the same time: REPORT1 REPORT1 REPORT1 will the reports be executed simultaneously or in sequence - can you point me at some MIcrosoft documentation that confrims they will run simultaneously please so that I can justify this. Thanks Pikey
November 5th, 2011 4:08am
Hi pikey, At first, I should apology for the misunderstanding. For this scenario, reporting services will perform concurrent processing for the multiple render requests, and each requests’ datasets will placed in the memory. In this condition, for the huge systematic, it needs additional performance for the report server. Sometimes, we consider planning scale-out deployment. Reporting Services Performance Optimizations Best Regards, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
November 5th, 2011 5:23am