Select @@MAX_Connections as MaxConn
Using this you will get the Max number of connection get allowed on an instance of sql server.
- now if you want to know how many attempted connection are then
Select @@Connections as TotalNumberOfLogin
It will gives you all the number of connection was happen when the sql server get started , that may be a successful or unsuccessful connections also.
- You can also check this all using this system store procedure call
This will gives you result on when server get running , cpu time , usage , amount of data sending receiving , total number of read write operation done plus is there any error on connection like that .