Sleeping processes

Hi all, in Process Info Tool and I see lots (about 60)  processes with Status = 'sleeping' and Command = 'AWAITING COMMAND' (Application = '.Net SqlClient Data Provider')

it is very urgent

thanks and regards

D-
jytrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sigmaconCommented:
Hi jytr,

Usually these are not a problem, these are connections that have been established to the server, but aren't used. Make sure whichever users or applications are connecting to the server are only creating connection they need and closing connections they don't need. What do you mean with LOTS? 200, 400, 1000? or more ... ?
0
sigmaconCommented:
oops ... just saw the number of connections to be 60 from .NET ... that's USUALLY ok and no reason to concern. Do you know which .NET applications are connecting to your server?
0
ShogunWadeCommented:
The only time this is an issue (generally speaking) is if a naughty app is creating new connections all the time and not closing them.  If there are 60 .net clients running then its no problem.    If on the other hand there is 1 client with 60 connections then it's time to slap the .NET developer.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jytrAuthor Commented:
Hi all,the connectiln obj is being closed...do you think that setting Pooling=false at the end of the connection string could solve the issue ?
0
ShogunWadeCommented:
If the connections are being closed  and there is only one client then there should be no processes sleeping.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sigmaconCommented:
Did we answer you question? You said it was VERY URGENT?
0
jytrAuthor Commented:
sure sigmacon (smile)

0
healthcomputingCommented:
I am hoping I can start this one up again.  We are experiencing the same problem, but we are getting 500-2000+ sleeping connections, which are all .Net SqlClient Data Provider.  The DataReaders and Connections are all being closed, but still the sleeping connections are accumulating.  The problem gets so severe that we finally get a "General Network Error" or a "SSL Security Error", and we have to restart IIS.  We have done a lot of testing and not getting anywhere.  SOS!
0
healthcomputingCommented:
I will open a new question, so you geniuses can get some points.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.