Troubleshooting
Problem
On Windows 2008 R2, the process w3wp.exe (IIS Worker process) is taking a huge chunk of memory each time a user connects to TM1Web or opens a new sheet. On the TM1 Server side (tm1sd.exe or tm1s.exe), the RAM consumption remains stable.
Resolving The Problem
[Note this solution can apply to other Cognos products that make use of w3wp]
For IIS 7.0 / IIS 7.5 :
- From Windows Control Panel / Administrative tools, open Server Manager
- Expand Roles and select Web Server (IIS)
- On the right pane, for the "Roles Services" section, click "Add Role Services"
- Under "Application Development", check "ASP" if this is not already checked
- Once this module is installed, close Server Manager and open Internet Information Services (IIS) Manager (7.x)
- In the left hierarchy, select the root of the treeview (machine name)
- On the right pane, under "IIS" section, double-click the "ASP" icon
- A list of properties is displayed. Expand "Caching Properties"
- Change "Maximum Memory Cached Files" from 500 to 5
- Restart IIS
For IIS 6.0 :
Modify AspScriptFileCacheSize property in the Metabase.xml configuration file (in /Windows/system32/inetsrv32) and restart IIS.
Now the cache will mostly take place on disk rather than in memory.
Another interesting point is that the same file cached on disk is taking far less space than in memory.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21568643