SQL - Get Number of Open Connections

Source: Retrieve Number of Open Connections | thiscodeWorks

SELECT DB_NAME(dbid) as "Database", COUNT(dbid) as "Number Of Open Connections",
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame;

For SQL Server.

---

Appendix: Links

• Code
• SQL
• Databases
• SQL Server
• Development

Backlinks:

list from [[SQL - Get Number of Open Connections]] AND -"Changelog"