How to know which transaction used more than 1 CPU ?

I am using the SQL profiler to monitor my server. I am
trying to search for those queries who seem to put bussy
all the 8 cpu's that my server has.
I can see a CPU column which has some values, but how can
I know if that particular statement used more than one
CPU ?
Thanks in advance,Profiler will not give you that information. In fact I don't really think it
would be of much use. SQL Server may spawn extra threads to complete a
query, depending on the parallelism the optimizer uses and those threads
will show up in Profiler as new "connections' to the server.
Jim
<craigkenisston@.hotmail.com> wrote in message
news:0c3a01c3d573$bc2ee0d0$a001280a@.phx.gbl...
> I am using the SQL profiler to monitor my server. I am
> trying to search for those queries who seem to put bussy
> all the 8 cpu's that my server has.
> I can see a CPU column which has some values, but how can
> I know if that particular statement used more than one
> CPU ?
> Thanks in advance,
>|||| I am using the SQL profiler to monitor my server. I am
| trying to search for those queries who seem to put bussy
| all the 8 cpu's that my server has.
|
| I can see a CPU column which has some values, but how can
| I know if that particular statement used more than one
| CPU ?
--
Hi Craig,
From SQL profiler, You can monitor parallelism using the Execution Plan
event under the Performance category. You can inspect the execution tree
and view if parallelism was used in the query.
Hope this helps,
--
Eric Cárdenas
SQL Server support