Tag Archives: workload

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 it has been extended to include plan cache as workload, which means now you can directly point your db plan cache for analysis.

Continue reading What’s new in DTA – SQL Server 2012