Solved

Reporting service slow

Posted on 2011-03-25
1
353 Views
Last Modified: 2012-05-11

Experts,
I have a highly used report, after I make some changes to other reports and SQL objects users start complaining the report is so slow and sometimes they even get time out errors? What would be most probably reason of this problem, and what tools/objects you’ll use to figure out?

Thanks,
0
Comment
Question by:yrcdba7
1 Comment
 
LVL 18

Accepted Solution

by:
lludden earned 500 total points
Comment Utility
First guess would be a bad execution plan cached for the query.  Does the query always run fine in Management Studio?  

You can add the WITH RECOMPILE option in on the SP and see if that makes the performance more consistent.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now