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.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2013-03-12 : 16:46:31
|
| 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 AdvanceKRS39 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 00:22:38
|
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2013-03-13 : 10:09:19
|
| Thank you for the response Vishak, as we are using linked server to fetch the data and more over the reports are parameterThank You All In AdvanceKRS39 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 10:35:24
|
| did you try executing query in SSMS first? how is query executing?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2013-03-13 : 14:15:22
|
| Yeah i tried in SSMS it is taking bit less time then the application time.Thank You All In AdvanceKRS39 |
|
|
|
|
|
|
Report Running slow