Monitoring the number of concurrent sessions in SLQ Server

HI:
Is it possible to know the number of concurrent sesions
that are working in a SQL Server?
Im talking about sessions that are doing something
in the SQLServer in a certain period of time; not only
those
sessions that may be are users that are just logged but
doing
nothing (maybe in "Awaiting Command")
Regards.You can use sp_who (or sp_who2) with the ACTIVE parameter to see only spids
that are doing something.
--
Andrew J. Kelly
SQL Server MVP
"Jose Martinez" <jomapa01@.hotmail.com> wrote in message
news:008101c3a631$3e9ab340$a501280a@.phx.gbl...
> HI:
> Is it possible to know the number of concurrent sesions
> that are working in a SQL Server?
> Im talking about sessions that are doing something
> in the SQLServer in a certain period of time; not only
> those
> sessions that may be are users that are just logged but
> doing
> nothing (maybe in "Awaiting Command")
> Regards.
>|||Hi,
Execute the below query from Query Analyzer to identify the number of
sessions ,
select count(*) from master..sysprocesses
Thanks
Hari
MCDBA
"Jose Martinez" <jomapa01@.hotmail.com> wrote in message
news:008101c3a631$3e9ab340$a501280a@.phx.gbl...
> HI:
> Is it possible to know the number of concurrent sesions
> that are working in a SQL Server?
> Im talking about sessions that are doing something
> in the SQLServer in a certain period of time; not only
> those
> sessions that may be are users that are just logged but
> doing
> nothing (maybe in "Awaiting Command")
> Regards.
>|||Regards,
Jose.
>--Original Message--
>Hi,
>Execute the below query from Query Analyzer to identify
the number of
>sessions ,
>select count(*) from master..sysprocesses
>Thanks
>Hari
>MCDBA
>
>"Jose Martinez" <jomapa01@.hotmail.com> wrote in message
>news:008101c3a631$3e9ab340$a501280a@.phx.gbl...
>> HI:
>> Is it possible to know the number of concurrent sesions
>> that are working in a SQL Server?
>> Im talking about sessions that are doing something
>> in the SQLServer in a certain period of time; not only
>> those
>> sessions that may be are users that are just logged but
>> doing
>> nothing (maybe in "Awaiting Command")
>> Regards.
>
>.
>|||Regards,
Jose (Mexico City)
>--Original Message--
>You can use sp_who (or sp_who2) with the ACTIVE
parameter to see only spids
>that are doing something.
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Jose Martinez" <jomapa01@.hotmail.com> wrote in message
>news:008101c3a631$3e9ab340$a501280a@.phx.gbl...
>> HI:
>> Is it possible to know the number of concurrent sesions
>> that are working in a SQL Server?
>> Im talking about sessions that are doing something
>> in the SQLServer in a certain period of time; not only
>> those
>> sessions that may be are users that are just logged but
>> doing
>> nothing (maybe in "Awaiting Command")
>> Regards.
>
>.