one of the raw methods that goes back to SQL 2000 is to use sysprocesses. You have the CPU and Dbid column, that you can track with hostname and loginame columns. Or Use this
select scheduler_id, current_tasks_count, runnable_tasks_count
from sys.dm_os_schedulers where scheduler_id < 255
Maninder
www.dbanation.com