Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started.
Applies to: SQL Server (SQL Server 2008 through current version).
Connections are different from users. Applications, for example, can open multiple connections to SQL Server without the user observing the connections.
To display a report containing several SQL Server statistics, including connection attempts, run sp_monitor.
@@MAX_CONNECTIONS is the maximum number of connections allowed simultaneously to the server. @@CONNECTIONS is incremented with each login attempt, therefore @@CONNECTIONS can be greater than @@MAX_CONNECTIONS.
The following example shows returning the number of login attempts as of the current date and time.
SELECT GETDATE() AS 'Today''s Date and Time', @@CONNECTIONS AS 'Login Attempts';
Here is the result set.
Today's Date and Time Login Attempts ---------------------- -------------- 12/5/2006 10:32:45 AM 211023