Report generation timeout

Posted by Yrajudba under Sql Server on 6/17/2011 | Points: 10 | Views : 1387 | Status : [Member] | Replies : 2
hi,
i have two environments prod and test, both are just replica.
when i try to generate reports on test it is generating fine in 5 min and when i try to generate the same on the prod, it is not getting generated and showing as timed out.
can any one help me how to fix this issue. nothing is mentioned the logs and for information, the test environment is having more data than prod.i check with dbcc showcontig, it is showing 100%.
my sql server version is 2008.

please provide me a solution

thanks,
Raju
Mark This




Responses

Posted by: Robin_ahuja2008 on: 6/17/2011 [Member] Starter | Points: 25

Up
0
Down
http://forums.asp.net/p/1690374/4463069.aspx/1?Re+Sometimes+IIS+Restart+Needed+to+generate+crystal+reports+in+my+asp+net+application+

And please make sure that the configuration of your production server is fine

Regards,
Robin Ahuja

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Yrajudba on: 6/20/2011 [Member] Starter | Points: 25

Up
0
Down
it is not crystal reports.
normal reports from sql server

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response