Subject Re: High memory usage
Author rodrigogoncalves
> I will interpret that as you do not have any triggers on those tables
> you are updating or inserting that internally call UDFs or other
> procedures that contain UDFs. Also that any records impacted within
> the triggers do not cause other triggers that contain UDF functions.


True. Actually we don't use any UDF function in our database.

> Although it was never called directly by any SQL, it was called
> within a trigger on a table that was frequently modified. Anyway,
> just pointing out a likely cause, not necessarily the problem you are
> having.

Thanks. Actually I'm really lost on this one. I know the OAT/OIT can
cause this sort of performance problem, but what puzzles me is that
only on this server this happens. Other servers with the same OAT/OIT
difference don't suffer so much (and they have about 3 times the
number of clients of this one).

May the HT is the one causing this problem?

Regards
Rodrigo