We have an ASP web application that connect to Microsft Analysis
Service to display cube data over the net using ADOMD api.

It was noticed that after every few hours of usage of the application,
the memory usage by inetinfo.exe (IIS) is at peak. The only solution we
have is to restart the IIS.

We can not keep resetting IIS periodically. If anyone knows how to
resolve this issue, please let us know ASAP.

Thanks and Regards,
Hitesh

This isn't nececcerely a leak. Perhaps you have too many PTS instances and
they use too much cache. You can try to limit number of PTS's by using
connection pooling and/or use "Client Cache Size" property to limit the
cache size of each instance.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
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.
==================================================

"hitesh" <hiteshkhatri (AT) gmail (DOT) com> wrote

It's a web application and we are not keeping connection or cellset
open after executing query. At present only 4 users are using the
application. still the memory usage is going so high.

Regards,
Hitesh