To find this information
we can use @@MAX_CONNECTIONS global variable.
@@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 cam 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.
SELECT
[ConnectionAttempts] = @@CONNECTIONS
,[MaximumAllowed] = @@MAX_CONNECTIONS
No comments:
Post a Comment