Скачать или смотреть How to determine total number of open/active connections in sql server?

SQL Query to Check Number of Connections on Database
Monitoring the Number of Connections
How to check active connections on your MS-SQL Database
Managing Maximum Number of Concurrent Connections in ...
how to check active sessions in sql server using query
sql server list all connections to a database
query to check database connection in sql server
sql show active connections to database
how to check running sessions in sql server
how to find number of concurrent users in sql server
how to check sql server connection
how to check maximum number of connections in sql
Video Chapters
01:60 sql
60:120 SQL Interview questions
120: 150 sql server
150:160 t sql
160:180 DBA
Script:
--sql server list all connections to a database
SELECT
DB_NAME(dbid) as DatabasesName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid put greater than 0
GROUP BY dbid, loginame

-- Total numberofconnections
SELECT
COUNT(dbid) as TotalNumberofConnections
FROM sys.sysprocesses
WHERE dbid greater than 0