Sessions actives – Scripts Center

Ce script affiche la liste des sessions actives

/*-------------------------------------------------------------------
[SCRIPT] sessions.sql   
[DATABASE] master
[DESCRIPTION] Active sessions
[MAJ PAR] DATAFLY - Arian Papillon
-------------------------------------------------------------------*/
SELECT spid
     , status
     , hostname
     , program_name
     , cmd
     , cpu
     , physical_io
     , blocked
     , sysprocesses.dbid
     , CONVERT(sysname, RTRIM(loginame)) AS loginname
     , qt.*
     , spid AS 'spid_sort'
     , SUBSTRING(CONVERT(VARCHAR, last_batch, 111), 6, 5) + ' '
       + SUBSTRING(CONVERT(VARCHAR, last_batch, 113), 13, 9) AS 'last_batch_char'
     , request_id
FROM   sys.sysprocesses WITH ( NOLOCK )
       OUTER APPLY sys.dm_exec_sql_text(sysprocesses.sql_handle) AS qt
WHERE  spid > 50;
-- AND program_name LIKE 'xyz%';
-- AND loginame = 'xyz'

/*-------------------------------------------------------------------

[SCRIPT] sessions.sql

[DATABASE] master

[DESCRIPTION] Active sessions

[MAJ PAR] DATAFLY - Arian Papillon

-------------------------------------------------------------------*/

SELECT spid

, status

, hostname

, program_name

, cmd

, cpu

, physical_io

, blocked

, sysprocesses.dbid

, CONVERT(sysname, RTRIM(loginame)) AS loginname

, qt.*

, spid AS 'spid_sort'

, SUBSTRING(CONVERT(VARCHAR, last_batch, 111), 6, 5) + ' '

+ SUBSTRING(CONVERT(VARCHAR, last_batch, 113), 13, 9) AS 'last_batch_char'

, request_id

FROM sys.sysprocesses WITH ( NOLOCK )

OUTER APPLY sys.dm_exec_sql_text(sysprocesses.sql_handle) AS qt

WHERE spid > 50;

-- AND program_name LIKE 'xyz%';

-- AND loginame = 'xyz'