Which two tasks should you include in your design?

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning

information. You need to design a long-term infrastructure monitoring strategy. Which two
tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning

information. You need to design a long-term infrastructure monitoring strategy. Which two
tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

A.
Clear the system log and the application log every hour.

B.
Review system monitor counters on a regular basis.

C.
Baseline the system before you deploy production databases.

D.
Create a maintenance plan that rebuilds indexes every week.

E.
Backup all databases every day.



Leave a Reply 0

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