SQL Server Education (by the geeks, for the geeks)
SQL Server stores the compiled plans of procedures being executed so as to increase procedure performance. A plan is compiled and saved first time a procedure is executed and is used …
T SQL clear stored procedure cache Read MoreHi friends, Just came across Database Tuning Advisor new feature in SQL Server 2012. It can now tune the events from the plan cache directly. This is a very good option …
SQL Server 2012 – “Denali” Database Tuning Advisor (DTA): Tune a database using Plan cache. Read MoreHi Friends, There may be a number of reasons why you would want to extract the execution plan from the plan cache – most important for troubleshooting and performance tuning reasons. …
SQL Server: Extracting the Execution Plan from SQL Server Plan Cache Read More