You need to ensure that the following requirements are met: -The data collector is used to gather performance information

You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
-The data collector is used to gather performance information. -A single database stores
performance information for all instances. -Performance information that is older than 14
days is deleted. -Administrative effort to manage performance data is minimized.
What should you do?

You maintain multiple SQL Server 2008 instances.
You are designing a consolidated repository of performance data.
You need to ensure that the following requirements are met:
-The data collector is used to gather performance information. -A single database stores
performance information for all instances. -Performance information that is older than 14
days is deleted. -Administrative effort to manage performance data is minimized.
What should you do?

A.
Create and schedule a single Microsoft SQL Service Integration Services (SSIS) package
process to store and delete performance data in a single database for all instances.

B.
Create a SQL Agent job process on each instance to store and delete performance data
in a single database for all instances.

C.
Configure a management data warehouse process on each instance to store and delete
performance data in a single database for all instances.

D.
Configure an automated server-side trace process on each instance to store and delete
performance data in a single database for all instances.



Leave a Reply 0

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