Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Extremely High Processing Time - Blank Report Expand / Collapse
Posted Friday, October 4, 2013 6:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 12, 2013 11:18 AM
Points: 4, Visits: 28
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:

ItemAction Render
TimeStart 2013-10-04 17:55:04.747
TimeEnd 2013-10-04 18:07:27.047
TimeDataRetrieval 3327
TimeProcessing 738729
TimeRendering 10
Source Live
Status rsSuccess
ByteCount 8988
RowCount 0

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).

It is also worth noting that the processor usage on the SSRS server is not elevated during the extended processing wait time.
Post #1501804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse