Posted by: Charles Maitland | Wednesday 31 May, 2006

Good tip on Reporting Services performance

Chris makes a good point on how the MDX generator in Reporting Services 2005 produces potentially wasteful code.

On a related note if you are looking for performance gains then have a look in the ReportServer database. In there is the ExecutionLog Table. This shows you each report that was run, who ran it, what parameters were used and how long it took. The really cool thing is that it sub divides the time taken into the time to retrieve the data, the time to process the data and the time to render the report.

This means that you can quickly home in on the cause of a slow running report. You could even run a report to report on reports performance.



  1. Good info. I’m totally new to this. Is the time to run in milliseconds?

    Thx for the comment on me blog 🙂

  2. The ExecutionLog table is a great tip, but you must turn on Logging in the Site Settings of the Report Manager.

  3. Thanks for the information:)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: