A.DB1isinuse24hoursaday,7daysaweek.ArecentcopyofDB1existsonasecondservernamedSQLtestthatalsorunsSQLServer2005.YoudetectahighnumberoffullscansonSQL1andconcludethatadditionalindexesinDB1areneeded.AworkloadfilethatissuitableforDatabaseEngineTuningAdvisor(DTA)alreadyexists.
B.YoumustensuremaximumperformanceonSQL1duringanalysis.YoumustalsoensureavailabilityduringtheimplementationofanyrecommendationssuggestedbytheDTA.