[Go] How to query the number of SQL Server connections

1. Get the maximum number of simultaneous user connections allowed by SQL Server

SELECT @ @MAX_CONNECTIONS

2. Get connection information for the currently specified database

SELECT * from master.dbo.sysprocesses where dbid in (select dbid from master.dbo.sysdatabases where Name=" yourdatabasename ' )
as needed

SELECT * from master.dbo.sysprocesses WHERE db_name(dbid) = 'yourdatabasename'

3. Get all connection details for the current SQL Server

SELECT * from sysprocesses

The above query results include: System process and user process.

If you just want to check the user process, you need to use the following method

4. Gets the number of connections or attempts to connect since the last time the SQL Server service was started

SELECT @ @CONNECTIONS

This is a bit of a misunderstanding at first, considered to be the current number of connections for all SQL Server servers. Need to focus attention.

[Go] How to query the number of SQL Server connections