search

Home >Database >Mysql Tutorial >Find the active SQL connection and kill it!

Find the active SQL connection and kill it!

大家讲道理
大家讲道理Original
2016-11-10 11:39:02924browse

select
    db_name(dbid) as [Database Name], 
    count(dbid) as [No Of Connections],
    loginame as [Login Name]
from
    sys.sysprocesses
where
    dbid > 0
group by
    dbid, loginame

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SQL method to implement crosstabNext article：SQL method to implement crosstab

Related articles

See more