SqlServer用户连接数查询及统计脚本

来源：互联网发布：国内音乐节数据编辑：程序博客网时间：2024/06/11 06:01
---查看当前数据库系统所有请求情况.SELECT ds.session_id,       ds.status,       Db_name(dr.database_id) AS database_name,       ds.login_name,       ds.login_time,       ds.host_name,       dc.client_net_address,       dc.client_tcp_port,       ds.program_name,       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,       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_memoryFROM   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_idWHERE  ds.session_id > 50ORDER  BY ds.program_name----用户连接数SELECT login_name,       Count(0) user_countFROM   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_idWHERE  ds.session_id > 50GROUP  BY login_nameORDER  BY user_count DESC
0 0