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.
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!
One thought on “@@CONNECTIONS & @@MAX_CONNECTIONS in SQL Server”