Check the connected session in SQL Server

Check the session connected in SQL Server:

exec sp_who
exec sp_who2

Check the login time of the session

SELECT
    c.session_id, c.net_transport, c.encrypt_option,
    c.auth_scheme, s.host_name, s.program_name,
    s.client_interface_name, s.login_name, s.nt_domain,
    s.nt_user_name,   s.login_time
FROM sys.dm_exec_connections AS c
JOIN sys.dm_exec_sessions AS s
    ON c.session_id = s.session_id
WHERE c.session_id = @@SPID;

Check the session running query in SQL Server

select 
SDES.session_id,SDES.login_name,
SDES.login_time,SDES.host_name,
SDES.status,SDES.last_request_end_time,
DEST.TEXT  
from sys.dm_exec_sessions SDES 
inner join sys.dm_exec_connections SDEC on SDES.session_id=SDEC.session_id  
CROSS APPLY sys.[dm_exec_sql_text](SDEC.[most_recent_sql_handle]) AS DEST 
where SDES.status in ('RUNNING', 'RUNNABLE', 'SUSPENDED')

Check the session connected to a particular database

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame