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