Tag: @@CONNECTIONS & @@MAX_CONNECTIONS in SQL Server

@@CONNECTIONS & @@MAX_CONNECTIONS in SQL Server

@@CONNECTIONS

It returns the total number of connections that includes both successful and failed made to SQL Server since it is started or restarted. Honestly, I have not used this variable anywhere and still could not really able to figure out a use case as well. Readers can share your thoughts if there are any.

@@MAX_CONNECTIONS

It returns the maximum number of simultaneous connections allowed to a SQL Server. Maximum user connections allowed by SQL Server by default is 32,767.

If you enjoyed this blog post, please share it with your friends!