SQL Server – Logins With More Than 1 Session

  By , ,

To get the logins with more than 1 session, you may use the script below.

SELECT  login_name ,
COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
WHERE is_user_process = 1
GROUP BY login_name
ORDER BY login_name

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – Identifying Current Running Queries with Database Name
  2. SQL Server – Capture Long Running Stored Procedures and Execution Count using Extended Events
  3. SQL Server – Capturing Blocking Information (Enhanced SQL Script)
  4. SQL SERVER – Merge Table Partitions
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *