The Microsoft SQL Server Database Engine Tuning Advisor helps you to optimize database configuration by identifying an optimal set of indexes, indexed views and partitions without requiring an expert understanding of the database structure. It advises you by analyzing a certain workload by using trace files, trace tables or T-SQL scripts as input.
The Database Engine Tuning Advisor will then give you certain recommendations to add, remove or modify certain settings in your Microsoft SQL Server database.