Which data collection process should you implement?

Yon manage several SQL Server 2008 instances.
You plan to collect performance data periodically on all instances by using the data collector.
All collected data must be stored in the same database hosted on a single instance. You
need to collect and load performance data in the management data warehouse every 6
hours. Which data collection process should you implement?

Yon manage several SQL Server 2008 instances.
You plan to collect performance data periodically on all instances by using the data collector.
All collected data must be stored in the same database hosted on a single instance. You
need to collect and load performance data in the management data warehouse every 6
hours. Which data collection process should you implement?

A.
Create a cached data collection.

B.
Create a scheduled non-cached data collection.

C.
Create an on-demand non-cached data collection.

D.
Create two different SQL Agent jobs that are scheduled at the same time. One job
creates a data collection and the other job uploads the data collection.



Leave a Reply 0

Your email address will not be published. Required fields are marked *