Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 all sqlserver process switch to sleeping state
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

157 Posts

Posted - 07/18/2010 :  19:48:07  Show Profile  Reply with Quote
Good afternoon
I need your help.

These days have been a kind of nightmare in our company since our 2000 sqlserver has colapsed and all processes running switched from runnable to sleeping processes and remain sleeping.

The ongoing solution is to kill all proceses, restart the server, so the instance and start over again, but i dont think this is the smartest idea to find out the problem "From the root".

i dont know if it is an internal process, a Datbase corcern, otr the server resources itself.

I'll appreciate your help.

Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 07/19/2010 :  01:44:14  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Sleeping just means not currently running a query. It means the connection is open, but there are no pending requests. Runnable is not a state for a SQL connection.
Sleeping = waiting for something to do
Running = currently executing a query
Suspended = waiting for a resource (lock, latch, etc)

Typically lots of sleeping connections indicates an app that's either using a connected architecture (open connection and never close it), or one that's careless about closing connections once done.

Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000