Monitor

Links

• Monitoring Stored Procedure Usage

• SQL SERVER - Find Currently Running Query - T-SQL

Profiler

• Using SQL Server Profiler

Transactions

From Management Studio:

dbcc opentran(<database name>)