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?
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 SQLServer 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 collectorset, 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 SQLServer 2008. It collects statistical information regarding queries and is a cached data collection set. A cached datacollection set uses different schedules for the collection and upload of the data. It does not collect informationabout database or log file growth. You should not start the Server Activity Collection Set . This data collection set is also installed with SQL Server2008. It collects statistical information on resource usage and performance information from the server and is acached 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 acustom 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, youshould not create a cached data collection set because a cached data collection set uses different schedules forthe 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 acustom 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 datacollection set runs on a pre-configured schedule. An on-demand data collection set runs only when started by anadministrator.
Objective:
Optimizing SQL Server PerformanceSub-Objective:
Use Performance Studio.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > DataCollection > System Data Collection Sets