SQL @@CONNECTIONS

SQL @@CONNECTIONS is one of the System Statistical Function, which returns the number of connections since SQL server is last started. This includes both successful and unsuccessful connections.

Syntax behind this is @@CONNECTION is

@@CONNECTIONS

SQL @@CONNECTIONS Example

Below code snippet will show you the total number of connections for this SQL Server.

-- SQL Server @@CONNECTIONS Example
SELECT @@CONNECTIONS AS [Total Connections]

OUTPUT

You can use GETDATE() function along with this function to see the total number of connections until today.

-- SQL Server @@CONNECTIONS Example
SELECT @@CONNECTIONS AS [Total Log In Attempts],
	GETDATE() AS [As of Today]

OUTPUT