Cacher is the code snippet organizer for pro developers

USE lion

 

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0 and DB_NAME(dbid) = 'lion'

 

GROUP BY 
    dbid, loginame
    ORDER by DBName, NumberOfConnections  desc
;

 

SELECT DB_NAME(sP.dbid) AS the_database
    , COUNT(sP.spid) AS total_database_connections
FROM sys.sysprocesses sP
where DB_NAME(dbid) = 'lion'
GROUP BY DB_NAME(sP.dbid)
ORDER BY 2 desc;