[System table] sysprocesses [System views or functions] sys.dm_exec_connections sys.dm_exec_sessions sys.dm_exec_requests [Type of view or function] 
Dynamic management view Dynamic management view Dynamic management view