[SQLServer] DWST 컨넥션 수 확인하기.
SELECT A.spid
, A.login_time
, A.loginame
, A.last_batch
, A.status
, A.program_name
, A.cmd
, B.client_net_address
FROM sys.sysprocesses A
JOIN sys.dm_exec_connections B
ON A.spid = B.session_id
WHERE 1=1
and A.program_name = 'Microsoft JDBC Driver for SQL Server'
order by A.login_time desc
, A.login_time
, A.loginame
, A.last_batch
, A.status
, A.program_name
, A.cmd
, B.client_net_address
FROM sys.sysprocesses A
JOIN sys.dm_exec_connections B
ON A.spid = B.session_id
WHERE 1=1
and A.program_name = 'Microsoft JDBC Driver for SQL Server'
order by A.login_time desc