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?
A.
Start the Query Statistics Collection Set.
B.
Start the Server Activity Collection Set.
C.
Start the Disk Usage Collection Set.
D.
Create and start a scheduled, cached custom data collection set.
E.
Create and start a scheduled, non-cached custom data collection set.
Explanation:
You should start the Disk Usage Collection Set, one of the three system data collector sets installed with SQL Server 2008. This data collector set collects information about database and log file growth for all databases and provides statistical information collected throughout the day. This data collector set is a non-cached data collector set, meaning that the same schedule is used for both the collection and upload of the data. You should not start the Query Statistics Collection Set. This data collection set is also installed with SQL Server 2008. It collects statistical information regarding queries and is a cached data collection set. A cached data collection set uses different schedules for the collection and upload of the data. It does not collect information about database or log file growth. You should not start the Server Activity Collection Set. This data collection set is also installed with SQL Server 2008. It collects statistical information on resource usage and performance information from the server and is a cached data collection set. It does not collect information about database or log file growth. You should not create and start a scheduled, cached custom data collection set. You do not need to create a custom data collection set because a system data collection set already exists that will collect the required data. Creating a custom data collection set would require more administrative effort than is necessary. In addition, you should not create a cached data collection set because a cached data collection set uses different schedules for the collection and upload of the data. You should not create and start a scheduled, non-cached custom data collection set. You do not need to create a custom data collection set because a system data collection set already exists that will collect the required data. Creating a custom data collection set would require more administrative effort than is necessary. A non-cached data collection set can be configured to run on a schedule or on demand. A scheduled data collection set runs on a pre-configured schedule. An on-demand data collection set runs only when started by an administrator.Objective: Optimizing SQL Server Performance Sub-Objective: Use Performance Studio.
References: TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > Product Documentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > Data Collection > System Data Collection Sets