Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

983


Chapter 43: Management Data Warehouse


43


Setting Up Data Collection


After you confi gure the Management Data Warehouse collection database, you need to confi g-
ure the instance to start collecting data from. To set up data collection, follow these steps:


  1. Run the Confi gure Management Data Warehouse Wizard again. Refer to steps 1
    and 2 from the previous section.

  2. In the Task Selection screen, select Set Up Data Collection, and click Next, as shown
    in Figure 43-8.


FIGURE 43-8
Set Up Data Collection task option.


  1. Select the server name and database to store the collected data. In this example,
    it should be the server and database confi gured in the previous section. In this
    screen, you can also select a folder to temporarily store collected data before it
    uploads to the MDW database. If no folder is selected, the TEMP folder will be used.
    Click Next. Figure 43-9 shows the MDW storage confi guration screen.

  2. Review the summary of actions to be performed, and click Finish, as shown in
    Figure 43-10.


c43.indd 983c43.indd 983 7/31/2012 10:18:45 AM7/31/2012 10:18:45 AM


http://www.it-ebooks.info
Free download pdf