[MSSSQL] Xem số connection vào DB MSSQL

-- Get a count of SQL connections by login_name
select loginame, count(loginame)as Connections from master.dbo.sysprocesses
group by loginame
ORDER BY Connections desc

-----SQL 2012 tro len
SELECT DB_NAME(database_id) as DBName,
login_name,
COUNT(session_id) as NumberOfConnections
FROM sys.dm_exec_sessions
GROUP BY database_id, login_name
order by NumberOfConnections desc;

-- Get a count of SQL connections by IP address
SELECT ec.client_net_address, es.[program_name],
es.[host_name], es.login_name,
COUNT(ec.session_id) AS [connection count]
FROM sys.dm_exec_sessions AS es
INNER JOIN sys.dm_exec_connections AS ec
ON es.session_id = ec.session_id 
GROUP BY ec.client_net_address, es.[program_name], es.[host_name], es.login_name
ORDER BY [connection count] desc;