|
|
| Kelly Beauchaine 2006-04-04, 11:23 am |
| 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
| |
|
| 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
| |
| Kelly Beauchaine 2006-04-04, 11:23 am |
| 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:
> 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...[color=darkred]
> 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:
>
| |
| Jan Van der Eecken 2006-04-06, 8:23 pm |
| 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...
>
>
| |
| Kelly Beauchaine 2006-04-06, 8:23 pm |
| 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 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...
>
>
>
| |
| Kelly Beauchaine 2006-04-06, 8:23 pm |
| 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...
>
>
>
| |
| Jan Van der Eecken 2006-04-06, 8:23 pm |
| You're welcome.
"Kelly Beauchaine" < KellyBeauchaine@disc
ussions.microsoft.com> wrote in
message news:06DA6902-5739-4E70-BA75- 3D77ECD6BEC9@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|