正文
SQL中查询现有未释放连接
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
SELECT
dbid,count()
FROM
[Master].[dbo].[SYSPROCESSES]
WHERE spid> and status='sleeping'group by dbid
order by count() descselect * from master.dbo.sysprocesses where spid>
and waittype = 0x0000
and waittime =
and status = 'sleeping'
and last_batch < dateadd(minute, -, getdate())
and login_time < dateadd(minute, -, getdate())