YOU HAVE DECIDED TO USE THE NEW SQL SERVER 2008 DATA COLLECTOR FEA...

19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P66 DOC
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P66 DOC
19. You have decided to use the new SQL Server 2008 Data Collector feature to collect performance data from several servers in your organization. You install a SQL Server 2008 on a new server and run through the Configure Management Data Warehouse Wizard to set up data collection. One week later you view the performance reports and see that no data has been collected all week. What should you do to troubleshoot this issue (choose all that apply)?A. Check that SQL Server Agent service is running and is configured for Automatic startup.B. Check that SQL Server Data Collector service is running and is configured for Automatic startup.C. Check that the recovery model on Management Data Warehouse is not set to SIMPLE.D. Check that you have configured Data Collector proxy accounts so that they have permissions on the servers you are collecting data from.