Running and sleeping processes

Hi there,
Can somebody tell me the differences between SLEEPING and RUNNING
processes? I cannot find an explaination in BOL. If there is a thread on
this issue somewhere, can you put a link?
Tnx,
Hans Brouwer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sleeping status indicates that the SPID has completed execution and is
waiting for the application to submit another query or batch. A runnable
status indicates the SPID is currently processing a query
See
INF: Understanding and Resolving SQL Server 7.0 or 2000 Blocking Problems
PSS ID Number: 224453
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Hans Brouwer" <hansbrouwer@.hotmail.com> wrote in message
news:u$XIjMJlDHA.2500@.TK2MSFTNGP10.phx.gbl...
> Hi there,
> Can somebody tell me the differences between SLEEPING and RUNNING
> processes? I cannot find an explaination in BOL. If there is a thread on
> this issue somewhere, can you put a link?
> Tnx,
> Hans Brouwer
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Run Policies /Surface Area Configuration - Bug

Hi!

I've created the "Off By Default Policy" as described in BOL (ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/41c3022d-ab13-443e-ac64-ba1d64584f79.htm) for SQL Mail and Database Mail.

When I then activate SQL Mail and Database Mail through Surface Area Configuration (without closing it!) and then run the policy and configure it (so that SQL Mail and Database Mail) is then off, these changes are not reflected by Surface Area Configuration.

You must restart Surface Area Configuration, so that you can see the changes.

HTH

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

The SAC doesn't auto refresh but that seems quite normal to me.

Maybe a refresh button would be nice since restarting is not an intuitive way to refresh of course :-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

The Surface Area Configuration tool will most likely be pulled in a later CTP; probably as soon as we can support all of the server types (DB Engine, Analysis Services, and Reporting Services) in Management Studio using policies. For now you'll need to close and re-open the Surface Area Configuration tool to see the changes.

Cheers,

Dan