You are employed as a database administrator at Domain.com. All servers on the Domain.com network run Windows 2000 Server and all client computers run Windows 2000 Professional.
Domain.com contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Data. Domain.com also contains another SQL Server 2005 database server named Certkiller -DB02, which has the latest copy of CK_Data. The database CK_Data on Certkiller _DB01 runs 24/7.
During routine monitoring you detect a high number of full scans on Certkiller -DB01. You then come to the conclusion that extra indexes are needed on CK_Data. A workload file that is suitable for Database Engine Tuning Advisor (DTA) already exists.
You need to analyze the workload file by using DTA without compromising the performance on Certkiller -DB01 during the analysis. You also need to make sure that availability during the implementation of any recommendations suggested by the DTA is maintained.
What actions should you take?