cpu utilization

I use the query below in relation to using Process explorer.

SELECT 
 r.session_id, st.text, qp.query_plan, r.status, os_thread_id
FROM 
 sys.dm_os_threads AS ot
 JOIN sys.dm_os_tasks AS t ON t.worker_address = ot.worker_address
 JOIN sys.dm_exec_requests AS r ON t.session_id = r.session_id
 CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st
 CROSS APPLY sys.dm_exec_query_plan(r.plan_handle) AS qp

A video from Jonathan that will walk you through it is here (saved me a few times - thanks!)

I work with 2 monitors, so that you can have PE in one windows showing the tread that is consuming high CPU and the query in the other windows with the related SQL.

You can use this DMV :)

SELECT TOP 10 (total_worker_time * 1.0) / 1000000 AS CPU_Utilized_in_Seconds, text,* FROM sys.dm_exec_query_stats CROSS APPLY sys.dm_exec_sql_text(sql_handle)