x

SQL Server Reporting services reports very slow

Hi

We have a web application developed and populating reports using SSRS from UI. We are deploying reports in a different server. Problem is most of the time, the reports population will be very slow (7 times in 10 times the report generation is very slow). What could be the problem?

If I restart the server then again it will generate fastly. What could be the problem? (Using SQL Server 2005)

Thanks in advance Usha

more ▼

asked Nov 26, 2009 at 02:12 AM in Default

Usha gravatar image

Usha
110 7 7 8

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

My first guesses would be a poor cached query plan or outdated stats.

Try updating the statistics on the underlying tables and see if that helps.

more ▼

answered Nov 26, 2009 at 10:09 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

Hi Thanks for your answere and sorry for my late reply, firstly i didnt understand what you meant by poor cached query/outdated stats. (Try updating the statistics) what does it mean?
Dec 02, 2009 at 08:04 AM Usha
(comments are locked)
10|1200 characters needed characters left

In addition to what Blackhak-17 has said. It would be helpful to know how you are querying the database, are you using stored procedures or adhoc SQL in the reports themselves? If you are using stored procedures this behavior sounds like "parameter sniffing" (google/bing that).

more ▼

answered Dec 01, 2009 at 11:14 AM

Jack Corbett gravatar image

Jack Corbett
1.1k 2 2 3

I am using stored procedures and when i run the procedure then there is no problem. The actual problem is only showing the report
Dec 02, 2009 at 08:08 AM Usha
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x558

asked: Nov 26, 2009 at 02:12 AM

Seen: 2956 times

Last Updated: Nov 26, 2009 at 04:50 AM