SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Speed of reports in report manager too slow
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

volyn
Starting Member

30 Posts

Posted - 05/21/2010 :  04:08:38  Show Profile  Reply with Quote
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 - 05/22/2010 :  06:27:37  Show Profile  Reply with Quote
Please ignore this one, it was solved
Go to Top of Page

bho
Starting Member

1 Posts

Posted - 05/21/2012 :  10:19:51  Show Profile  Reply with Quote
quote:
Originally posted by volyn

Please ignore this one, it was solved



can u please post your solution?

thanks
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000