Configure properties of a data collector

Applies to: SQL Server

This article discusses how you can configure the properties of a data collector.

Data Collection properties (General tab)

Use this page to configure settings for the management data warehouse, and specify where collected data should be stored before it uploads to the data warehouse.

Enable Data Collection

Select this checkbox to enable data collection. This has the same effect as running the sp_syscollector_enable_collector stored procedure. Clearing this checkbox disables data collection and has the same effect as running the sp_syscollector_disable_collector stored procedure.

Server

Displays the name of the server that will host the management data warehouse

Database name

Displays the name of the relational database that is used for the management data warehouse.

Test connection

Test the connection to the specified Server using information provided when data collection is configured.

Cache directory

Specifies the directory where collected data is stored on the system collecting the data before it's uploaded to the management data warehouse. If Cache directory isn't specified, the data collector attempts to locate the %TEMP% and %TMP% environment variables, and uses one these locations as the default location for temporary storage. If these environment variables aren't configured, an error occurs and you're prompted to create a cache directory.

Data Collection properties (Advanced tab)

Use this page to configure the retry settings for the connection to the management data warehouse.

Number of times to retry if upload fails

Specifies the number of times to retry an upload to the management data warehouse if an upload fails. The default is 1.