Monitoring running processes in SQL Server 2008 R2

You can view the current connections and processes that running on a sql server instance in two ways Using Activity Monitor Using T-SQL statements