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?
A.
Stop data collection on SQL_Test . Edit the schedule of the Perf_collection data collection set. Restart datacollection on SQL_Test.
B.
Stop data collection on SQL_Test . Change the Perf_collection data collection set to cached, and edit theschedule of the data collection set.
Restart data collection on SQL_Test.
C.
Stop the Perf_collection data collection set. Edit the schedule of the Perf_collection data collection set.Restart the Perf_collection data collection set.
D.
Stop the Perf_collection data collection set. Change the Perf_collection data collection set to cached, andedit the schedule of the data collection set.
Restart the Perf_collection data collection set.
Explanation:
You should perform the following steps:
1. Stop the Perf_collection data collection set.
2. Change the Perf_collection data collection set to cached, and edit the schedule of the data collection set.
3. Restart the Perf_collection data collection set.
To change the settings of a data collection set, you only need to stop the set. Because the data collection set isnon-cached, both the collection and upload use the same schedule.
To configure them to use different schedules,you will need to change the data collection set to cached and edit the schedules accordingly. Then, you need torestart the data collection set. You should not stop data collection on SQL_Test , edit the schedule of the Perf_collection data collection set,and restart data collection on SQL_Test . Data collection can only be stopped when all data collection sets arestopped. In addition, because a cached data collection set is being used, you will need to change the mode tonon-cached before you will be able to edit the schedule. You should not stop data collection on SQL_Test , change the Perf_collection data collection set to cached, editthe schedule of the data collection set, and restart data collection on SQL_Test . Data collection can only bestopped when all data collection sets are stopped. You only need to edit a single data collection set. Stoppingdata collection would prevent all other data collection sets from running. You should not s top the Perf_collection data collection set, edit the schedule of the Perf_collection datacollection set, and restart the Perf_collection data collection set. Because a cached data collection set is beingused, you will need to change the mode to non-cached before you will be able to edit the schedule appropriately.Objective:
Optimizing SQL Server PerformanceSub-Objective:
Use Performance Studio.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > DataCollection > Managing Data Collection How-to Topics > Managing Data Collection Using SQL ServerManagement Studio > How to: View or Change Collection Set Schedules