【SQLSERVER】How to check current pool size
时间:2017-09-08 14:31:12
收藏:0
阅读:262
SELECT des.program_name , des.login_name , des.host_name , COUNT(des.session_id) [Connections] FROM sys.dm_exec_sessions des INNER JOIN sys.dm_exec_connections DEC ON des.session_id = DEC.session_id WHERE des.is_user_process = 1 AND des.status != ‘running‘ GROUP BY des.program_name , des.login_name , des.host_name HAVING COUNT(des.session_id) > 2 ORDER BY COUNT(des.session_id) DESC
原文:http://www.cnblogs.com/sekihin/p/7494258.html
评论(0)