SQL 2005 Current Activity | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 2005 Current Activity

Hi – How do I look at user current activity in managemnet studio for SQL Server 2005?
Under management.. Activity Monitor
Which essentillay uses the sysprocesses ,sys.dm_exec_sessions and sys.dm_tran_locks DMVs Roji. P. Thomas
SQL Server MVP