Hi,
We have various web pages (ASPs) that connect to OLAP to display cube
data over the net.
Has anyone else noticed the memory usage of IIS gradually creep up and
up, until the web server responds so poorly it has to be rebooted?

You can monitor the memory utilisation of DLLHOST.EXE (the one where
the PID in Task Manager matches the PID in Component Services for "IIS
Out-Of-Process Pooled Applications"). It gets more and more as the
OLAP client (i.e. IIS) caches cube data from each query you run.

I have tried to force execution of MDX on the server, rather than
client, (via various connection string parameters) but to no avail.

If anyone knows a fix, a way to write my code better, or has a job to
clear out the IIS cache, I'd love to hear from you!

Thanks,
Magnus Smith

If you execute REFRESH CUBE <cubename> - it will clear the PTS data cache
for that cube.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================