| We will use 2 keyword to check the connection first one is maximum number of simultaneous user connections allowed. Maximum user connections allowed by SQL Server by default is 32,767. And second number is returns number of connection attempts (successful/failed) made to SQL Server since SQL Server is started.
SELECT [No_Of_ConnectionAttempts] = @@CONNECTIONS,
[No_Of_MaximumAllowed] = @@MAX_CONNECTIONS | | |