[mssql]세션관리
# DataBase/Mssql2022. 4. 26. 16:52[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/s..

image