PrepAway - Latest Free Exam Questions & Answers

Tag: custom data collection set

What should you do?

You are the SQL administrator for your company. You manage a SQL Server 2008 instance named SQL_1.
The instance contains two production databases used by your company.
You need to collect performance data on the growth of all the database and log files within both databases.
Thedata must be collected in the Management Data Warehouse.
Your solution needs to use the same schedule forthe collection and upload of the data.
Your solution must meet the requirements while using the leastadministrative effort.
What should you do?

What should you do?

You are the SQL administrator for your company. You manage a SQL Server 2008 instance named SQL_1. The instance contains two production databases used by your company. You need to collect performance data on the growth of all the database and log files within both databases. The data must be collected in the Management Data Warehouse. Your solution needs to use the same schedule for the collection and upload of the data. Your solution must meet the requirements while using the least administrative effort. What should you do?