You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2 to administrate and maintain its database. You have received instruction from management to create a strategy that makes use of the data collector is utilized to collect performance information. Your strategy should also allow for 15 day old information to be removed, and also reduce the amount of effort required to administer the performance information. Which of the following actions should you take?
A. You should consider creating a single SQL Server 2008 R2 Analysis Services (SSAS) package process to reserve and remove performance information.
B. You should consider setting a management data warehouse process on every instance to reserve and remove performance information in one database for all the instances.
C. You should consider creating a single SQL Service Integration Services (SSIS) package process to reserve and remove performance information.
D. You should consider creating a single SQL Server 2008 R2 Reporting Services (SSRS).
Answer: B
No comments:
Post a Comment
Note: only a member of this blog may post a comment.