![[mssql]세션관리](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FbOlWgb%2FbtrCebjyWBR%2FAAAAAAAAAAAAAAAAAAAAAEsFthdXXKuxy9U6BNJMdpqA3H_Co2jpPfg8ctIejEg-%2Fimg.jpg%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1753973999%26allow_ip%3D%26allow_referer%3D%26signature%3DMK2fxHDikIMP13EYME5rLE04YJ4%253D)
# 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..