SSRS performance for dynamics custom report

• Question

• 

  

  0

  Sign in to vote

  Hi All, 

  I have been wrestling with an issues we have with clients custom CRM reports and performance timings.

  I've ran a SQL trace on the report in question and it runs in under 3 seconds via SSMS and yet the total time to render the report on screen is upwards of 35+ secs.  

  The report has 2 date field parameters (Start and End) which queries incidents based on createdOn date.  It returns 10 fields from incidents and 2 from account.  The fetchxml translates to a Left outer join from incident to account but as i say this runs under 3 seconds.  The dataset returned contains approx 11400 rows.

  I've checked the report server and the TimeDataRetrieval and TimeProcessing seem excessively high but i'm not sure where to investigate next.

  TimeDataRetrieval = 16401

  TimeProcessing = 14893

  TimeRendering = 1885

  TotalTime = 33179

  If it is a fetchxml report how would i go about checking for parameter snipping?
  Any help would be greatly appreciated.

  
  

  
  
  

  • Edited by davidjsteele Thursday, August 14, 2014 1:48 PM

  Thursday, August 14, 2014 1:45 PM