Tag: plan cache

  • Clear Procedure Cache in SQL Azure database

    When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache.

  • What’s new in DTA – SQL Server 2012

    DTA stands for Database Tuning Advisor which has introduced from SQL Server 2005. This utility helps the end user to tune their query and give them suggestions for better performance. It takes T-SQL query or profiler trace as workload, based on this it will analyze and give you the recommendation. Now in SQL Server 2012…