The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P122: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Performance Tuning Chapter 13 587 Management Data Warehouse The Management Data Warehouse MDW is the relational database used to store the data collected from the monitored servers data collection targets . The MDW is just a normal relational database hosted on SQL Server 2008 that needs to be configured by the Administrator before data collection can begin. The MDW can be used to capture data from the same instance or from remote instances. In many deployment scenarios it is intended that MDW is used as an enterprisewide repository for system and custom collection sets from many target servers. The management reports are produced using the data stored in the MDW . Configuring MDW The MDW must be set up prior to data collection being configured since the MDW must be supplied as the target for data collection. To launch the MDW configuration wizard within Management Studio within the Management folder right-click Data Collection and choose Configure Management Data Warehouse as shown in Figure . Figure Launch the Wizard to Configure Management Data Warehouse 588 Chapter 13 Performance Tuning Launching the configuration wizard the first screen displays a Welcome notice. Click Next to continue as shown in Figure . Figure Welcome Screen for Data Management Warehouse The next step in the wizard is to select either to Create or upgrade a MDW or to Set up data collection. Since data collection requires an MDW it should be set up first. As shown in Figure verify Configure or upgrade a management data warehouse then click Next. Performance Tuning Chapter 13 589 Figure Select Configure or Upgrade an MDW to Set Up the MDW Next the wizard requests details of the database to be used as the MDW In most cases we ll need to create a new database to use for this purpose otherwise choose an existing database from the drop-down list. Click the New button to create a new database shown in Figure
