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 |
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-09-27 : 18:13:14
|
Have a report that times out when run on report manager, however when I run it on management studio is fine. What is the problem? |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-27 : 22:56:02
|
you mean running query retrieves result faster in management studio but report times out?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-28 : 01:30:06
|
Have you checked the Report Manager Server for any : a) anti-virus software b) Server restarts ?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
arpana patil
Starting Member
24 Posts |
Posted - 2012-09-28 : 06:39:02
|
Its may be becouse of huge data |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-28 : 10:20:19
|
quote: Originally posted by arpana patil Its may be becouse of huge data
then query should also take long isnt it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-09-28 : 13:27:11
|
quote: Originally posted by visakh16 you mean running query retrieves result faster in management studio but report times out?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
Yes.today ran fine on both management studio and report manager. it's weird. This has been happening since I added a Linked server to the query. I hope tomorrow is fine too |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-28 : 13:34:46
|
see if there were some network issues or some blocking happening when query was running. Use sp_who2 to identify blocking------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-09-28 : 13:43:48
|
It didn't run for 4 days (monday - thrusday). i think even if there is blocking during those 4 days, it would have dissipated and able to run it. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-29 : 13:57:26
|
Did you check for server retarts?Are you saying the report was attempting sto run for 4 days? Any other messages in the log files?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|