Gets the total CPU time and total memory usage for a user's session. DMV

6/11/2015 - 8:10 PM

select nt_user_name, sum(cpu_time) as CPUTime, sum(memory_usage) as MemoryUsage from sys.dm_exec_sessions group by nt_user_name

Cacher is the code snippet organizer for pro developers