July 7, 2010 at 12:35 am
Hi,
I nees a steps to fine tune the SSRS reporting . what are all the major points to be considered .
i know its a silly questions . but i like to know the suggestion from everybody.
Thanks in Advance!
regards,
Sabarinathan.C
July 7, 2010 at 12:49 am
This was removed by the editor as SPAM
July 7, 2010 at 2:30 am
sabarichandru (7/7/2010)
Hi,I nees a steps to fine tune the SSRS reporting . what are all the major points to be considered .
i know its a silly questions . but i like to know the suggestion from everybody.
Thanks in Advance!
regards,
Sabarinathan.C
You really need to look at a few different places here. First there's the query. you can tune that as you would any one. See links in my signature for how to post performance tuning questions if it's the query itself that is slow.
Secondly there's the time it takes SSRS to render your data in the format you specify. The more data, the more filtering aggregation etc that you do in SSRS the longer the report will take to render. If you move 1000's of rows of data across the network just to aggregate it in SSRS, you're using way more resources than you need to. Do the aggregation in the query (where it will typically happen faster) and move a much smaller dataset across the wire to your report server. Also do not have your query return any more columns than you actually need. Again, extra network utilization for data that will just be tossed out etc.
Check the execution log of the ReportServer database to see what is taking the most time for your reports, rendering vs. query processing.
-Luke.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply