Is this the best way to find what processes in the dataserver have the highest cpu usage.
(1) select top 10 * from master..sysprocesses order by physical_io desc.
(2) check for the showplan of these processes using sp_showplan.
(3) check for dbcc sqltext to find out what the processes are doing.
If not can you pls share your method.Help appreciated.