Query plan insight

Querying plan details by sproc name:

SELECT *
FROM sys.dm_exec_cached_plans
OUTER APPLY sys.dm_exec_query_plan(plan_handle)
WHERE objectid = object_id('rp_MerchantAdmin_ClubFinancialReport')

Get attribute of the qury plan

SELECT *
FROM sys.dm_exec_plan_attributes(0x050006005FAFDB0C40E14152020000000000000000000000)

Remove plans from procedure cache using the plan handle:

dbcc freeproccache(0x050006005FAFDB0C40C10FA2010000000000000000000000)