SELECT client_net_address 'Client IP Address', 
       local_net_address 'SQL Server IP Address',*
FROM sys.dm_exec_connections
WHERE session_id=@@SPID


SELECT cpu_time,language,date_format,date_first,
       transaction_isolation_level,lock_timeout,row_count
FROM sys.dm_exec_requests 

SELECT host_name,program_name,client_interface_name,nt_domain,nt_user_name,*
FROM sys.dm_exec_sessions
ORDER BY session_id DESC

SELECT lastwaittype,physical_io,loginame,*
FROM sys.sysprocesses