check how many connections

Hi, how to check how many connections current be used?
Thanks,
sp_who2 will give you a rough idea. Any unique SPID above 50 is essentially
a different connection. There is a SQL Server perfmon counter for
connections as well.
Andrew J. Kelly SQL MVP
<js@.someone.com> wrote in message
news:e3$kLxzQHHA.1016@.TK2MSFTNGP04.phx.gbl...
> Hi, how to check how many connections current be used?
> Thanks,
>
|||Hello,
For SQL 2005, use the below dynamic management views to query connections
and sessions.
sys.dm_exec_connections
sys.dm_exec_sessions
Read the below article to know the usage and details. Please rate the
article if found useful.
http://www.codeproject.com/useritems/Dynamic_Management_Views.asp
Thanks
Hari
<js@.someone.com> wrote in message
news:e3$kLxzQHHA.1016@.TK2MSFTNGP04.phx.gbl...
> Hi, how to check how many connections current be used?
> Thanks,
>