how many open connections?

How do I tell how many connections to the db there are? sp_who always has
lots of "backgrounds" and "sleeping" in it so thats not reall accurate. I
was thinking to open Profiler and use the "existing connections" option but
was wondering if there is a better way?
TIA, ChrisREXEC sp_who 'active'
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ChrisR" <noemail@.bla.com> wrote in message
news:uJ%232hKDeFHA.3932@.TK2MSFTNGP12.phx.gbl...
> How do I tell how many connections to the db there are? sp_who always has
> lots of "backgrounds" and "sleeping" in it so thats not reall accurate. I
> was thinking to open Profiler and use the "existing connections" option
> but was wondering if there is a better way?
>
> TIA, ChrisR
>|||That will show you the Active connections.
If you need to know the exact number, query sysprocesses.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e4uAgYDeFHA.580@.TK2MSFTNGP15.phx.gbl...
> EXEC sp_who 'active'
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ChrisR" <noemail@.bla.com> wrote in message
> news:uJ%232hKDeFHA.3932@.TK2MSFTNGP12.phx.gbl...
>|||Thanks Mike... but heres what I dont get. I have a local sql server on my
desktop. No replication, the server agent isnt on, I have 2 open Query
Analyzer and 1 open Enterprise Manager. Both the sp_who 'active' and shows
13 connections, sysprocesses show 16. What is making up all these
connections?
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OCTL4cDeFHA.3816@.TK2MSFTNGP10.phx.gbl...
> That will show you the Active connections.
> If you need to know the exact number, query sysprocesses.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:e4uAgYDeFHA.580@.TK2MSFTNGP15.phx.gbl...
>|||Client processes are those with spid > 50. The other ones are background
server processes e.g lazy writer, lock monitor, log writer etc. There can be
a variable number of these dependent on load an other factors. I fyou're
just interested in client connections then you need to filter on spid>50
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ChrisR" <noemail@.bla.com> wrote in message
news:e6fHU1DeFHA.4040@.TK2MSFTNGP14.phx.gbl...
> Thanks Mike... but heres what I dont get. I have a local sql server on my
> desktop. No replication, the server agent isnt on, I have 2 open Query
> Analyzer and 1 open Enterprise Manager. Both the sp_who 'active' and shows
> 13 connections, sysprocesses show 16. What is making up all these
> connections?
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:OCTL4cDeFHA.3816@.TK2MSFTNGP10.phx.gbl...
>|||Awesome. Thanks to both of you.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23n89iOEeFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Client processes are those with spid > 50. The other ones are background
> server processes e.g lazy writer, lock monitor, log writer etc. There can
> be a variable number of these dependent on load an other factors. I
> fyou're just interested in client connections then you need to filter on
> spid>50
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "ChrisR" <noemail@.bla.com> wrote in message
> news:e6fHU1DeFHA.4040@.TK2MSFTNGP14.phx.gbl...
>