Configure MDW Data Collectors

Previous Create MDW Database	Manual Configuration	Set Data Collector Job Names Next

FineBuild can configure the Management Data Warehouse data collectors.

The MDW data collectors perform the task of collecting performance-related information on the host server and posting it for storage on the MDW database. Each collector gathers information for a specific aspect of performance.

FineBuild Configure MDW Data Collectors

The configuration of the MDW database within FineBuild is broken down into a number of stages, in order to simplify restart processing if any of them fail.

This section describes how to configure the MDW data collectors. The MDW Data Collector configuration relates to Process Id 5EDE.

Disable Collector Process

The collector process must be disabled before the configuration of Data Collectors can be done. Using SQL Server Management Studio, run the following statement in a query window using the msdb database context
```
EXEC dbo.sp_syscollector_disable_collector
```
Select the MDW database

The server and SQL instance name that hosts the MDW database must be specified. Using SQL Server Management Studio, run the following statement in a query window. Use the relevant server name in place of server. If the MDW is hosted on the default instance of SQL Server, do not specify the instance name. If the MDW is hosted on a named instance, add the instance name to the server name
```
EXEC dbo.sp_syscollector_set_warehouse_instance_name @instance_name='server'
```
The database name that hosts the MDW database must be specified. Using SQL Server Management Studio, run the following statement in a query window. Use the relevant database name in place of database
```
EXEC dbo.sp_syscollector_set_warehouse_database_name @database_name='database'
```
Start Data Collectors

The data collectors can now be started. Three data collectors are included in the standard SQL Server installation, and all these will be started. Using SQL Server Management Studio, run the following statements in a query window. Running these commands will also cause the required jobs to be created that run the collection process
```
EXEC dbo.sp_syscollector_start_collection_set @collection_set_id=1
EXEC dbo.sp_syscollector_start_collection_set @collection_set_id=2
EXEC dbo.sp_syscollector_start_collection_set @collection_set_id=3
```
Enable Collection Process

All configuration is complete and the collector process can be enabled. Using SQL Server Management Studio, run the following statement in a query window:
```
EXEC dbo.sp_syscollector_enable_collector
```

Top

Manual Configure MDW Data Collectors

The following steps show what you would have to do for manual Configure MDW Data Collectors. FineBuild does all of this work for you automatically.

Following completion of configuring the MDW, the Data Collectors can now be configured.

Using SQL Server Management Studio, navigate to Data Collection

Right-click and select Configure Management Data Warehouse
The Welcome screen is displayed

Click Next to continue
The Select configuration task window is displayed

Select Set up data collection, and then click Next to continue
The Configure Management Data Warehouse Storage window is displayed

Click on the ellipses on the Server name line to select the server that will host the data that is collected
Ensure the correct server and instance are shown in the Server name box

Click Connect
Set the Database name value to the MDW database

Click Next to continue
The Complete the Wizard window is displayed

Click Finish to continue
The Configure Data Collection Wizard progress window is displayed

Click Close to end