IBM Support

IIS Worker Process (w3wp.exe) taking too much memory when TM1 Web is in use

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.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21568643