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,
>

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/useritem...ement_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,
>sql

Check active SQL server 2000 users/connections

How can I check how many users are connected to my SQL 2000 db. Monitor how
many users are active on the database.
regards
simonOn Jul 4, 1:20 pm, Simon79 <Simo...@.discussions.microsoft.com> wrote:
> How can I check how many users are connected to my SQL 2000 db. Monitor ho
w
> many users are active on the database.
> regards
> simon
To check connected sessions
select * from master..sysprocesses where spid > 50
You can check
select spid, datediff(minute,last_batch ,getdate()) from
master..sysprocesses where spid > 50
for how many minutes the session was idle|||Pls try sp_who2 'active'
HTH,
Paul Ibison|||Hi
sp_who 'active'
"Simon79" <Simon79@.discussions.microsoft.com> wrote in message
news:E3126647-65E7-4CDA-B6C8-D4AC4505E165@.microsoft.com...
> How can I check how many users are connected to my SQL 2000 db. Monitor
> how
> many users are active on the database.
> regards
> simon|||Thanx, all your solutions worked great!

Check active SQL server 2000 users/connections

How can I check how many users are connected to my SQL 2000 db. Monitor how
many users are active on the database.
regards
simon
On Jul 4, 1:20 pm, Simon79 <Simo...@.discussions.microsoft.com> wrote:
> How can I check how many users are connected to my SQL 2000 db. Monitor how
> many users are active on the database.
> regards
> simon
To check connected sessions
select * from master..sysprocesses where spid > 50
You can check
select spid, datediff(minute,last_batch ,getdate()) from
master..sysprocesses where spid > 50
for how many minutes the session was idle
|||Pls try sp_who2 'active'
HTH,
Paul Ibison
|||Hi
sp_who 'active'
"Simon79" <Simon79@.discussions.microsoft.com> wrote in message
news:E3126647-65E7-4CDA-B6C8-D4AC4505E165@.microsoft.com...
> How can I check how many users are connected to my SQL 2000 db. Monitor
> how
> many users are active on the database.
> regards
> simon
|||Thanx, all your solutions worked great!

Check active SQL server 2000 users/connections

How can I check how many users are connected to my SQL 2000 db. Monitor how
many users are active on the database.
regards
simonOn Jul 4, 1:20 pm, Simon79 <Simo...@.discussions.microsoft.com> wrote:
> How can I check how many users are connected to my SQL 2000 db. Monitor how
> many users are active on the database.
> regards
> simon
To check connected sessions
select * from master..sysprocesses where spid > 50
You can check
select spid, datediff(minute,last_batch ,getdate()) from
master..sysprocesses where spid > 50
for how many minutes the session was idle|||Pls try sp_who2 'active'
HTH,
Paul Ibison|||Hi
sp_who 'active'
"Simon79" <Simon79@.discussions.microsoft.com> wrote in message
news:E3126647-65E7-4CDA-B6C8-D4AC4505E165@.microsoft.com...
> How can I check how many users are connected to my SQL 2000 db. Monitor
> how
> many users are active on the database.
> regards
> simon|||Thanx, all your solutions worked great!