InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 00:39:31 GMT20http://www.sqlservercentral.com/Forums/Topic371400-120-1.aspx[quote][b]Angel DBA Mex (6/5/2007)[/b][hr]could you help me how clearing this proccesses, maybe with a period of time, thank a lot[/quote]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?Mon, 28 Jan 2013 02:05:21 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic371400-120-1.aspx[quote][b]Rahim-441309 (1/28/2013)[/b][hr]U can use DBCC FREEPOCCACHE Command to clear them regularly or create a job that will do late in the night[/quote]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.Mon, 28 Jan 2013 02:03:13 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic371400-120-1.aspxU can use DBCC FREEPOCCACHE Command to clear them regularly or create a job that will do late in the nightfor more info refer http://msdn2.microsoft.com/en-us/library/ms174283.aspxMon, 28 Jan 2013 01:57:26 GMTRahim+971-501387269http://www.sqlservercentral.com/Forums/Topic371400-120-1.aspxi 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 information53 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 msdb AWAITING COMMAND54 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND55 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND56 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMAND57 0 sleeping NT AUTHORITY\SYSTEM SIMIMX-SIF2 0 master AWAITING COMMANDas 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 <!-- end sanitized html -->Tue, 05 Jun 2007 11:39:00 GMTAngel DBA Mex