T SQL clear stored procedure cache
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 …
Read MoreTag: Plan Cache
SQL Server 2012 – “Denali” Database Tuning Advisor (DTA): Tune a database using Plan cache.
Hi 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 …
Read MoreSQL Server: Extracting the Execution Plan from SQL Server Plan Cache
Hi 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. …
Read More