Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SSRS performance issue on MOSS 2007

  Asked By: Larissa    Date: Nov 13    Category: Sharepoint    Views: 1017

Our company is using SQL 2005 Reporting Services (SSRS) to display a
dashboard with some useful statistics and fancy bar charts on the
company intranet. The dashboard uses report viewer webparts with the
SSRS source files (.rdl I think) hosted in reports center report library
of a moss site. The problem is that the ReportViewer takes too long to
bring up results on the MOSS-based site. The SQL works efficiently from
Query Analyzer (takes around 1 sec) but the report using that query on
MOSS almost 40 seconds (!!!!) to come back with results on the MOSS

We have tried to identify the cause of delay without any luck so far.
The Server has sufficient memory / other hardware specs so that does not
seem to be the bottleneck. I wonder if there are any known performance
issues with using SSRS over MOSS? Is there any better alternative?

Any suggestions, tips, clues, articles, blogs to help optimize the
reports would be highly appreciated.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on SSRS performance issue on MOSS 2007 Or get search suggestion and latest updates.