Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Speed of reports in report manager too slow

Author  Topic 

volyn
Starting Member

30 Posts

Posted - 2010-05-21 : 04:08:38
Hello,

report is written well,I am sure about it, background SQL query takes in Visual studio DATA TAB less then 1 second. Strange is, that I ran this report in the morning in my job and it ran fantastically fast, data about clients orders in period 1 week, 1 month or 2 years were rendered in less than 3 seconds. After one hour reports are generating one week data 20 seconds and rendering of data for two months is giving me time for lunch.

SQL Administrator said, that he doesn´t see any extreme CPU or memory usage on server.

For rendering we use IE7, I dont know where could be problem.

Could you help how to recognize problem?

volyn
Starting Member

30 Posts

Posted - 2010-05-22 : 06:27:37
Please ignore this one, it was solved
Go to Top of Page

bho
Starting Member

1 Post

Posted - 2012-05-21 : 10:19:51
quote:
Originally posted by volyn

Please ignore this one, it was solved



can u please post your solution?

thanks
Go to Top of Page
   

- Advertisement -