@@VERSION, SERVERPROPERTY and @@MAX_CONNECTIONS Functions in SQL Server(TSQL)

The maximum number of connections that an instance can accept varies by version.

With the @@MAX_CONNECTIONS function, we can query the number of default maximum connections that the SQL Server version can accept.

With the @@VERSION function, we can query the version of an instance.

If we want to change the maximum number of connections that instance will accept, we can set it with sp_configure as follows. You must restart the service after running the following command. Restart operation will cause interruption.

NOTE: If you query @@MAX_CONNECTIONS again after running the following commands, the result will be the same as in the first query. Because @@MAX_CONNECTIONS returns the maximum number of connections that the SQL Server version can accept.

You can find detailed information about sp_configure in the article “sp_configure (Server-Level Configurations in SQL Server)

You can learn detail information about the instance with the below query:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *