SQL Server 查询用户登录信息及连接数等

原创

已于 2025-02-13 13:58:22 修改 · 784 阅读

标签

#数据库 #SQL Server #运维

收录于

于 2025-01-16 13:30:00 首次发布

查询用户登录信息：

SELECT ds.session_id,
   ds.status,
   Db_name(dr.database_id) AS database_name,
   ds.login_name,
   ds.login_time,
   ds.host_name,
   ds.program_name,
   dc.client_net_address,
   dc.client_tcp_port,
   dr.cpu_time,
   dr.reads,
   dr.writes,
   dc.num_reads,
   dc.num_writes,
   ds.client_interface_name,
   ds.last_request_start_time,
   ds.last_request_end_time,
   dc.connect_time,
   dc.net_transport,
   dc.net_packet_size,
   dr.start_time,
   dc.client_net_address '客户端IP',
   dc.local_net_address '服务器IP',
   dr.status,
   dr.command,
   dr.blocking_session_id,
   dr.wait_type,
   dr.wait_time,
   dr.last_wait_type,
   dr.wait_resource,
   dr.open_transaction_count,
   dr.percent_complete,
   dr.granted_query_memory
FROM   sys.dm_exec_requests dr WITH(nolock)
   RIGHT OUTER JOIN sys.dm_exec_sessions ds WITH(nolock)
 ON dr.session_id = ds.session_id
   RIGHT OUTER JOIN sys.dm_exec_connections dc WITH(nolock)
 ON ds.session_id = dc.session_id
WHERE  ds