Find number of connection attempts since SQL Server start - @@connections

30 January,2013 by Jack Vamvas

Question: How can I find the number of sql server connection attempts on a SQL Server Instance since the last SQL Server restart?

Answer: According to SQL Server BOL  @@connectionsReturns the number of attempted connections, either successful or unsuccessful since SQL Server was last started

select @@connections as 'Login Attempts'


Sometimes there is confusion between user count and connections. These two are not always the same. Multi – tier applications , can open multiple connections as part of the interaction with the database server. Within one application process, it is not unusual for an application to open and close connections ,  either as explicit or implicit


Read More

SQL Kill connections to a database - SQL Server DBA

SQL Sever - Dedicated Administrator Connection - SQL Server

An existing connection was forcibly closed by the remote host

Author: Jack Vamvas (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Find number of connection attempts since SQL Server start - @@connections | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer