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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability