Number of current connections?

How do you find out the current number of connections to a SQL Server 2005 instance in SQL Server Managment Studio? I need to see if my number of connections is exceeding my Maximum Worker Threads.

Thanks,

Joe

You can use execute "EXEC sp_who" or "EXEC sp_who2" and look for the information about which application is using the connection. This is also built into the management studio under Management -> Activity Monitor.

Also there is a system monitor (sysmon.exe) you can use on your system to monitor the number of concurrent connections, the number of connection pools, etc.

--Nathan Zaugg

|||

This will work:

-- Get SQL users that are connected and how many sessions they have

SELECT login_name,count(session_id)as session_count

FROMsys.dm_exec_sessions

GROUPBY login_name