Subject | Re: High memory usage |
---|---|
Author | rodrigogoncalves |
Post date | 2005-07-22T11:30:52Z |
> I will interpret that as you do not have any triggers on those tablesTrue. Actually we don't use any UDF function in our database.
> 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.
> Although it was never called directly by any SQL, it was calledThanks. Actually I'm really lost on this one. I know the OAT/OIT can
> within a trigger on a table that was frequently modified. Anyway,
> just pointing out a likely cause, not necessarily the problem you are
> having.
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