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 |
|
CanadaDBA
583 Posts |
 Posted - 2006-07-24 : 14:07:34
|
| In EM under the Process Info I see some lines which the Last Batch has a value of 1/1/1900 12:00:00 AM. All of their status are runnable and the Wait Type is NETWORKIO.Are these Orphaned processes? Can I kill them without affecting any user?Thanks,Canada DBACanada DBA |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-24 : 22:10:43
|
| you can check what the process is doing, use dbcc inputbufferand decide if you want to kill the processbut runnable means the process have been completed, do you wish to disconnect the owner of that process?--------------------keeping it simple... |
 |
|
|
|
|
|
Orphaned process