Sql Server 2005 DMV's

Some interesting DMV's in SQL SERVER 2005

sys.dm_tran_locks
sys.dm_exec_cached_plans
sys.dm_exec_query_plan
sys.dm_exec_sessions
sys.dm_tran_session_transactions
sys.dm_exec_requests