SSRS performance problems

• Dok

  SSC Rookie

  Points: 32

  More actions

  February 16, 2009 at 4:44 am

  #199945

  Morning all

  Hopefully this is an easy one to get help with.

  We are using SSRS for our reporting and one of the reports is taking quite some time to run. My question is, "How do I go about diagnosing this?" When running the Profiler, the only options I see are Database Engine and Analysis Services.

  Am I missing something? Is there a recommended way to analyse the performance of a report configured with Reporting Services?

  Any help appreciated.

  Paul Dokoupil

• kladibeeto

  SSCommitted

  Points: 1582

  More actions

  February 16, 2009 at 5:51 am

  #944444

  First step is that you find query/procedure which is executing in report (look at dataset).

  After that you should analyze execution plan.

• Dok

  SSC Rookie

  Points: 32

  More actions

  February 17, 2009 at 4:16 am

  #945065

  Thanks for the pointer.

  I've got some assistance from our development team in locating the query that is executing.

  Cheers