USE AdventureWorks;
GO
DBCC FREEPROCCACHE;
GO
SELECT * FROM Sales.SalesOrderHeader
WHERE SalesOrderID = 43665;
GO
SELECT * FROM Sales.SalesOrderHeader
WHERE SalesOrderID = 71056;
GO
SELECT plan_handle, usecounts, cacheobjtype,
       objtype, [text],
       tqp.query_plan as text_query_plan,
       xqp.query_plan as xml_query_plan
FROM sys.dm_exec_cached_plans P
    CROSS APPLY sys.dm_exec_sql_text(plan_handle)
    CROSS APPLY sys.dm_exec_text_query_plan
       (plan_handle, 0, -1) tqp
    CROSS APPLY sys.dm_exec_query_plan
       (plan_handle) xqp
WHERE cacheobjtype = 'Compiled Plan'
    AND [text] NOT LIKE '%sys.dm_%';