Select from following answers:- Nothing, you just start the advisor during the peak usage period
- A trace file to run against

- The database must be offline and not in use
- An xml configuration file of the database to analyze
- All Above
Database Engine Tuning Advisor analyzes a workload and the physical implementation of one or more databases. A workload is a set of Transact-SQL statements that execute against a database or databases that you want to tune. Database Engine Tuning Advisor uses trace files, trace tables, or Transact-SQL scripts as workload input when tuning databases
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator