O'Reilly logo

SQL Server 2008: Administration in Action by Rod Colledge

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

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

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