SQL Server Education (by the geeks, for the geeks)
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 …
SQL Server DTA: Finding Unused Indexes Read MoreThis 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 …
SQL SERVER DTA: Reducing production server test load. 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 More