Re: Enforce (MTS) & Performance

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Browne (meat_at_hotmail.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 11:12:19 -0500

"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:2e6d801c46b4d$ef00d700$a501280a@phx.gbl...
> I'm sorry Andrew, I got too busy with the problem.....
>
> I have the sample Profiler output. What is the meaning of
> 1953 in the CPU column ?? Most of the high values (1000 to
> 2500) comes from the 2 stored procedures I mentioned
> earlier. Others at 16 to 250 level.
>

It means that those stored procedures probably need to be rewritten.
Perhaps to not use cursors, and use set-based SQL instead, or perhaps
there's some other defect, like an inefficient query causing way too much
logical IO.

David

Relevant Pages