COM+ System slowdown!!

[ChrisClarke]

Hi,
we have a complus application that has a few hundred components in it.. the system seems to work fine to start with but as time goes on it gets slower and slower.. and eventualy grindes to a halt.. restarted COM+ components sorts the problem for a while but quickly the problem returns.. a reboot stops the problem for longer..

we are getting this problem at least once or twice a day!!

the application is running on w2k with sp3, and it connects to SQL server 2000.. we've checked the obvious things about not enough sql connections..etc or the application holding open too many objects, but this doesn't seem to be the case.. the CPU usage is very very low so its not something stuck in a loop or anything like that..

there is no high load.. the most users that are ever on is about 15!

anybody experienced anything like this??

any ideas?

thanks
chris

 

[MudMan2000]

Some things to try/check:
- is your com+ package set to be a server or library process? (activation tab); in most cases you should use server so that it runs in a dedicated process as opposed to library which runs it within the creators process

- do all your public middle tier methods dispose of the transaction object both on success and failure (objctx.setcomplete at end of method, and objctx.setabort in error handler)-even for non transactional methods (lookups etc) this is very important because both setcomplete and setabort not only "vote" yes/no for the transaction to proceed but they also clean up the memory associated with that particular objectcontext

- what version of ADO are you using? We discovered in ADO 2.5 that connections do not necessarily get closed even if you call cn.close and set your connection object to nothing (maybe run SQL Profiler and watch your connection usage)

- in com+ on the advanced tab for your package, do you have an idle timeout specified for your app so that it does not stay running when idle?

Hope this helps,
Good luck!