How to improve RDLC Report performanace.

Great answer. When then person asking this generic, then the answer also has to be this generic.[:)]

Akkrahul,
Basically periodic restarts of ReportServer clears the cache and generally it takes time when you start it for the first time. From there on it should work normal.

But below queries should help you to get a basic matrix on the reports execution.

SELECT TOP 10 Itempath,[parameters],
TimeDataRetrieval + TimeProcessing + TimeRendering as [total time],
TimeDataRetrieval, TimeProcessing, TimeRendering,
ByteCount, [RowCount],Source, AdditionalInfo
FROM [ReportServer]..ExecutionLog3
ORDER BY Timestart DESC

SELECT
COUNT(REPORTPATH) AS RUNS,
REPORTPATH,
MAX(TIMEDATARETRIEVAL) AS MAX_DATA ,
MAX(TIMEPROCESSING) AS MAX_PROCESSING,
MAX(TIMERENDERING) AS MAX_RENDER,
MIN(TIMEDATARETRIEVAL) AS MIN_DATA ,
MIN(TIMEPROCESSING) AS MIN_PROCESSING,
MIN(TIMERENDERING) AS MIN_RENDER
FROM [ReportServer]..EXECUTIONLOG2
WHERE
STATUS IN ('RSSUCCESS')
GROUP BY REPORTPATH
ORDER BY COUNT(REPORTPATH) DESC

okey...Thanks

Hi Venkat,
Which report server do you talk about? And what is the purpose of this script? Looks more AX to me?

Erik, The script is generic and related to SQL Server Reporting Services. Any technology that uses SSRS reports can execute the script on SQL Server reports database to get a matrix of the reports history which have been executed. It gives a basic idea, insight and understanding of the report execution cycle then developers can narrow down on what can be done to improve and where..
Hope I covered explanation.

Amazing. Still trying to save face? [;)]

The question was about RDLC Report performance, not the theoretical option to use SSRS....

There is a difference between "can use" and "does use". The standard NAV product does not use SSRS.