SSRS Reports Performance Debugging and Analysis

SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.

SSRS Report Parts Versus Sub Reports FAQ

I'm trying to decide on a development strategy to satisfy the reporting needs in my organization. I would like to increase our efficiency in responding to report requests, while minimizing our maintenance burden. Two topics that I would like to dig in to are Report Parts and Subreports. Can you provide some considerations for using one versus the other?

Stairway to SQL Server Reporting Services

A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.

Stairway to SQL Server Reporting Services

Learn how to get started with Reporting Services in this easy to read series from MVP Jessica Moss that examines how you might start dealing with reporting requests from management.

Get Started with Chart Development in Reporting Services 2008

With Reporting Services 2008, it is now much easier to produce charts from data in SQL Server, and the variety of charts seems almost limitless. All you need to get started is a quick step-by-step guide that tells you the basics and gets you past the stage of creating the first chart. Well, here it is.

Data Driven Subscription

How to Speed up MS SQL Reporting Services on First Run

I set up a new instance of MS SQL Server Reporting Services, but I noticed that it starts up very slow and I have to wait for ages to access the site. I also noticed that it is always slow when it has not been used for a certain period of time.

Resend the reports scheduled to send on today's date

This stored Procedure grabs the reports scheduled to run on today's date and reruns the subscriptions on demand.

Resend Failed Scheduled Reports on Demand in SSRS

This Stored procedure re-sends the failed reports subscriptions on Demand.

Getting Started with Maps in SQL Server 2008 R2 Reporting Services

I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?