blinds52
4/15/2017 - 6:50 PM

List active connections to Microsoft SQL Server database.

List active connections to Microsoft SQL Server database.

README.md
content_copyfile_download
  • Rendered
  • Source

List active connections to Microsoft SQL Server database

Via the master.dbo.sysprocesses system table.

Query example

SELECT [hostname],COUNT(*)
FROM master.dbo.sysprocesses
WHERE
    ([dbid] = db_id('DATABASE_NAME')) AND
    ([spid] > 50)
GROUP BY [hostname]
ORDER BY 2 DESC

  • Where spid is the session ID, greater than 50 are user processes (what we care about).

  • A listing of database IDs can be returned via:

    SELECT [name],[dbid]
FROM master.dbo.sysdatabases