Skip to content

Instantly share code, notes, and snippets.

@ArtemAvramenko

ArtemAvramenko/current-sql-server-connections.sql

Last active April 12, 2019 12:45
Show Gist options
  • Save ArtemAvramenko/642aac6ebac75c77243c5a347892a1fa to your computer and use it in GitHub Desktop.
Save ArtemAvramenko/642aac6ebac75c77243c5a347892a1fa to your computer and use it in GitHub Desktop.
Download ZIP
Query current SQL Server connections
Raw
current-sql-server-connections.sql
select
count = count(*),
db_name = db_name(database_id),
status,
login_name,
host_name,
program_name
from sys.dm_exec_sessions
where is_user_process = 1
group by database_id, status, login_name, host_name, program_name
order by 1 desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment