2012年2月26日星期日

First Hit to SQL Reporting Services - Slow Response Time

The first time each day that a user accesses SQL Reporting Services 2005, it
takes up to 3 minutes to load the SQL Reporting web interface. After the
first hit, it loads much faster. Is there a way to speed up the intial load?This is an IIS issue. After a certain time it unloads RS. Note that as far
as IIS is concerned RS is just another asp.net application.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chili86@.discussions.microsoft.com"
<Chili86@.discussions.microsoft.com@.discussions.microsoft.com> wrote in
message news:26DF80C2-7E46-4A7F-AEA1-57E36697D155@.microsoft.com...
> The first time each day that a user accesses SQL Reporting Services 2005,
> it
> takes up to 3 minutes to load the SQL Reporting web interface. After the
> first hit, it loads much faster. Is there a way to speed up the intial
> load?

没有评论:

发表评论