From a DBAs perspective it is always important to monitor the number of connections that are targeting the database from a specific session id. This can be achieved by joining the DMV’s sys.dm_exec_sessions and sys.dm_exec_connections. The interesting part of the query is it captures the end client IP address as well as the client’s hostname. Below is the sql:
SELECT DMEC.CLIENT_NET_ADDRESS as "Client's IP Address", DMES.[PROGRAM_NAME]as 'Program Name' , DMES.[HOST_NAME]as 'Client HostName' , DMES.LOGIN_NAME 'Login', COUNT(DMEC.SESSION_ID) AS [Number of Connections] FROM SYS.DM_EXEC_SESSIONS AS DMES INNER JOIN SYS.DM_EXEC_CONNECTIONS AS DMEC ON DMES.SESSION_ID = DMEC.SESSION_ID GROUP BY DMEC.CLIENT_NET_ADDRESS , DMES.[PROGRAM_NAME] , DMES.[HOST_NAME] , DMES.LOGIN_NAME ORDER BY DMEC.CLIENT_NET_ADDRESS , DMES.[PROGRAM_NAME]
Hope this helps.