Configuring MDW
This section demonstrates how to configure MDW. The first step is to make sure that SQL Agent is running and SQL Server Integration Services (SSIS) is installed and running as well. Assuming those two prerequisites have been met, follow these steps to configure MDW.
1. Launch SQL Server Management Studio, and connect to the SQL Server 2012 Database Engine where you want to configure MDW.
2. Expand the Management section, and right-click Data Collection.
3. From the context menu, select Configure Management Data Warehouse, as shown in Figure 43.1. The Configure Management Data Warehouse Wizard screen displays, as shown in Figure 43.2.
Figure 43.1 Configure Management Data Warehouse context menu.
Figure 43.2 Configure Management Data Warehouse Wizard.
4. Click the Next button. The Select Configuration Task screen displays, as shown in Figure 43.3.
Figure 43.3 Select Configuration Task screen.
5. Select the Create or Upgrade a Management Data Warehouse option, and click Next. The Configure Management Data Warehouse Storage screen displays, as shown in Figure 43.4.
Figure 43.4 Configure Management Data Warehouse Storage screen.
6. Select an existing database, ...
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
