Différences

Ci-dessous, les différences entre deux révisions de la page.

--- sql_server:instance:current_session [07/05/2024 12:49] – mdl
+++ sql_server:instance:current_session [02/12/2024 16:39] (Version actuelle) – mdl
@@ Ligne 1: / Ligne 1: @@
 ====== Current Sessions ======
+  * session courante sur toutes les BDD
 <code TSQL>
-SELECT s.session_id, s.login_time,  s.program_name,
+SELECT conn.session_id,sess.status, host_name, DBs.name,
-s.host_name,s.login_name,  c.auth_scheme,
+    nt_domain, login_name, connect_time, last_request_end_time
-s.database_id, DB_NAME(s.database_id) AS [database],
+FROM sys.dm_exec_sessions AS sess
-s.status,
+JOIN sys.dm_exec_connections AS conn
-s.reads, s.writes, s.logical_reads, s.row_count,
+   ON sess.session_id = conn.session_id
-c.session_id,
+JOIN sys.databases As DBs
-c.client_net_address, c.client_tcp_port,
+	ON sess.database_id = DBs.database_id
-c.num_writes AS DataPacketWrites
+order by DBs.name;
-FROM sys.dm_exec_sessions s
+</code>
-INNER JOIN sys.dm_exec_connections c
-ON s.session_id = c.session_id
+  * Total session par BDD
-INNER JOIN sys.dm_exec_requests r
+<code TSQL>
-ON s.session_id = r.session_id
+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>