Killing a task in SQL Server

[sunnyjassal]

I would like to know how to check who and what process is running in the database. For example, lets say if someone or some application is running a query that is causing the database to slow down, I would like to see all tasks that are currently being processed therefore finding the problematic task. How can I view these tasks and how would I kill it?

Thank you for your help in advance.

 

[vongrunt]

sp_who to get list of processes, kill <spid> to kill process. In addition, Ctrl-1 key in QA is mapped by default to execute sp_who.

EM can do the same, but refresh is pain in the a** (you must click on correct node in EM tree then hit F5).

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba