Header Ads

SQL Server – @@MAX_CONNECTIONS vs @@CONNECTIONS

Difference between @@MAX_CONNECTIONS and @@CONNECTIONS
 alt=
@@MAX_CONNECTIONS in SQL Server returns maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by default is 32,767,this number also depends on application and server hardware limits. This can also be configured at server level to avoid too many connections.

@@CONNECTIONS returns number of connection attempts (successful/failed) made to SQL Server since SQL Server is started. Since this include all attempts it can be greater than @@MAX_CONNECTIONS.

Syntax:
SELECT [MaximumAllowed]  = @@MAX_CONNECTIONS,
       [ConnectionAttempts] = @@CONNECTIONS

No comments:


Powered by Blogger.