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.

Advertisements

Responses

  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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Categories

%d bloggers like this: