Skip to content

Instantly share code, notes, and snippets.

@jonny64bit

jonny64bit/CountSqlConnections.sql

Created August 3, 2017 09:01
Show Gist options
  • Save jonny64bit/8d1f2122ae0a7434f9296ac84b4d1ff9 to your computer and use it in GitHub Desktop.
Save jonny64bit/8d1f2122ae0a7434f9296ac84b4d1ff9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CountSqlConnections.sql
SELECT
DB_NAME(dbid) as DBName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment