October 4, 2013 at 6:26 pm
Hi all,
I am using a stored procedure to load a dataset from oracle. The procedure completes and all data is returned < 4 seconds. The report in SSRS, however, takes an extremely long time to process whether or not there is data provided to the report.
SProc info:
2 Parameters (Ref Cursor for rows, Selected Date)
Data is returned to SSRS in the same amount of time as executed locally on the db.
I am confident the procedure is sufficiently optimized and unrelated to the issue.
SSRS Report:
Simple report, no filtering, no aggregation
ReportServer.ExecutionLog3 Details:
[font="Courier New"]
ItemActionRender
TimeStart2013-10-04 17:55:04.747
TimeEnd2013-10-04 18:07:27.047
TimeDataRetrieval 3327
TimeProcessing 738729
TimeRendering 10
SourceLive
StatusrsSuccess
ByteCount8988
RowCount0
[/font]
Any idea what could be causing the *excessive* TimeProcessing?
Again, almost no formatting in the report.
0 Rows in the test pull (so... no rows to process).
(Edit)
It is also worth noting that the processor usage on the SSRS server is not elevated during the extended processing wait time.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply