Report Server Optimizations

The fourth and final technical note “Reporting Services Performance Optimizations” in our series on Building and Deploying Large Scale SQL Server Reporting Services Environments is now available on SQLCAT.com.  The focus of this final technical note is on how to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.

1

Optimizing Reports - Show the Right Set of Data

You are probably now thinking, of course my report shows the right data!    Ok, but is it fast (enough)?   My esteemed colleague Dean Kalanquin started blogging recently.  He has been working in databases for a long time, and has gained great experience and knowledge by working on several different areas of SQL Server…

0

Report Performance Optimization Tips (Subreports, Drilldown)

In a previous posting, I explained the new ExecutionLog2 view in Reporting Services 2008: how to utilize it to measure report execution performance, identify report candidates for optimizations, and verify the impact of the latter.  I also included two tips at the bottom of that posting, that I want to call out explicitly as a separate…

2

ExecutionLog2 View - Analyzing and Optimizing Reports

There are several options for monitoring performance of a report server.  The fourth article in our technical note series on performance and scalability covers information for optimizing entire report servers.  Besides performance counters, analyzing report execution log data in particular can help answer questions such as, which reports might be good candidates for caching, how many reports were returned from…

7

Technical Note Series on Reporting Services Performance and Scalability

  Over the past few months, I contributed to a series of technical notes by my esteemed colleagues Denny and Lukasz on http://sqlcat.com/. The technical notes provide guidance on how to build, deploy, and optimize large scale SQL Server Reporting Services (SSRS) environments.  We derived some of the best practices from internal as well as external enterprise SSRS deployments. So…

2

On-Demand Report Processing in Reporting Services 2008

You may have heard by now that the report processing engine of Reporting Services 2008 works significantly different underneath the covers, compared to previous releases.  While I plan to dive into more technical details in future postings, I wanted to provide a few examples upfront explaining why you as a report author or end user might care: On-demand…

8