Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is making use of a SQL Server 2008
R2 instance.
You have been given the responsibility of administering a management data warehouse that will
store performance information. You want to configure a data collector that has the ability to collect
performance information regularly on a defined schedule, and upload the collect performance
information on a separate schedule.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is making use of a SQL Server 2008
R2 instance.
You have been given the responsibility of administering a management data warehouse that will
store performance information. You want to configure a data collector that has the ability to collect
performance information regularly on a defined schedule, and upload the collect performance
information on a separate schedule.
Which of the following actions should you take?

A.
You should consider configuring the Event log.

B.
You should consider configuring the Trace log.

C.
You should consider developing a cached data collection.

D.
You should consider developing a scheduled non-cached data collection set.

Explanation:



Leave a Reply 0

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