-- Hien thi cac ket noi tu cac IP address
SELECT ec.client_net_address, es.[program_name], es.[host_name], es.login_name,
COUNT(ec.session_id) AS [connection count]
FROM sys.dm_exec_sessions AS es
INNER JOIN sys.dm_exec_connections AS ec
ON es.session_id = ec.session_id
GROUP BY ec.client_net_address, es.[program_name], es.[host_name], es.login_name
ORDER BY ec.client_net_address, es.[program_name];
-- Hien thi cac ket noi tu cac login_name
SELECT login_name, COUNT(session_id) AS [session_count]
FROM sys.dm_exec_sessions
GROUP BY login_name
ORDER BY login_name;
Ảnh minh họa sau khi chạy script trên SQL Server Managemet
Trích: khanh.com.vn
Unknown
Thứ Năm, 15 tháng 3, 2012
Kênh tư vấn
Published:
2012-03-15T08:56:00-07:00
Title:Script kiểm tra các kết nối đến SQL Server
Rating:
5 On
22 reviews