April 18, 2010 at 3:46 am
hi to all,
how to do the performance tuning is ssrs reports
April 18, 2010 at 6:47 am
Same way you tune everything else. Find the most consuming queries and start with those.
You may also want to scan for the rendering time of the reports and also start with the most consumming ones. For that you need to activate the reporting history in the rs database.
In that log you'll have all the time info you need.
April 18, 2010 at 6:52 am
That actual rendering of the report is likely the smallest part of the time. As mentioned by the ninja, you need to tune the queries. So focus on tuning those.
If those are completing quickly, and it appears rendering is slow, what is on the reports? And is the hardware overloaded (CPU/mem)?
April 18, 2010 at 11:35 am
I've seen slow reports because of he rendering... but I'm talking here about 30 000 rows being pivoted into a matrix with 3 levels of groupings on the columns and another 5 on the rows with 10 columns + totals both ways.
The query ran in about 10 seconds and the rendering took another 30... but I wouldn't call that slow for all the work that report was doing, plus it was a monthly report so no big deal there.
April 19, 2010 at 5:19 am
You need to determine where the bottlenecks are before you can optimize. Data retrival, rendering? Do you need r/t access or can you cache/snapshot? What type of hardware, scale-out methodology?
Your first step the exercise is to determinethe choke points (reports/data/users) an then choose a course of action.
Sqlscrubs on codeplex will get you started: http://scrubs.codeplex.com.
There is also a premium kit of reports add-on http://www.SummitCloud.com/solutions/scrubs
May 14, 2010 at 7:05 am
http://msdn.microsoft.com/en-us/library/cc966418.aspx
Ms White paper that will get you started
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply