PrepAway - Latest Free Exam Questions & Answers

Tag: sql change collection

What should you do?

You are the SQL administrator for your company. You manage two SQL Server 2008 instances named SQL_Prod and SQL_Test.
You have configured data collection to occur on both instances.
The instances uploadthe data collection set data to the Management Data Warehouse located on SQL_Test.
A non-cached data collection set named Perf_collection that you created runs on a schedule to collect data from SQL_Test.
However, you notice that the performance of SQL_Test is adversely affected when Perf_collection runs.
You decide to configure Perf_collection so that different schedules are used for data collection and upload.
What should you do?