Notice
Recent Posts
Recent Comments
Link
«   2025/05   »
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Tags
more
Archives
Today
Total
관리 메뉴

노우!쑤

[MSSQL 쿼리]커넥션 확인 본문

DevOps

[MSSQL 쿼리]커넥션 확인

no500 2021. 6. 21. 14:08
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
 SELECT * FROM sys.dm_os_performance_counters WHERE counter_name = 'User Connections'

 

'DevOps' 카테고리의 다른 글

[Kibana] TLS 설정  (0) 2021.06.22
[Metricbeat] elasticsearch-xpack  (0) 2021.06.21
[Metricbeat] IIS  (0) 2021.06.17
[ElasticAPM] 모니터링  (0) 2021.05.28
[Docker]Docker Registry 사용하기  (0) 2021.05.20