SELECT host_name,program_name,client_interface_name,(memory_usage * 8) AS 'memory usage Kb' FROM sys.dm_exec_sessions
ORDER BY memory_usage DESC

SELECT host_name,SUM (memory_usage * 8 /1024) AS 'memory usage mb' FROM sys.dm_exec_sessions
GROUP BY host_name
ORDER BY 'memory usage mb' DESC