심재운 블로그

반응형

 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?

I'm suspecting that my web application has connection leaks (getting the timeout and max connection reached error). So I wanted to monitor how many database connections are active in the pool. I'm ...

stackoverflow.com

 

반응형

댓글

비밀글모드