Current Sessions

• session courante sur toutes les BDD

SELECT conn.session_id,sess.status, host_name, DBs.name,
    nt_domain, login_name, connect_time, last_request_end_time 
FROM sys.dm_exec_sessions AS sess
JOIN sys.dm_exec_connections AS conn
   ON sess.session_id = conn.session_id
JOIN sys.databases As DBs
	ON sess.database_id = DBs.database_id
order by DBs.name;

• Total session par BDD

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame;
 

• LOCK

select cmd,* from sys.sysprocesses
where blocked > 0
 
select cmd,* from sys.sysprocesses
where spid='162'
 
kill 162