当前位置：Gxlcms >
数据库问题 >
【SQLSERVER】How to check current pool size
【SQLSERVER】How to check current pool size
时间：2021-07-01 10:21:17
帮助过：8人阅读
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
【SQLSERVER】How to check current pool size
标签：having roc user log _id running group and name
