- sur
2000
vous pouvez utilisersp_who2
ou la table systèmedbo.sysprocesses
- sur
2005
jetez un œil au DMVsys.dm_exec_sessions
Ci-dessous un exemple
SELECT COUNT(*) AS StatusCount,CASE status
WHEN 'Running' THEN 'Running - Currently running one or more requests'
WHEN 'Sleeping ' THEN 'Sleeping - Currently running no requests'
ELSE 'Dormant – Session is in prelogin state' END status
FROM sys.dm_exec_sessions
GROUP BY status