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...
> > 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
>|||"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
> "Robert Klemme" wrote:
> >
> > "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
> >
> >