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 @@connections “Returns 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