Tag: bulk of the connections originate in SQL SERVER

  SELECT dec.client_net_address , des.program_name , des.host_name , –des.login_name  COUNT(dec.session_id) AS connection_count FROM sys.dm_exec_sessions AS des INNER JOIN sys.dm_exec_connections AS

Continue reading