15.2. Setup and configuration

We use SQL Server Management Studio to begin the process of configuring the data collection platform for a SQL Server 2008 instance,[] with the first step being the selection (or creation) of the MDW.

[] SQL Server 2005 instances (and earlier) cannot be configured for data collection.

15.2.1. MDW selection or creation

Right-clicking Data Collection under the Management node in SQL Server Management Studio allows you to select the Configure Management Data Warehouse menu option, which starts the Configure Management Data Warehouse Wizard. The first wizard step presents two options, as shown in figure 15.2: Create or Upgrade a Management Data Warehouse and Set Up Data Collection. According to the provided option descriptions, ...

Get SQL Server 2008 Administration in Action 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.