Quick Memo MSSQL : liste détaillée des sessions actives

Information de base via les procédures stockées : sp_who sp_who2 Script de base : SELECT DB_NAME(dbid) AS DBName, COUNT(dbid) AS NumberOfConnections, loginame FROM sys.sysprocesses GROUP BY dbid, loginame ORDER BY DB_NAME(dbid) Script affichant le plus de détails : USE master go SELECT sdes.session_id ,sdes.login_time ,sdes.last_request_start_time ,sdes.last_request_end_time ,sdes.is_user_process ,sdes.host_name ,sdes.program_name ,sdes.login_name ,sdes.status ,sdec.num_reads ,sdec.num_writes ,sdec.last_read ,sdec.last_write … Lire la suite