Discussion:
SP_WHO2: what are "sleeping" processes "awaiting command" ?
(too old to reply)
Timo
2004-04-13 17:15:50 UTC
Permalink
I couldn't restore a SQL database on my local development PC and so executed
SP_WHO2 based on some tips found online. Not sure, however, how to
interpret the results: there seem to be four processes "using" the database,
consuming 0 CPU, associated with .Net SqlClient Data Provider, with 01/01
00:00:00 in the LastBatch column, all with a status = "Sleeping", and
identified with a particular domain user (me). What are these entries and
can they be killed?
Thanks
Timo
Aaron Bertrand [MVP]
2004-04-13 17:19:54 UTC
Permalink
Sounds like you have 4 instances of a client app (or multiple threads in
one) that are connected to the database but not doing anything.

There are some tips here for freeing up connections, equally applicable to
DROP as any other action such as RESTORE.
http://www.aspfaq.com/2518
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Post by Timo
I couldn't restore a SQL database on my local development PC and so executed
SP_WHO2 based on some tips found online. Not sure, however, how to
interpret the results: there seem to be four processes "using" the database,
consuming 0 CPU, associated with .Net SqlClient Data Provider, with 01/01
00:00:00 in the LastBatch column, all with a status = "Sleeping", and
identified with a particular domain user (me). What are these entries and
can they be killed?
Thanks
Timo
Loading...