Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

connections sleeping Expand / Collapse
Author
Message
Posted Tuesday, June 5, 2007 11:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:55 AM
Points: 33, Visits: 329
i have a doubt, when i execute sp_who the display send me de current conections, but almost case there are a connections with the following information

53 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 msdb AWAITING COMMAND
54 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND
55 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND
56 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND
57 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND

as you would see, is to me system information that it`s sleeping, and i have more, near to 100 processes that appear daily, could you help me how clearing this proccesses, maybe with a period of time, thank a lot
Post #371400
Posted Monday, January 28, 2013 1:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 14, 2014 2:09 AM
Points: 4, Visits: 49
U can use
DBCC FREEPOCCACHE Command to clear them regularly or
create a job that will do late in the night

for more info refer http://msdn2.microsoft.com/en-us/library/ms174283.aspx

Post #1412246
Posted Monday, January 28, 2013 2:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 43,042, Visits: 36,201
Rahim-441309 (1/28/2013)
U can use
DBCC FREEPOCCACHE Command to clear them regularly or
create a job that will do late in the night


Errr... no. FreeProcCache does nothing to connections, it, as the command's name implies, frees the procedure cache, which is a bad thing on a production server.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1412253
Posted Monday, January 28, 2013 2:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 43,042, Visits: 36,201
Angel DBA Mex (6/5/2007)
could you help me how clearing this proccesses, maybe with a period of time, thank a lot


Why?

A sleeping connection is not doing anything, it's waiting for some input from the application. What's the problem that lots of sleeping connections is causing, why do you want to remove them?

Do you know what impact it'll have on the application if those connections are killed? Will the app handle the loss of connection or will it throw errors the next time the user tries anything?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1412256
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse