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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-07 : 09:48:47
|
| Raed writes "Why Some Process Still Exist in Sql Server with statusSlepping and we see the executed Command we see in GeneralSp_CursorClose what this Process Mean whith Sleeping Statuswith this Command Especially when the Execution Finished andkeep this process Why!" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-09-07 : 10:06:34
|
| these are just open connections to systems that at some point had initiated communication with your sql server. The connection will become active if those hosts begin interacting with the sql server again, otherwise they stay in the sleeping state.You really don't need to worry about sleeping connections at all. How many sleeping connections are you seeing? -ec |
 |
|
|
|
|
|
Blocking