Sql connections?

Help!  Our MOM server is displaying an alert saying there are 671 connection
s
on my sql database!  There is no way this should be happening.  The sql
database is running on a dell management server that is simply monitoring my
dell servers (of which there are about 20).  Where are these connections
coming from and how do I prevent this from happening?
Thanks!
Kelly

Try running the following :-

Sp_who2

Once connected to the SQL Server in question, in Query Analyser


--
HTH. Ryan


"Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
message news:E39254F2-B16C-4B4B-874F- CFEA3402A05B@microso
ft.com...
> Help!  Our MOM server is displaying an alert saying there are 671
> connections
> on my sql database!  There is no way this should be happening.  The sql
> database is running on a dell management server that is simply monitoring
> my
> dell servers (of which there are about 20).  Where are these connections
> coming from and how do I prevent this from happening?
> Thanks!
> Kelly

The connections were either the 'sa' account or the NT Authority\System
account.  Are these perhaps just running common processes but are not being
released or disconnected when they should be?  I really don't know much abou
t
sql server (as you can tell).

"Ryan" wrote:

> Try running the following :-
>
>     Sp_who2
>
> Once connected to the SQL Server in question, in Query Analyser
>
>
> --
> HTH. Ryan
>
>
> "Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
> message news:E39254F2-B16C-4B4B-874F- CFEA3402A05B@microso
ft.com... 
>
>
>

One of the columns returned by sp_who2 will be HostName. Are there numerous
connections coming from 1 hostname... if so you could try turning off that
PC to release connections.

To get rid of a single connection you can use the KILL command. KILL spid


--
HTH. Ryan


"Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
message news:D5871BB5-E705-4B9B-AC60- 7D7C5CAB5435@microso
ft.com...
> The connections were either the 'sa' account or the NT Authority\System
> account.  Are these perhaps just running common processes but are not
> being
> released or disconnected when they should be?  I really don't know much
> about
> sql server (as you can tell).
>
> "Ryan" wrote:
> 

Hi Ryan

Try out sp_who_3, which is available from
http://www.databasejournal.com/scri...cle.php/3391341

It has helped me in the past.

Regards,
Jan


"Ryan" <Ryan_Waight@nospam.hotmail.com> wrote in message
news:uN%23jKQIWGHA.3448@TK2MSFTNGP03.phx.gbl...
> One of the columns returned by sp_who2 will be HostName. Are there
> numerous connections coming from 1 hostname... if so you could try turning
> off that PC to release connections.
>
> To get rid of a single connection you can use the KILL command. KILL spid
>
>
> --
> HTH. Ryan
>
>
> "Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
> message news:D5871BB5-E705-4B9B-AC60- 7D7C5CAB5435@microso
ft.com... 
>
>

Ryan,
The HostName that showed up what either blank or had the name of my server
in it.  But, again, I had bounced the server so there are only about 20
connections at this time.
Thanks for the assistance though, it is greatly appreciated!

"Ryan" wrote:

> One of the columns returned by sp_who2 will be HostName. Are there numerou
s
> connections coming from 1 hostname... if so you could try turning off that
> PC to release connections.
>
> To get rid of a single connection you can use the KILL command. KILL spid
>
>
> --
> HTH. Ryan
>
>
> "Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
> message news:D5871BB5-E705-4B9B-AC60- 7D7C5CAB5435@microso
ft.com... 
>
>
>

Jan,
Thanks for the tip on that.  I actually sent it on to our resident sql dba
as I have no idea what I was supposed to do with it!  Sorry, but as I said, 
I
am not knowledgeable with sql server let alone running anything more
complicated than the sp_who2 procedure.  In any event, your help is greatly
appreciated!
Kelly

"Jan Van der Eecken" wrote:

> Hi Ryan
>
> Try out sp_who_3, which is available from
> http://www.databasejournal.com/scri...cle.php/3391341
>
> It has helped me in the past.
>
> Regards,
> Jan
>
>
> "Ryan" <Ryan_Waight@nospam.hotmail.com> wrote in message
> news:uN%23jKQIWGHA.3448@TK2MSFTNGP03.phx.gbl... 
>
>
>

You're welcome.

"Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
message news:06DA6902-5739-4E70-BA75- 3D77ECD6BEC9@microso
ft.com...
> Jan,
>  Thanks for the tip on that.  I actually sent it on to our resident sql
> dba
> as I have no idea what I was supposed to do with it!  Sorry, but as I
> said, I
> am not knowledgeable with sql server let alone running anything more
> complicated than the sp_who2 procedure.  In any event, your help is
> greatly
> appreciated!
> Kelly
>
> "Jan Van der Eecken" wrote:
>