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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 all sqlserver process switch to sleeping state

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2010-07-18 : 19:48:07
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.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-19 : 01:44:14
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
   

- Advertisement -