SQL Server DTA: Finding Unused Indexes
This is another good feature of DTA. There are lot of different scripts available over internet to find unused indexes, however why not use the SQL Servers very own DTA to …
Read MoreTag: dta
SQL SERVER DTA: Reducing production server test load.
This feature creates a copy of a database to be tuned on a specified test server and runs the tuning process on that test server. The recommendations suggested can then be …
Read MoreSQL 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 More