August 17, 2007 at 5:30 am
Hi all,
My RS installation was very slow on the first load of a report.
I extended the timeout in the IIS Defaul Apploication Pool which has fixed the problem.
Now want to schedule a dummy report to run every morning so that there is no delay for subsequent 'real' reports.
Does anyone know how I can do this and whether it can be done via the SQL Agent?
I was going to run a .bat script every morning, which simply opens IE with a valid URL to the report. I don't want to have to log into the server and then close the IE window every morning though.
Any help is appreciated.
Thanks,
Paul
November 29, 2007 at 10:19 am
Using the properties for the report in question, you can set it to run using on schedule and use this cached report during the day.
The steps I think you need to take are:
1. In Reporting Services, open the report properties.
2. Select 'Execution'.
3. Select the option 'Render this report from a report execution snapshot'
4. Select the sub-option: 'Use the following schedule to create report execution snapshots'
5. Choose your schedule.
6. You can test for an improvement by selecting 'Create a report snapshot when you click the Apply button on this page' and then running your report.
Consider carefuly the default options for the report parameters. You may be pulling a large dataset when the report is opened, but the users want a smaller data set. You could change the default parameter, or as I do, have no default parameter value (this approach does not work with a timed execution snapshot).
Cheers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply