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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2013-11-19 : 11:54:53
|
| There are two server for SSRS.Prod. and Dev.Every morning the very first user who runs any report on the Dev. server, it takes a long time for the report to be generated...But this is not the case in Prod. The very first user in the morning who runs a report does not face a delay as he/she does in Dev.Do you know the cause of this please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-20 : 02:15:32
|
| See if report caching option is disabled in Dev as against it being enabled in Prod.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2013-11-20 : 04:39:28
|
| Where do I check this please?Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-20 : 08:09:49
|
| In Report Server under report properties go to execution tab.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
delay first time to run report