Wiki

Case Status
Register Log In

Wiki

 
Syncronex Single Copy  Syncronex Enhanced Reporting -…
  
Page Collections
Attributes
Hierarchy
  • RSS Feed

Last modified on 2/3/2011 9:13 AM by User.

Tags:
version 3.5

Syncronex Enhanced Reporting - Configuration Considerations (v. 3.5+)

After installing SQL Server Reporting Services (SSRS) to support Syncronex Enhanced Reporting, it is possible that if there is an extended period of inactivity on the report server, the next time someone tries to run a report, it will timeout while SSRS spins up again.  During development and testing, we often notice this the first time we try to run a report on our development machines in the morning.

There are a couple of settings on the application pool associated with the Report Server that will mitigate this problem: the 'Process Model\Idle Timeout' setting, and the 'Recycling\Regular Time Interval' setting.

On Windows 2008 Server (Internet Information Services 7), follow these steps:

  1. Start Internet Information Services (IIS) Manager
  2. Select 'Application Pools' in the tree view on the left.  It will be found under the server that you're configuring
  3. In the 'Application Pools' pane, select the pool that is associated with the SSRS 'Reports' application
  4. In the 'Actions' pane on the right, select 'Advanced Settings...'  An 'Advanced Settings' window will be displayed
  5. In the 'Process Model' section, set the 'Idle Time-out (minutes)' setting to a value of 0
  6. In the 'Recycling' section, set the 'Regular Time Interval (minutes)' setting to a value of 0
  7. Click OK
  8. You can close IIS Manager

On Windows Server 2003 (IIS 6), follow these steps:

  1. Start IIS Manager
  2. Select 'Application Pools' in the tree view on the left.  It will be found under the server that you're configuring
  3. In the right pane, right-click the application pool that is associated with the SSRS 'Reports' application, and click 'Properties'
  4. On the 'Recycling' tab, uncheck the 'Recycle worker processes' settings
  5. On the 'Performance' tab, uncheck the 'Shutdown worker processes after being idle for (time in minutes):' setting in the 'Idle timeout' section.
  6. Click OK
  7. You can close IIS Manager

With these settings in place, the application pool won’t timeout, and the service won’t recycle.