Database engine tuning advisor Archives

SQL Server DTA: Finding Unused Indexes

May 30, 2012December 23, 2019 - by SQL Geek - 3 Comments.

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

SQL SERVER DTA: Reducing production server test load.

May 24, 2012December 23, 2019 - by SQL Geek - 4 Comments.

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 …