mssql : database 들의 connections 커넥션 의 개수 확인하기

 mssql : database 들의 connections 커넥션 의  개수 확인하기

 

SELECT 
		DB_NAME(dbid) as DBName, 
		COUNT(dbid) as NumberOfConnections,
		loginame as LoginName
	FROM
		sys.sysprocesses
	WHERE 
		dbid > 0
	GROUP BY 
		dbid, loginame
	ORDER BY  COUNT(dbid) DESC

 

 

https://stackoverflow.com/a/43071894

How to monitor active connection pool in SQL Server?