====== Current Sessions ======
  * session courante sur toutes les BDD 
<code TSQL>
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;
</code>

  * Total session par BDD
<code TSQL>
SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame;
    </code>

  * LOCK    
<code TSQL>    
select cmd,* from sys.sysprocesses
where blocked > 0

select cmd,* from sys.sysprocesses
where spid='162'

kill 162
</code>