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 2008 Forums
 Analysis Server and Reporting Services (2008)
 Report Running slow
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ksr39
Posting Yak Master

India
183 Posts

Posted - 03/12/2013 :  16:46:31  Show Profile  Reply with Quote
Hi Experts,

I got a situation where one of my report is fetching information from the database very slowly as if I run the same query from query analyzer it fetches the results in 41 sec. I am not able to find why it is slow when it is trying to fetch the same info from the report.
SQL Server 2008 R2 and Reports are form IBM Cognos server.
Please can any one help me/ suggest on the same.


Thank You All In Advance
KRS39

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/13/2013 :  00:22:38  Show Profile  Reply with Quote
are you trying to use linked server to fetch the data from IBM cognos? is the report static or is it parameter based?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

ksr39
Posting Yak Master

India
183 Posts

Posted - 03/13/2013 :  10:09:19  Show Profile  Reply with Quote
Thank you for the response Vishak, as we are using linked server to fetch the data and more over the reports are parameter

Thank You All In Advance
KRS39
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/13/2013 :  10:35:24  Show Profile  Reply with Quote
did you try executing query in SSMS first? how is query executing?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

ksr39
Posting Yak Master

India
183 Posts

Posted - 03/13/2013 :  14:15:22  Show Profile  Reply with Quote
Yeah i tried in SSMS it is taking bit less time then the application time.

Thank You All In Advance
KRS39
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.05 seconds. Powered By: Snitz Forums 2000