4  

This shows the no of connections per each DB:

这显示了每个DB的连接数:

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

And this gives the total:

这就给出了总数:

SELECT 
    COUNT(dbid) as TotalConnections
FROM
    sys.sysprocesses
WHERE 
    dbid > 0

If you need more detail, run:

如果你需要更多的细节，运行:

sp_who2 'Active'

1  

You should be able to use PerfMon SQL Server counters against the SQL Server instance to monitor open connections to the server external to your application...particularly as your application (likely) is abstracted from specific connections, definitely if you are using Connection Pooling

您应该能够针对SQL Server实例使用PerfMon SQL Server计数器来监视对应用程序外部服务器的开放连接……特别是当您的应用程序(很可能)从特定的连接中抽象出来时，如果您正在使用连接池，那么肯定是这样

Here is a quick article on someone demonstrating the problem and monitoring it

这里有一篇关于某人演示问题并监视它的文章