Query Execution Plan in SQL

set showplan_xml off

set statistics profile off

select * from sys.messages
where message_id=3902


select * from sys.dm_exec_cached_plans --returns plan type,memory size and usecounts


select * from sys.dm_exec_query_stats --returns last execution time,

select * from sys.dm_exec_requests --returns plans that are currently excuting.