SQLTeam.com | Weblogs | Forums

Ssrs 2008 r2 action link takes a long run to run


#1

In an existing ssrs 2008 r2 report, I have 49 rdls that can be clicked and there is an action link to the report. There is one particular link called 'archived' that takes longer to obtain data from than the other links do.

The main query behind the archived report is not very long. However I do not have any idea why that particular link would take such a long time to run.

Thus can you tell me what I can look at to determine why that particular link takes so long to produce the report?


#2

1st step... Run the following query and see which part is taking the most time...

USE ReportServer;
GO
SELECT TOP 1000
	els.TimeStart,
	els.TimeEnd,
	els.TimeDataRetrieval,
	els.TimeProcessing,
	els.TimeRendering
FROM
	dbo.ExecutionLogStorage els
	JOIN dbo.Catalog c
		ON els.ReportID = c.ItemID
WHERE 
	c.Name = N'MyReportNmae';

If "TimeDataRetrieval" is the largest number, then focus on tuning the SQL query.
If it's "TimeProcessing" or "TimeRendering" then focus on simplifying the actual RDL and/or set up so that it's rendering less data.

HTH,
Jason


#3

Where you say report name, would I use the exact name of the rdl like 'reportname.rdl'?


#4

Just 'ReportName'... Loose the file extension.