Below query identifies sources of multiple connections to your SQL Server instance and also allow DBA to identify where the
bulk of the connections are originating for each of their SQL Server instances.
— connections count on SQL Server by IP address
SELECT dec.client_net_address ,
des.program_name ,
des.host_name ,
COUNT(dec.session_id) AS connection_count
FROM sys.dm_exec_sessions AS des
INNER JOIN sys.dm_exec_connections AS dec
ON des.session_id = dec.session_id
GROUP BY dec.client_net_address ,
des.program_name ,
des.host_name
ORDER BY des.program_name,
dec.client_net_address ;
you can output like this:-
