Cpu decuduction

Is there any way that i can deduct how much cpu is taking byu each and every
spid. In the sysprocess the cpu time is cumulative i dont want that one . i
want that how much time currently it is taking
"sunil" <sunil@.discussions.microsoft.com> schrieb im Newsbeitrag
news:3F7183A4-FD17-40A0-A808-E52188B62B68@.microsoft.com...
> Is there any way that i can deduct how much cpu is taking byu each and
every
> spid. In the sysprocess the cpu time is cumulative i dont want that one
.. i
> want that how much time currently it is taking
Use the profiler and / or perfmon - that will give you detailed
information about the load generated by SQL staments. The execution plan
(visible via Profiler and Query Analyzer) is also very informative.
Kind regards
robert
|||hi thanks for the reply but i want to know the query not from the profiler .
Is there is any query to check current cpu time not the cumulative one
"Robert Klemme" wrote:

> "sunil" <sunil@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:3F7183A4-FD17-40A0-A808-E52188B62B68@.microsoft.com...
> every
> .. i
> Use the profiler and / or perfmon - that will give you detailed
> information about the load generated by SQL staments. The execution plan
> (visible via Profiler and Query Analyzer) is also very informative.
> Kind regards
> robert
>
|||"sunil" <sunil@.discussions.microsoft.com> schrieb im Newsbeitrag
news:439850D6-3E83-46B0-A836-EE620D397D73@.microsoft.com...
> hi thanks for the reply but i want to know the query not from the
profiler .
Why not?

> Is there is any query to check current cpu time not the cumulative one
What information will that give to you? Profiler data is much more
detailed and thus you'll gain a lot more info from that.
If you want CPU load, then you can use perfmon and taskmanager.
robert
[vbcol=seagreen]
> "Robert Klemme" wrote:
and[vbcol=seagreen]
one[vbcol=seagreen]
plan[vbcol=seagreen]