| title | Configure Properties of a Data Collector | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/01/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | article | ||
| f1_keywords |
|
||
| ms.assetid | cf98f57d-5a6d-4bc3-bf10-783e460fc63d | ||
| caps.latest.revision | 5 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
This topic discusses how you can configure the properties of a data collector.
Use this page to configure settings for the management data warehouse and specify where collected data should be stored before it is uploaded to the data warehouse.
Enable Data Collection
Select to enable data collection. This has the same effect as running the sp_syscollector_enable_collector stored procedure. Clearing this check box 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 is uploaded to the management data warehouse. If Cache directory is not specified, the data collector attempts to locate the %TEMP% and %TMP% environment variables and use one these locations as the default location for temporary storage. If these environment variables are not configured, an error occurs and you are prompted to create a cache directory.
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.
Manage Data Collection
Configure the Management Data Warehouse (SQL Server Management Studio)