Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache. In SQL Server there are multiple DMV (Dynamic Management Views) and DMO (Dynamic Management Objects) which can be used to retrieve the information about execution plan. Sys.dm_exec_query_plan is most commonly used DMO which is used… Continue reading SQL Server – How to retrieve SQL plans from Cache