SQLServer Connection Monitor

SELECT T1.session_id AS [SessionId]
  
, T1.host_process_id AS [HostPid]
  
, DB_NAME(T3.dbid) AS [Database]
  
, T1.HOST_NAME AS [Host]
  
, T1.program_name AS [ApplicationName]

   T1.login_name AS [UserName]
  
, T2.client_net_address AS [IP]
  
, T1.cpu_time AS [Cpu]
  
, T1.memory_usage AS [Ram]
  
, T4.Connections AS [Connections]
  
, T4.net_transport AS [NetTransport]
  
, T2.net_packet_size AS [NetPacketSize]
  
, '[' + DB_NAME(T3.dbid) + '].['
    
+ object_schema_name(T3.objectid, T3.dbid) + '].['
    
+ OBJECT_NAME(T3.objectid, T3.dbid) + ']' AS [ObjectName]
  
, T3.TEXT AS [Query]

FROM sys.dm_exec_sessions T1
INNER JOIN sys.dm_exec_connections T2 ON T2.session_id = T1.session_id
CROSS APPLY sys.dm_exec_sql_text(T2.most_recent_sql_handle) T3
INNER JOIN
(
  
SELECT T1.dbid, T1.spid, T2.net_transport, COUNT(T1.dbid) AS [Connections]
  
FROM sys.sysprocesses T1
  
INNER JOIN sys.dm_exec_connections T2 ON T1.spid = T2.session_id
  
GROUP BY dbid, T1.spid, T2.net_transport

) T4 ON T4.spid = T1.session_id
ORDER BY Connections DESC, Cpu DESC, Ram DESC

No hay comentarios:

Publicar un comentario