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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-06-28 : 10:28:36
|
| Hi,I have one process in that is in wait state since last 2 weeks. In process type it shows MSQL_XP. It is system background process run by sa. It is right now trying to execute sp. It may be external sp. I don't know what it is doing right now. But it is in wait state for last 2 weeks. It is also consuming cpu. In cpu consumption column in activity monitor it is on the top. I want to remove/delete this process. Please let me know how to handle this situation?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-28 : 10:38:35
|
| Get the session_id/SPID from the report and KILL it (e.g. spid 101):KILL 101 |
 |
|
|
|
|
|
Processs in wait state