[mssql]세션관리

SELECT * FROM sys.dm_exec_sessions

 

 

현재접속자 수 확인

SELECT DB_NAME(dbid) as DB이름, COUNT(dbid) as 접속자수
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid

 

 

현재접속중인 연결정보

SELECT S.spid, S.loginame, S.login_time, S.last_batch, C.client_net_address
FROM sys.sysprocesses S, sys.dm_exec_connections C
WHERE S.spid = C.session_id

 

 

 

 

https://docs.microsoft.com/ko-kr/sql/relational-databases/system-stored-procedures/sp-who-transact-sql?view=sql-server-ver15 

sp_who(Transact-SQL) - SQL Server