SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

alejo46
Posting Yak Master

Colombia
138 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.

GilaMonster
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  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000