Your company has just launched a new in-house application for call monitoring. However, the database is performing poorly and you have been asked to investigate why. You have opted to use the Database Engine Tuning Advisor. What does this tool need to run?

 Posted by Bandi on 7/2/2014 | Category: Sql Server Interview questions | Views: 2059 | Points: 40
Select from following answers:
  1. Nothing, you just start the advisor during the peak usage period
  2. A trace file to run against
  3. The database must be offline and not in use
  4. An xml configuration file of the database to analyze
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response