Share via

  • Article

How to: Configure the Management Data Warehouse for Multiple Instances

You can configure the management data warehouse to support data storage for multiple instances of SQL Server that are using the data collector. These instances can be on the same server or on different servers.

Configure the management data warehouse for multiple instances

  1. Open SQL Server Management Studio on the first instance to create and configure the management data warehouse.

  2. In Object Explorer, expand the Management node.

  3. Right-click Data Collection, and then click Configure Management Data Warehouse.

    This starts the Configure Management Data Warehouse Wizard.

  4. Use the Configure Management Data Warehouse Wizard to create a management data warehouse, configure logins, enable data collection, and start the System Data Collection Sets. For more information, see Configure Management Data Warehouse Wizard F1 Help. 

    Note

    It is considered best practice to use proxies in deployments where the data collector is installed on multiple SQL Server instances that are using the same management data warehouse.

  5. Open SQL Server Management Studio on another instance and do either of the following:

    • Use the Configure Management Data Warehouse wizard to configure data collection for the existing management data warehouse.

    • Right-click Data Collection, and then click Properties. On the General tab, specify the existing management data warehouse and the server that it is installed on.

  6. Repeat step 5 until all the database instances that use the data collector are configured to upload data to the shared management data warehouse.