.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

ssrs performance tunning

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server

I am using SSRS 2008.

I have created one report with SP as input for this one.

SP returns 350000 records as output in 10 seconds

But SSRS report takes more than one minute to display the output.

How to tune this?

Is it possible to display first page records immediatly and then fetch records from DB after that.

Kindly give me tips for this.

I am not using any expression or anything . Just displying what the SP returns.

View Complete Post

More Related Resource Links

SSRS 2008 R2 Add-in Performance Issues

I have a very interesting issue with a customer.  They use lots of images in their reports.  The report performance is very poor after deploying the report to Sharepoint Integrated Mode and executing the report from Sharepoint Report Viewer.   The single server is setup with SQL Server 2008 R2.  Sharepoint and Reporting Services are running all on the same server.    The goal is to be able to use the Report Viewer Web Part and Sharepoint Filters to create Dashboards.   We have tried the following ways to get satisfactory performance out of these reports:  ·         When we run the reports in a page viewer web part in Sharepoint against a native SQL 2008 Report Manager on another server, they execute great ·         When we run the reports in a page viewer web part in Sharepoint against the Sharepoint Integrated Report server on same server, they execute way more quickly then when using the Report Viewer against the same Sharepoint Integrated Report server . ·         When we remove the images from the reports  and execute the reports via report viewer or in the Integrated library they execute satisfactorily in both Report Manager and Sharepoint Integrated - but th

SSRS 2008 R2 Rendering Performance

I am implementing a matrix report in SQL Server Reporting Services 2008 R2.  There are about 37 rows and 10 columns where each cell has an Indicator graphic (so about 370 cells).  The report shows loading for a few seconds but then freezes for about 2-3 minutes before the report pops up. Other matrix reports without the indicators seem to render just fine. Is there some way to improve the performance of reports such as these with many indicators in each cell?

SSRS Report Performance & Optimization

Can  any explain how would i Optimize a report performance.. I have few reports that are taking longer time to run. Thank youFM

SSRS 2008 Performance vs SSRS 2008 R2 Performance



Is there is any difference in performance wise in between these two versions.

i have deployed a report in both the environments. The report is very quick in SSRS 2008 than SSRS 2008 R2.

when we are going to new version (Updated version) performance should be increase. but SSRS 2008 R2 is very slow in executing the report. did i miss any config setting while installing SSRS 2008 R2.

Pls advice me, your help will be appreciated.


Rajesh Peethala

Not able to use SSRS report with a parameter within Performance Point 2010


I have created a report in SSRS 2008 and have passed a parameter called Carrier to it. The report works fine on http://machinename/reports and am able to pass parameters to the report including the All Carriers parameter.

However I cannot get the report to run in PPS 2010. In PPS I have created a multi value filter called as Carrier and have passed this filter to this report. But when I execute this report I get the following error :

    Reporting Services Error

  • Default value or value provided for the report parameter 'Carrier' is not a valid value. (rsInvalidReportParameter) Get Online Help

SQL Server Reporting Services


I have used the data type as string in SSRS.

Please help.

SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



SSRS 2008 R2 and Sharepoint 2010 - performance problems


Hi all,

I'm currently in a DWH project using SSRS 2008 R2 x64 in Sharepoint Integrated mode along with Sharepoint 2010, and we're seeing massive performance problems even though traffic on the server is at a bare minimum. We're in development with a maximum of a few users online at any given time and the server itself isn't doing a whole lot...cpu is usually < 20%. We have timed the database queries and 90% of them are taking less than a second to execute while reports takes anywhere from 5 to 30 seconds to load (some heavier reports can occasionally take a lot longer). I am simply unable to get anything to load in less than 5 seconds, even the simples grid from a SELECT TOP 5 * FROM table query takes this long.

The server setup is suboptimal as SQL Server, Reporting Services and Sharepoint are all running on the same virtual machine but with the minimal amount of traffic we have this shouldn't really be a problem. The server is a Win 2008 x64 Datacenter with 4 CPU's and 16GB RAM.

A standard sharepoint page that gets data from the database is returned in milliseconds...why doesn't reporting services do the same? What can I do to increase performance?


SSRS 2005 setup compare - report performance issue



I have a SQL stored procedure that is a data source for the SSRS 2005 report. I use two servers with identical hardware, let’s call them Server1 and Server2. When I run SP directly on the Server1(SQL 2005) and Server2(SQL 2005) within SQL Server Management Studio, SP runs for 10-11 seconds on each server. When I run my SSRS report that is using the procedure within BIDS or SharePoint sites (each server has its own SharePoint site with supposedly identical setup), it runs for 20 seconds on Server1 SharePoint site and for about a minute on Server2 SharePoint site as wel as witin BIDS. There is no network traffic.

When I traced performance on both servers with SQL profiler while running report within BIDS or SharePoint, I didn’t notice anything unusual; it just takes more time to process statements on Server2. I also tested several other reports and they all perform the same on both servers with maybe only a few seconds difference (Server1 is a bit faster). I suspect that SSRS for Server2 has a different setup as the performance declines only

ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.

10 Tips for Writing High-Performance Web Applications

Writing a Web application with ASP.NET is unbelievably easy. So easy, many developers don't take the time to structure their applications for great performance. In this article, I'm going to present 10 tips for writing high-performance Web apps. I'm not limiting my comments to ASP.NET applications because they are just one subset of Web applications. This article won't be the definitive guide for performance-tuning Web applications-an entire book could easily be devoted to that. Instead, think of this as a good place to start.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend