The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P63: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 292 Chapter 7 Maintaining Your Database Figure Example Default Data Collector Report EXERCISE Using the Data Collector In this exercise you will configure the Data Collector feature of SQL Server 2008 enable performance data collection and finally view Data Collector reports. Before you begin you must have the following software installed on your computer SQL Server 2008 a free trial is available for download SQL Server 2008 Reporting Services optional AdventureWorks2008 sample database SQL Agent must be started Maintaining Your Database Chapter 7 293 Once you have met these requirements you may begin. 1. Open SQL Server Management Studio. To do this click Start All Programs Microsoft SQL Server 2008 SQL Server Management Studio. 2. In the Object Explorer pane on the left expand Management right-click Data Collection then click Configure Management Data Warehouse Wizard. On the Welcome page click Next. 3. In the Configure Management Data Warehouse Wizard ensure that Create or upgrade a management data warehouse is selected then click Next. 4. Configure the data warehouse to be stored on the local server using a new database named DataCollectorDW. Click Next Finish. Wait for the configuration to complete then click Close. 5. In the Object Explorer pane on the left expand Management right-click Data Collection then click Configure Management Data Warehouse Wizard. On the Welcome page click Next. 6. In the Configure Management Data Warehouse Wizard ensure that Set up data collection is selected then click Next. 7. Choose to use the DataCollectorDW database on the local server you have just created. Choose to use C Temp as the cache directory. Click Next Finish. Wait for the configuration to complete then click Close. 8. In the Object Explorer pane expand Data Collector System Data Collection Sets. 9. If you have SQL Server 2008 Reporting Services right-click Disk Usage Reports Historical Disk Usage Summary and view the report data. Close the report. 10. .
