Extremely High Processing Time - Blank Report

• brent.singleton

  SSC Rookie

  Points: 44

  More actions

  October 4, 2013 at 6:26 pm

  #278702

  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.