SQL Server query for the number of connection requests that are currently _mssql2005

SQL Server itself provides such a DMV to return this information, which is sys.dm_exec_sessions.
For example, do a query on my machine:

Copy Code code as follows:

SELECT * from sys.dm_exec_sessions WHERE host_name isn't NULL

　　
As shown in figure:

We can also group by login name:

Copy Code code as follows:

SELECT login_name, COUNT (session_id) as Session_count
From sys.dm_exec_sessions
GROUP by Login_name;

Query results as shown in figure:

For a detailed field description of this table, refer to the msdnhttp://msdn.microsoft.com/en-us/library/ms176013.aspx