O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

43.1

Figure 43.2 Configure Management Data Warehouse Wizard.

43.2
4. Click the Next button. The Select Configuration Task screen displays, as shown in Figure 43.3.

Figure 43.3 Select Configuration Task screen.

43.3
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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required