Search This Blog

Monday, March 7, 2011

SQL DBA - Get SQL users that are connected and how many sessions they have

SELECT login_name ,COUNT(session_id) AS [session_count]

FROM sys.dm_exec_sessions GROUP BY login_name ORDER BY COUNT(session_id) DESC ;

No comments: