September 26, 2014 at 4:15 am
Hi,
Is SSRS Report multi processed, I mean If there are four tablix in a RDL with single data source and four different datasets. Is it possible for the RDL to processing all the datasets in parallel and render all four tablix in parallel. I googled but I could not find anything relevant. Please help!
September 26, 2014 at 5:48 am
I'm not sure. I am sure though that if you have 4 subreports in one report for example, they all get processed serially.
(I had a report once with 4 subreports and I only showed one based on expressions. Each subreport data source ran for 1 minute. Total report execution time was 4 minutes)
edit: you can take a look at the logging and find out how long it took for data retrieval. If you have long running queries it should be easy to interprete if the report runs in parallel or not.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2014 at 6:15 am
I can find out whether it is running serially or parallel. My concern is, is it possible or not. If it is possible how to do it so that my report get processed in parallel. Is there any thing in configuration need to change or I need to use something like Report Part etc..
September 26, 2014 at 6:20 am
I don't think you can really influence it. The only option I see in a data source is about transaction management.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply