Thursday, September 22, 2005

reading documentation

Just a citation from docs:

"The additional overhead of running the SQL Trace facility against an application with performance problems is normally insignificant compared with the inherent overhead caused by the application's inefficiency."

1 Comments:

Blogger mathewbutler said...

Not sure that I agree with this.

When tracing an application that (it later turned out) was CPU bound the additional CPU used by the trace dramatically increase the overall run time of the process. So much so that the trace had to be aborted.

The good news was that the trace file enabled us to hypothesise about the problem, prove the issue using O/S metrics and implement some fixes based on the resource profile of the available trace.

4:13 PM  

Post a Comment

<< Home