Microsoft SQL Server Reporting Services - measuring and improving performance

Tips for Optimising Reporting Services Performance from tudortr

Thomas Williams — Wed, 30 Jun 2004 09:15:00 GMT

Tips for Optimising Reporting Services Performance from tudortr

re: Microsoft SQL Server Reporting Services - measuring and improving performance

Thomas Williams — Wed, 30 Jun 2004 09:16:00 GMT

http://dotnetjunkies.com/WebLog/thomasswilliams/archive/2004/06/30/17947.aspx

Welcome Tudor to Reporting Services Blogging

Bryan's WebLog — Thu, 15 Jul 2004 05:26:00 GMT

re: Microsoft SQL Server Reporting Services - measuring and improving performance

Nick C. — Wed, 28 Jul 2004 00:05:00 GMT

Regarding your comment:

Usually the bulk of report execution time is spent executing queries and retrieving results.

I wish that were true in our case! We're using Analysis Services (OLAP) with Reporting Services. While the query results are returned to the reporting server in 1 second or so, our reports take 30-60 seconds to render on a high end server! Something is very wrong on the RS side.

Nick

re: Microsoft SQL Server Reporting Services - measuring and improving performance

RHIncredible — Thu, 14 Sep 2006 23:19:54 GMT

I have read thru and checked every suggestion here and in many other places and can find absolutly no solution to my perfomance problem. I am running a moderatly complex query to a remote (WAN) Oracle database using the latest Oracle Data Provider and RS will not render the report, it just hangs until the process is recycled. I have tested the exact same report on a local (intranet) Oracle database and it works fine. I have tried adjusting every "time out" configuration setting both client side and server side. It won't even generate for a subscription. The infuriating part is I can execute the query in the design tool but when attempting to preview or execute on the server I get nothing. I'm getting no Exceptions or errors or any indication why the report won't complete processing. Any Ideas?

re: Microsoft SQL Server Reporting Services - measuring and improving performance

rajkant — Wed, 26 Mar 2008 11:28:11 GMT

I am facing same problem - can u please share the solution if

you got it?

Tips for Optimising Reporting Services Performance from tudortr

Thomas Williams Tech Blog — Sun, 29 Jun 2008 14:20:37 GMT

Tips for Optimising Reporting Services Performance from tudortr

Bill the Annoying » Microsoft SQL Server Reporting Services - measuring and improving performance

Thu, 21 May 2009 20:42:39 GMT

PingBack from http://billtheannoying.com/?p=298

Tudor s WebLog Microsoft SQL Server Reporting Services measuring | Paid Surveys

Tudor s WebLog Microsoft SQL Server Reporting Services measuring | Paid Surveys — Fri, 29 May 2009 19:38:57 GMT

PingBack from http://paidsurveyshub.info/story.php?title=tudor-s-weblog-microsoft-sql-server-reporting-services-measuring

Tudor s WebLog Microsoft SQL Server Reporting Services measuring | debt settlement program

Fri, 19 Jun 2009 17:12:19 GMT

PingBack from http://edebtsettlementprogram.info/story.php?id=24032