Script to Check SQL Server Database Connections

SQL Server / DBA Leave a comment
  • More significant for Azure SQL Database to determine who all are connected from which IP address and how many connections
  • sys.dm_exec_sessions and sys.dm_exec_connections
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 WITH (NOLOCK) 
INNER JOIN sys.dm_exec_connections AS ec WITH (NOLOCK) 
	ON es.session_id = ec.session_id 
GROUP BY ec.client_net_address, es.[program_name], es.[host_name], es.login_name  
ORDER BY ec.client_net_address, es.[program_name] 
OPTION (RECOMPILE)