Summary: How to query the number of SQL server connections

Recently, some customers want to listen on the number of connections of SQL Server. I summarized the following methods (the heroes in the hope garden provided some suggestions)

1. obtain the maximum number of concurrent user connections allowed by SQL Server

 

 SELECT @@MAX_CONNECTIONS

 

 

2. Obtain the connection information of the current specified database

 

 Select * from Master. DBO. sysprocesses where dbid in
(
Select dbid from Master. DBO. sysdatabases
Where name = 'yourdatabasename'
)

-- Change yourdatabasename as needed

 

 SELECT * FROM master.dbo.sysprocesses WHERE DB_NAME(dbid) = 'YourDataBaseName'

 

 

3. Obtain all connection details of the current SQL Server

 

 SELECT * FROM sysprocesses

The preceding query results include system and user processes.

If you only want to check the user process, use the following method:

 

4. Obtain the number of connections or attempted connections since the last time the SQL Server service was started.

 

 SELECT @@CONNECTIONS

 

 This may be a bit wrong at the beginning. It is regarded as the current number of connections of the current SQL Server server. Pay attention to it.