How to find active session on SQL Server 2008

In the  Microsoft SQL Server Management Studio click on "Activity monitor" - tab Procesess. In the context menu is possible to kill session/process.
Also look on others tabs, you can find many useful informations.